Here are my quick and dirty setup notes for MySQL server
cd /usr/ports/databases/mysql51-server make install ee /etc/rc.conf add --/-- mysql_enable="YES" mysql_dbdir="/data/mysql" --/-- /usr/local/etc/rc.d/mysql-server start
Now we need to add a password to secure it and another password for remote admin:
mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('');
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' WITH GRANT OPTION;
exit
