Acessing MySQL From My Local MySQL Client

Question

I have created a MySQL service on App42 PaaS. It is working fine with my application. But when I try to use the same service credentials on my local mysql client, I am unable to do so. Can you help me with this ?

Error Detail:

ERROR 2003 (HY000): Can't connect to MySQL server on '172.12.13.4' (10060)

Answer 1

Hi Stane,

To access MySQL service from your local SQL client, you need to bind your IP for the MySQL service you want to access.You can run the below command to bind IP to your service using app42 command line client.

app42 bindIP

It will ask you the service name which you want to access (in this case your MySQL service name) and the IP address where you want to access the service from. You will get a public IP as a result which you can use to access the service from your local MySQL client. (Other credentials like username, password & port will remain same as you are using in your app).

You can also refer to the below blog for detailed instructions.

http://blogs.shephertz.com/2014/02/19/managing-your-app42-paas-data/

Comments

Thanks deo for the help.