The Ultimate Guide to High Availability with MariaDB

Comments - Upgrade from old Mysql install to recent Mariadb.

11 months, 4 weeks ago Roger Wolff
Re: Upgrade from old Mysql install to recent Mariadb.

This doesn't help: I still have to go into the application, find where it stores the password and then change it to the new password, or copy the old password into the commandline you're giving. :-(

OK. Maybe it helps a little bit. I could find a first application, extract the password, change the password to the new format for testing, and then I'd know that on D-day I can dump the database, and import it into mariadb.

Testing: So your first commandline gave

  mysql> SELECT user, plugin FROM mysql.user where plugin like "%sha%";
  Empty set (0.00 sec)

and then I tried: 

 mysql> SELECT user, plugin FROM mysql.user ;
 +------------------+-----------------------+
 | user             | plugin                | 
 +------------------+-----------------------+
 | root             | mysql_native_password |
 | root             | mysql_native_password |
 | xxxx....         | mysql_native_password |
...

So. All users are already on mysql_native_password.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.