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