Linux Mysql 总结

一：Error Code: 1044. 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;刷新