mysql root給其它使用者授權問題

標籤：

今天登入mysql,給其它使用者授權遇到問題

mysql> grant all privileges on testdb.* to ‘dbuser‘@‘10.4.14.14‘ identified by ‘5jyeTQ‘;ERROR 1044 (42000): Access denied for user ‘root‘@‘localhost‘ to database ‘testdb‘

首先看一下root使用者有沒有grant許可權

mysql> select user,host,grant_priv from user;+--------+---------------+------------+| user   | host          | grant_priv |+--------+---------------+------------+| dbuser | 10.11.6.23    | N          || root   | localhost     | N          || root   | 127.0.0.1     | N          |+--------+---------------+------------+3 rows in set (0.00 sec)

看到root後面那兩個N了嗎，說明root使用者沒有grant許可權 ，現在修改一下

mysql> update user set grant_priv=‘Y‘ where user=‘root‘;Query OK, 2 rows affected (0.00 sec)Rows matched: 2  Changed: 2  Warnings: 0mysql> select user,host,grant_priv from user;+--------+---------------+------------+| user   | host          | grant_priv |+--------+---------------+------------+| dbname | 10.11.6.23    | N          || root   | localhost     | Y          || root   | 127.0.0.1     | Y          |+--------+---------------+------------+3 rows in set (0.00 sec)

現在變成Y了，flush privileges;重新整理一下許可權 ，然後授權試試

mysql> grant all privileges on testdb.* to ‘dbuser‘@‘10.4.14.14‘ identified by ‘5jyeTQ‘;Query OK, 0 rows affected (0.00 sec)

如果還是不行的話，重啟一下mysql.

mysql root給其它使用者授權問題