Reset MySQL Root Password on FreeBSD,
eg. after a `DELETE FROM mysql.user`

1. /usr/local/etc/rc.d/mysql-server stop

2. either do a

   echo 'mysql_args="--skip-grant-tables"' >>/etc/rc.conf

   or modify /etc/rc.conf and mysql_args accordingly

3. block access to local MySQL server (adjust ipfw, shutdown apache, stop
   cron(-jobs), move /tmp/mysql.sock to a non-world readable directory, etc.

4. /usr/local/etc/rc.d/mysql-server start

5. connect to mysql and execute:

INSERT INTO mysql.user (Host, User, Password, ssl_cipher, x509_issuer,
x509_subject, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv,
Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv,
References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv,
Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv,
Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv,
Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv)
VALUES ('localhost', 'root', PASSWORD('test'), '', '',
'', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y');

6. quit mysql client and /usr/local/etc/rc.d/mysql-server stop

7. remove mysql_args from /etc/rc.conf and/or --skip-grant-tables from
   mysql_args

8. /usr/local/etc/rc.d/mysql-server start

9. insert remaining users into mysql.user