ERROR 1045 (28000): Access denied for user 'mycat'@'localhost' (using password: YES)

最新推荐文章于 2023-03-24 11:19:25 发布

weixin_30787531

最新推荐文章于 2023-03-24 11:19:25 发布

阅读量380

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/polestar/p/7615937.html

版权

创建用户:
mysql> grant all on db1.* to mycat@'%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privlege;

查看:
mysql> select user,host from mysql.user;
+-------+-------------+
| user  | host        |
+-------+-------------+
| mycat | %           |
| root  | 127.0.0.1   |
| repl  | 192.168.2.% |
| root  | ::1         |
|       | localhost   |
| root  | localhost   |
|       | mysql01     |
| root  | mysql01     |
+-------+-------------+
8 rows in set (0.00 sec)

测试
[mysql@mysql01 ~]$ mysql -umycat -p123456 -h 127.0.0.1 -P3316
Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'mycat'@'localhost' (using password: YES)

解决方案:
[mysql@mysql01 ~]$ mysql -u root -p123456 -h 127.0.0.1 -P3316
mysql> use mysql
mysql> delete from user where user='';
mysql>  flush privileges; 

测试登陆成功
[mysql@mysql01 ~]$ mysql -umycat -p123456 -h 127.0.0.1 -P3316
mysql>

转载于:https://www.cnblogs.com/polestar/p/7615937.html