Page 1 of 1

Cannot Connect to MySQL Database

Posted: Wed Dec 16, 2015 10:52 pm
by William

I have a wordpress site which obviously runs a MySQL database. I am trying to connect to this database via API Express. It keeps telling me my credentials are wrong even after I have checked and double checked them.

I used 'show variables;' to retrieve the required information from MySQL. I am sure of my dbname, user and password.

I can't seem to figure out what is wrong.
<
Image


Cannot Connect to MySQL Database

Posted: Thu Dec 17, 2015 11:51 am
by Illya Stepanov

Hi William -

Please check and make sure API Express can connect to your database. If API Express is not able to connect to your database, you might need to expose your database as described here: https://devcenter.appery.io/documenta...


Cannot Connect to MySQL Database

Posted: Sat Mar 02, 2019 12:53 am
by Rissa Hafez

Was there a solution for this?


Cannot Connect to MySQL Database

Posted: Sun Mar 03, 2019 10:31 am
by Illya Stepanov

Hi Rissa, the running database should be exposed to Appery.io DNS addresses to be able to connect to it and run queries. Here is how to do this: https://docs.appery.io/docs/apiexpres...


Cannot Connect to MySQL Database

Posted: Sun Mar 03, 2019 10:52 am
by Rissa Hafez

Thank you for your response. Actually what needed up working for me is using the advanced object and the jdbc string from azure MySQL.


Cannot Connect to MySQL Database

Posted: Sun Mar 03, 2019 10:57 am
by Rissa Hafez

Also just want to include that I had firewalls and all info correct under basic, but when I set it up with advanced it worked fine.


Cannot Connect to MySQL Database

Posted: Mon Mar 04, 2019 4:12 pm
by Serhii Kulibaba

Glad to hear things are sorted out now!
Please let us know if we can be of further assistance.


Cannot Connect to MySQL Database

Posted: Fri May 31, 2019 3:52 pm
by Arash Soft

Hi please check out this topic:

https://c.getsatisfaction.com/apperyi...