sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
sudo mysqld_safe --skip-grant-tables &
# mysql
mysql> use mysql;
mysql> UPDATE user SET password=password("test123") WHERE user='root';
mysql> flush privileges;
mysql> exit;
sudo /Library/StartupItems/MySQLCOM/MySQLCOM retart
如果出现ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)
则可以
sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
sudo mysqld_safe --skip-grant-tables
sudo mysqld_safe --skip-grant-tables &
# mysql
mysql> use mysql;
mysql> UPDATE user SET password=password("test123") WHERE user='root';
mysql> flush privileges;
mysql> exit;
sudo /Library/StartupItems/MySQLCOM/MySQLCOM retart
如果出现ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)
则可以
sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
sudo mysqld_safe --skip-grant-tables