mysql table 'user' read only

Question

我用root用户登录，用grant语句新建一用户并对其授权，
没有成功，显示如下错误：table 'user' read only
请问这是为什么呀？如何改正？

Answer 1

root 登录并不代表你是 root%locahost 用户。做如下检查并把结果贴出来看看。select CURRENT_USER();
show grants;mysql> select CURRENT_USER();
+----------------+
| CURRENT_USER() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)mysql> show grants;
+-------------------------------------------------------------------------------
---------------------------------------------------------+
| Grants for root@localhost
                                                         |
+-------------------------------------------------------------------------------
---------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*23A
E809DDACAF96AF0FD78ED04B6A265E05AA257' WITH GRANT OPTION |
+-------------------------------------------------------------------------------
---------------------------------------------------------+
1 row in set (0.00 sec)mysql>