Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.12
-
Centos 7
Description
I have build a rpm from mariadb tarball. When I install it from cent os 7.I encount the following strange behavior ：
MariaDB [(none)]> show grants for lcs;
|
+----------------------------------------------------------------------------------------------------+
|
| Grants for lcs@% |
|
+----------------------------------------------------------------------------------------------------+
|
| GRANT USAGE ON *.* TO 'lcs'@'%' IDENTIFIED BY PASSWORD '*C2ECDF0BCD9219C43E8C4781BF515F8F9429EA82' |
|
| GRANT ALL PRIVILEGES ON `lcsdb`.* TO 'lcs'@'%' |
|
+----------------------------------------------------------------------------------------------------+
|
2 rows in set (0.00 sec)
|
|
|
MariaDB [(none)]> quit
|
Bye
|
[root@localhost code]# /usr/local/mysql/bin/mysql -ulcs
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 542
|
Server version: 10.1.12-MariaDB Source distribution
|
|
|
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
|
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
|
MariaDB [(none)]>
|
[root@localhost code]# /usr/local/mysql/bin/mysql -ulcs -plcs
|
ERROR 1045 (28000): Access denied for user 'lcs'@'localhost' (using password: YES)
|
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.