解决7.0Mysql 生成model 报错问SELECT command denied TO USER 'chinare'@'localhost' FOR TABLE 'db'权限问题

查看权限

SHOW GRANTS FOR chinare@localhost;

GRANT ALL PRIVILEGES ON chinare.* TO 'chinare'@'localhost';

SELECT command denied TO USER 'chinare'@'localhost' FOR TABLE 'db'

 

以上执行完毕没有效果

SELECT * FROM mysql.user

 

****************重点这条UPDATE 的语句执行以后可以使用

UPDATE mysql.user SET select_priv='Y' , insert_priv='Y', update_priv='Y', DELETE_priv='Y' WHERE USER = 'chinare';
FLUSH PRIVILEGES;