1. 新建了jira用户,发现不能密码登陆,错误如下:
[root@webserver1 bin]# mysql -u jira -p
Enter password:
ERROR 1045 (28000): Access denied for user 'jira'@'localhost' (using password: YES)
2. root登陆mysql后发现user表里面有两个用户名是空的用户,删除这两个用户,再次登陆就能够登陆了
MariaDB [mysql]> select Host,User from user;
+-----------+-----------+
| Host | User |
+-----------+-----------+
| % | jira |
| 127.0.0.1 | root |
| ::1 | root |
| bogon | |
| bogon | root |
| localhost | |
| localhost | root |
+-----------+-----------+