MySQL on FreeBSD 10

# pkg install mysql56-server
# echo ‘mysql_enable=”YES”‘>>/etc/rc.conf
# service mysql_server start

# mysql -u root
mysql> SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘rootpwd’);
mysql> SET PASSWORD FOR ‘root’@’host_name’ = PASSWORD(‘rootpwd’);

# mysql -u root
mysql> SET PASSWORD FOR ”@’localhost’ = PASSWORD(‘anonpwd’);
mysql> SET PASSWORD FOR ”@’host_name’ = PASSWORD(‘anonpwd’);

mysql> CREATE USER ‘colin’@’localhost’ IDENTIFIED BY ‘SuperPassword!’;
mysql> GRANT ALL ON *.* TO ‘colin’@’localhost’;
mysql> CREATE DATABASE zfsmon;
mysql> quit;