Today I tried to move my two MariaDB 5 website databases towards the MariaDB 10 database, which is the only supported database on the latest Synology 7 version. First of all you have to export and import the used databases and users from MariaDB 5 to MariaDB 10 following this great Synology KB article. Be aware of the database users for the databases, keep the accounts and password equal on both MariaDB databases! Since MariaDB 10 uses a stronger password policy, change the database users passwords on both MariaDB versions and in the application, in my case S9Y.

After the database copy I altered the default port of the old MariaDB 5 to a dummy port number and the MariaDB 10 to the default port 3306. I stopped the MariaDB 5 service and within the used PHP configurations I then changed these values:

  • mysql.default_socket: /run/mysqld/mysqld10.sock

  • mysql.default_port: 3306

After these changes my websites, this one and a family site, ran just fine using MariaDB 10! After waiting for a while the old MariaDB 10 can be uninstalled on Synology.

No comments

Add Comment

Standard emoticons like :-) and ;-) are converted to images.
Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.