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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
