When upgrading between different major versions of MariaDB or MySQL you need to run the mysql_upgrade program to convert data that are incompatible between versions. This will also update your privilege tables in the mysql database to the latest format.
In almost all cases mysql_upgrade should be able to convert your tables, without you having to dump and restore your data.
After installing MariaDB, just do:
If you want to run with a specific TCP/IP port do:
mysql_upgrade --host=127.0.0.1 --port=3308 --protocol=tcp
If you want to connect with a socket do:
mysql_upgrade --socket=127.0.0.1 --protocol=socket
To see other options, use --help.
"mysql_upgrade" reads the my.cnf sections [mysql_upgrade] and [client] for default values.
There are a variety of reasons tables need to be converted; they could be any of the following:
SHOW TABLESuntil you convert them.
If you don't convert the tables, one of the following things may happen:
"mysql_upgrade" works by calling mysqlcheck with different options and running the "mysql_fix_privileges" script. If you have trouble with "mysql_upgrade", you can run these commands separately to get more information of what is going on.
Most of the things in the MySQL 5.1 manual section also applies to MariaDB.
The following differences exists between "mysql_upgrade" in MariaDB and MySQL (as of MariaDB 5.1.50):
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.