Right after I updated the synology operating system, I realized I could not longer access phpmyadmin and the database where I store my wordpress data.
After some online search, I discovered that Synology has replaced MYSQL to MariaDB and you need to do a few things before you can log in again.
Here is what worked for me:
Click on the MariaDB icon on your synology main menu:
MariaDB is in compatibility mode (I don’t have a picture of this as I have updated it already), so in order to upgrade, enter your phpmyadmin password in the screen that opens and click ok.
If the upgrade is successful, you will see this screen:
and now you can click again on phpmyadmin and enter your credentials to access the database. Synology has migrated all the databases and data for you:
Remember, your username, if you haven’t changed it is “root” and your password, again if you haven’t changed, is blank (that is, no password set).
If you want to change your password, you can follow this guide: Change your password on your SQL database using phpmyadmin
Some users are reporting issues when upgrading MariaDB and what has worked for some is to stop and start MariaDB service:
Search for mariadb in the package center and click on the icon NOT on “Open”:
That will open the admin panel for Maria DB where you will click on “Action” and the “Stop” and afterwards “Start” to restart the service. That might do the trick even for you:
If you are still having problems, try this tutorial from Rob
and you are all set, Enjoy!!