解决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;