← Back to team overview

maria-discuss team mailing list archive

Re: SHOW GRANTS change?

 

Hi, Felipe!

On Apr 13, Felipe Gasper wrote:
> Note: I believe “dbguy” came from a My5.6 -> Ma10.0 upgrade.
> 
> Is it possible that something in MariaDB isn’t reading MySQL stuff 
> correctly?

Could be. There was one issue in the way MySQL started confusing a
password and the authentication string for plugins.

Could you show the complete line for that user?
select * from mysql.user where user='dbguy' \G

Thanks!

Regards,
Sergei

> -FG
> 
> On 13 Apr 2015 2:14 PM, Felipe Gasper wrote:
> > 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


Follow ups

References