MySQL5 7 ERROR 1142 42000 问题

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

1，mysql全库导入报错

[root@dev_121_21 ~]# mysql--socket=/usr/local/mysql/mysql.sock --default-character-set=utf8</home/alldb_20160605.sql

 

ERROR 1142 (42000) at line 266079: SELECT,LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts'

[root@dev_121_21 ~]#

 

2，查看accounts表

mysql> SELECT * FROM information_schema.`TABLES` t WHERE t.`TABLE_NAME`='accounts'\G;   *************************** 1. ROW ***************************     TABLE_CATALOG:  def      TABLE_SCHEMA:  performance_schema        TABLE_NAME:  accounts        TABLE_TYPE:  BASE TABLE            ENGINE:  PERFORMANCE_SCHEMA           VERSION: 10