William
Posts: 0
Joined: Wed Dec 16, 2015 10:52 pm

Cannot Connect to MySQL Database

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

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

Cannot Connect to MySQL Database

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...

Rissa Hafez
Posts: 0
Joined: Sat Mar 02, 2019 12:53 am

Cannot Connect to MySQL Database

Was there a solution for this?

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

Cannot Connect to MySQL Database

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...

Rissa Hafez
Posts: 0
Joined: Sat Mar 02, 2019 12:53 am

Cannot Connect to MySQL Database

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

Rissa Hafez
Posts: 0
Joined: Sat Mar 02, 2019 12:53 am

Cannot Connect to MySQL Database

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.

Serhii Kulibaba
Posts: 150
Joined: Tue Aug 27, 2013 1:47 pm

Cannot Connect to MySQL Database

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

Arash Soft
Posts: 0
Joined: Wed May 29, 2019 12:05 pm

Cannot Connect to MySQL Database

Hi please check out this topic:

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

Return to “Issues”