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赋予所有库的所有权限 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;