数据库

mysql赋权

云博小周宇1 Min Read

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

  1. grant all privileges on . to ‘123‘@‘%‘ identified by ‘123‘ with grant option;
    flush privileges;

#给用户cacti赋予所有库的所有权限GRANT?ALL?PRIVILEGES?ON?*.*?TO?‘cacti‘@‘%‘?IDENTIFIED?BY?‘cacti‘?WITH?GRANT?OPTION;??
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; ?