mysql全局权限账户%登录不上
ERROR 1045 (28000): Access denied for user 'mhz'@'localhost' (using password: YES)
解决
查看错误提示
有主机名字的就必须赋值主机名
mysql> GRANT ALL PRIVILEGES ON *.* TO 'mhz'@'
mgr2' IDENTIFIED BY 'mhz' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.07 sec)