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!!
Synoguide 
Good morning Ruth,
I have made changes in my WP site after the DSM update and now I also checked access to the phpadmin files in the filestation. I am not sure if I have the problem ?
BR/M
LikeLike
Hi Magnus, can you login in phpmyadmin and your site is running normally? If that is the case, then you don’t have any problems. Only a handful of users are experiencing this problem. /ruth
LikeLike
Checked and confirmed. Tnx. BRgrds/M
LikeLike
I’ve got phpMyadmin working with MariaDB finally but am unable to get WordPress to connect to it.. I’ve uninstalled and re installed MariaDB a few times now and finally to get phpMyadmin working I had to comment out the #bind-address item in my.cnf and set a user password for the root@localhost user.. I still don’t get why WordPress is unable to connect to the database. Everything worked great before the upgrade.. any ideas as to what else I could do would be appreciated.
Thanks
LikeLike
Got it working finally..
Thanks
LikeLike
Hi Kevin, can you let us know how you did it? It will help other users.
Ruth
LikeLike
Thanx for the tutorial
LikeLike
Glad it helped you Gerard, Ruth
LikeLike
Thanks very much. This worked like a charm. I found some nightmare scenarios to ‘upgrade’ Maria DB but this is as I would expect with the Synology products. Super!
LikeLike
Thanks for the feedback, really glad it worked for you!. /Ruth
LikeLike
Ruth, thanks so much for this. It helped me resolved my mysql.proc error messages which had been bugging me. Thanks again. James
LikeLike
Glad it worked for you! Ruth
LikeLike
Hi
I have a Synology RS812, i have just installed it and all updates, and i can’t find MariaDB anywhere.
do you know where to download it and install manual
Leif
LikeLike
Hi Leif, You should find your MariaDB in the synology packages, read here: http://www.synology.com/en-global/dsm/app_packages/products/dsm/app_packages/MariaDB. According to the synology documentation, it is installed in your model too. You will find all the documentation for MAriaDB here: https://mariadb.org/
Hope this helps, Ruth
LikeLike
Hi Ruth,
after the last update of MariaDB (5.5.37-0017) on my synology DS214play at each restart I have a message like this
“MariaDB databases are currently running in compatible mode. Please run MariaDB to upgrade databases first”
do you know how I can run MariaDB in normal mode?
thanks
Salvo
LikeLike
Hi Salvo,
Did you follow the instructions in the post? That should solve your problem.
Ruth
LikeLike
Hi Ruth,
I have a message like this
“MariaDB databases are currently running in compatible mode. Please run MariaDB to upgrade databases first”
do you know how I can run MariaDB in normal mode?
I made you described but still get the same message
thanks
Kis Pipacs
LikeLike
Hi Kis Pipacs,
Have you tried this:
Have you tried in the following order:
– Uninstall MariaDB
– Remove hidden folder(s?) with mysql in @databases
– Reïnstall MariaDB
Also you can search for the file my.cnf and rename it to my.org when you find it BEFORE you reïnstall MariaDB.
They can be found with “find / -name my.cnf”
It has helped some users: http://forum.synology.com/enu/viewtopic.php?f=232&t=79798
Ruth
LikeLike
This saved my site! I could only load the main page the rest was ‘not found’ although the pages were clearly visible in the UI and were searchable, but wouldn’t display. This was after the mariaDB 5.5.41-0029 upgrade. Stopping and starting was all that was needed.
LikeLike
Glad it worked 🙂
Ruth
LikeLike