Hi Guys so I read and read and read… I am lost without a paddle. I had a server and lost all my data all my invoices everything… So I got a new server, and installing this for the first time on it. I was able to get through setup… and the part where I cannot get past is (Failure Cannot connect to the database server with the provided database information. Please check the credentials and try again. )
cannot get this to go through no matter what. in phpmyadmin there is a user called invoicead (global priveleges set to all in myphpadmin) and there is also a blank db created called invoicepl.
running apache http server 2.4
php 5.6
mariadb10
myphpadmin 4.66
Any ideas why its not connecting?. Much appreciated…
I think I might have found out what is causing the issue however im not sure if there is a way to make it work… so for some reason synology made myphpadmin dependant on mariadb 10. Now I had both 5 and 10 installed because on the new server it first said it wanted version 5. then i loaded 10 trying to be all cool and hip. I some how remembered maybe they are conflicting since its a fork of mysql… it kind of explains why i cant find the damn httpd or anything to do with mysql. so now i removed all the packages myphpadmin and mariadb 10 and 5… now when i want to install myphpadmin its stating it wants mariadb 10 as the dependency not 5 from before…I have an odd feeling everything will work with version 5 if i can get myphpadmin to use that instead of 10… so bummed i really used this software for some time now… being serverless sucks!!! and anything webserver related does not work i cant install any other web related script or server. invoiceplane invoice pro crm etc… i thought it was my stupidity surfacing but now i realize its this mariadb handicapping me from being able to do anything…
Anyway, there shouldn’t be any significant difference between MySQL 5 and MariaDB10, they both work the same.
MariaDB has some extra functionality, but the basic MySQL functions work the same, especially the ones IP is using.
Maybe your MariaDB settings are wrong? Or your user permissions aren’t copied to MariaDB, causing the install to fail?
hi, see thats the thing by default mariadb is broken because there is 2 versions and its forcing 10 to be default. Nothing sees mysql. I dont know what I can do to make mysql visable or mariadb to work with other services.
Recent versions of mysql do not let you connect by default from external sources (localhost - 127.0.0.1) is the default.
You need to configure mysql to allow connections from outside the server. To do this you will have to edit your mysql server configuration file and bind the external address to the server, then restart the server. Your database administrator should be able to assist with this.
I had an issue when migrating from MariaDB5 to MariaDB10 which is similar to the OP problem.
So this reply is for anyone who might be struggling with this.
Using Invoiceplane and MariaDB on a Synology (no Docker involved here), I solved the issue when migrating from MariaDB5 to MariaDB10 (since Synology DSM7 only supports MariaDB10). The post from crafter got me on my way.
install MariaDB10
export the databases from MariaDB5 and import them in MariaDB10 (can be easily done in Phpmyadmin)
stop and uninstall the MariaDB5 package (keep the databases, just in case)
SSH into your Synology: ssh <username>@<IP> -p <port_if_different_than_22>
Go to the MariaDB10 config folder: cd /var/packages/MariaDB10/etc
so bummed i really used this software for some time now… being serverless sucks!!! and anything webserver related does not work i cant install any other web related script or server. invoiceplane invoice pro crm etc… 
)