Migrate MySQL to MariaDB
You can move existing websites from a MySQL server to a MariaDB server using the Move website tool.
Critical Requirement
In order to successfully move a website from MySQL to MariaDB, you must delete any database users using caching_sha2_password and re-add them using mysql_native_password. You can retrieve existing passwords from the wp-config.php file. This is necessary because MariaDB does not support the caching_sha2_password plugin.
Migration Steps
- Open Websites in the left side bar.
- Select one or more websites that you would like to move and click Move server.
- When the Move server page loads, select the destination server from the Database role drop-down menu.
- Click Next and then Continue to confirm the move.
You will be redirected to a progress page where you can monitor the migration status in real-time.