Mysql 5.0, installing

This MySQL guide DOES work, unlike the other MySQL guides on this wiki!

Installation from ports

# su
# cd /usr/ports/databases/mysql50-server
# make install clean
# mysql_install_db
# chown -R mysql /var/db/mysql/
# chgrp -R mysql /var/db/mysql/

Start MySQL

... From command:

# /usr/local/bin/mysqld_safe -user=mysql &

.. Or a handy pre-made script:

# /usr/local/etc/rc.d/mysql-server.sh

Starting MySQL on system boot

# echo 'mysql_enable="YES"' >> /etc/rc.conf

Creating the root password

To set the root password, replace "yourpass" with your desired password:

# mysqladmin -u root password yourpass

Note: If this command returns "command not found", type "rehash" in the CLI:

# rehash

Final Notes

Job done! You now have MySQL installed and running. Give yourself a pat on the back!