[MDEV-9729] strange mariadb server auth behavior Created: 2016-03-15 Updated: 2016-04-14 Resolved: 2016-04-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Authentication and Privilege System |
| Affects Version/s: | 10.1.12 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | chen yuanyuan | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
Centos 7 |
||
| Attachments: |
|
| Description |
|
I have build a rpm from mariadb tarball. When I install it from cent os 7.I encount the following strange behavior :
So I have create a user with a password,but I can login without it,moreover,if I try to login with the correct pwd,it fails. If I delete the mariadb data dir(/var/lib/mysql) and reinstall the rpm,then everything is normal. |
| Comments |
| Comment by Elena Stepanova [ 2016-03-15 ] | |
|
Please run
to check if you have the anonymous user ''@localhost. If you do, you need to remove it. When you log in, the anonymous user with specified host (localhost) takes priority over a named user without a specified host, that's an ancient and rather obscure MySQL feature. | |
| Comment by Elena Stepanova [ 2016-04-14 ] | |
|
Please comment to re-open if you have more information on the issue. |