← Back to team overview

maria-discuss team mailing list archive

Re: SHOW GRANTS change?

 

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>:

> 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
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References