root用戶新建了一個數(shù)據(jù)庫，賦權(quán)限給用戶A，mysql

grant 權(quán)限 on 數(shù)據(jù)庫.數(shù)據(jù)表 to '用戶' @ '主機名';

grant all on db_test.* to 'test'@'%';

報錯以下：web

[Err] 1044 - Access denied for user 'root'@'%' to database 'db_test'

報錯能夠看出root沒有權(quán)限，查詢用戶表看root用戶權(quán)限sql

SELECT host,user,Grant_priv,Super_priv FROM mysql.user;

修改權(quán)限，執(zhí)行以下：數(shù)據(jù)庫

UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
FLUSH PRIVILEGES;