Quick MySQL Server setup notes

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
This entry was posted in FreeBSD Administration and tagged . Bookmark the permalink.

Leave a Reply