开心六月综合激情婷婷|欧美精品成人动漫二区|国产中文字幕综合色|亚洲人在线成视频

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

grant 權限 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沒有權限，查詢用戶表看root用戶權限sql

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

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

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