本文主要是介绍mysql全局权限账户%登录不上ERROR 1045 (28000): Access denied for user 'mhz'@'localhost' (using password: YES)，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
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)
http://blog.csdn.net/zzq900503/article/details/15336583
这篇关于mysql全局权限账户%登录不上ERROR 1045 (28000): Access denied for user 'mhz'@'localhost' (using password: YES)的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
