kb.hurricane-ridge.com

A brief summary of after-installation MySQL configuration when using FreeBSD’s ports system.

• Log into the database as root, and run the following commands to remove anonymous accounts:
use mysql;
delete from user where User='';
delete from db where User='';
flush privileges;
SET PASSWORD FOR root@localhost=PASSWORD('newgoodstrongpassword');
SET PASSWORD FOR root@127.0.0.1=PASSWORD('newgoodstrongpassword');
SET PASSWORD FOR root@host.example.com=PASSWORD('newgoodstrongpassword');