1.忘记密码
/mysqladmin -u root flush-privilges password "Admin123." --socket=/db/mysql_13306/tmp/mysql.sock
mysqladmin -u root -p shutdown
将newpassword替换为你要用的root的密码，第二个命令会提示你输入新密码，重复第一个命令输入的密码。
2.登录系统
./mysql -uroot -p --socket=/db/mysql_13306/tmp/mysql.sock
-
grant all privileges on . to ‘123‘@‘%‘ identified by ‘123‘ with grant option;
flush privileges;
#给用户cacti赋予所有库的所有权限br/>GRANT?ALL?PRIVILEGES?ON?*.*?TO?‘cacti‘@‘%‘?IDENTIFIED?BY?‘cacti‘?WITH?GRANT?OPTION;??
#重新载入赋权表??
FLUSH?PRIVILEGES;??
??
#收回权限(不包含赋权权限)??
REVOKE?ALL?PRIVILEGES?ON?.?FROM?cacti;??
REVOKE?ALL?PRIVILEGES?ON?cacti.?FROM?cacti;??
#收回赋权权限??
REVOKE?GRANT?OPTION?ON?.*?FROM?cacti;??
#重新载入赋权表??
FLUSH?PRIVILEGES; ?
mysql赋权
原文：http://blog.51cto.com/10884109/2315770
