授權時報錯ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

一：問題描述

mysql> grant select on *.* to 'jiao';

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 二：出錯原因

該使用者沒有授權許可權 三：解決辦法

mysql> update mysql.user set Grant_Priv='Y' where user='root' and host='localhost';

mysql> flush privileges;
Query OK, 0 rows affected (0.07 sec)

或者通過grant ... with grant option;

退出後重新登入，再次授權即可

grant select on *.* to 'jiao';