Linux Mysql 总结
标签：
Linux Mysql 总结
. 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;刷新