Linux Mysql 总结
时间:2021-07-01 10:21:17
帮助过:2人阅读
. Access denied
for user
‘root‘@
‘%‘ to database
① mysql -u root -
p 进入到mysql中
②SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user; 查看权限
③UPDATE mysql.user SET Grant_priv=
‘Y‘, Super_priv=
‘Y‘ WHERE User=
‘root‘;修改权限
④FLUSH PRIVILEGES;刷新
Linux Mysql 总结
标签: