Mysql常见错误整理

一.mysql报错 1142 - SELECT command denied to user ‘root’@‘localhost’ for table 'user’
解决方法：1. D:\mysql\mysql-5.6.34-winx64\bin>mysql -uroot -p 输入密码时按回车这样是为了跳过权限登录或者百度搜敲过权限登录root账户
2.mysql> select * from user where user=‘liming’\G; 查看权限是N的修改成Y
update user set Update_priv=‘Y’ where user=‘root’;
3.flush privileges;
4.重新启动mysql: net start mysql;