Dear Guillaume,
This is what I see:
----------------
MariaDB [(none)]> select host, password from mysql.user where user='dbguy';
+-----------+-------------------------------------------+
| host | password |
+-----------+-------------------------------------------+
| localhost | *3D4FD9A495C3E81883E1A42AD351871F74F7CAA9 |
+-----------+-------------------------------------------+
1 row in set (0.00 sec)
MariaDB [(none)]> show grants for 'dbguy'@'localhost';
+----------------------------------------------------------------+
| Grants for dbguy@localhost |
+----------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dbguy'@'localhost' |
| GRANT ALL PRIVILEGES ON `dbguy\_goal`.* TO 'dbguy'@'localhost' |
+----------------------------------------------------------------+
2 rows in set (0.00 sec)
MariaDB [(none)]> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
---------------
That hash is the hash of the string '234wer'.
There does seem to be a bug here … ?
-FG
On 3 Apr 2015 2:42 AM, Guillaume Lefranc wrote:
Can't confirm that the password does not show up on 10.0.17. This works
as described below.
Any chance that you were executing SHOW GRANTS on a user without
password?
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.0.17-MariaDB MariaDB Server
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MariaDB [(none)]> show grants for bkp@'localhost'\G
*************************** 1. row ***************************
Grants for bkp@localhost: GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT
ON *.* TO 'bkp'@'localhost' IDENTIFIED BY PASSWORD
'*77863EC97510887DF16C59D8F7B8E31A0C584C7D'
2015-04-03 0:09 GMT+02:00 Felipe Gasper <felipe@xxxxxxxxxxxxxxxx
<mailto:felipe@xxxxxxxxxxxxxxxx>>:
Hi all,
I’ve noticed that MariaDB 10.0.14 shows an IDENTIFIED BY
PASSWORD .. section in SHOW GRANTS, but 10.0.17 doesn’t show the
password.
I can’t find anything to this effect in the changelog; was
this an intended change, or is it a bug?
The MariaDB docs show SHOW GRANTS behaving without the
password dump.
Thank you!
-FG
_________________________________________________
Mailing list: https://launchpad.net/~maria-__discuss
<https://launchpad.net/~maria-discuss>
Post to : maria-discuss@lists.launchpad.__net
<mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~maria-__discuss
<https://launchpad.net/~maria-discuss>
More help : https://help.launchpad.net/__ListHelp
<https://help.launchpad.net/ListHelp>
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
