maria-discuss team mailing list archive

[Felipe Gasper <felipe@xxxxxxxxxxxxxxxx>]

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>