Unable to access mysql (running in one server) from another server

[shaik ruddin]

I am having two servers as per my application.

Server A is having mysql and a webapp.

Server B is having another webapp, both the server's share common mysql database.for that i enabled remote access for that server,which i have been doing from last couple of years in mysql. the same steps working fine with Soft-layer and AWS(after allowing port in security groups).

Steps as fallows:

1. Changed bind-address to 0.0.0.0 in /etc/mysql/my.cnf file

2. Granted privileges (GRANT ALL PRIVILEGES ON *.* TO 'root'@'SERVER-B-IP' IDENTIFIED BY 'password' WITH GRANT OPTION;)

3. Mysql restart

4. ufw disable (Turned off Firewall)

5. I did the telnet from local its working but not from another server.

Does , Google Cloud App Engine is having security groups like AWS ?

Kindly correct me if i am wrong.

[Karthick (Cloud Platform Support)]

Hello Shaik, 

To further troubleshoot, can you provide the following information : 

1. How are connecting to sql from another server and were you receiving errors in doing? 

2. Confirm that you are connecting between servers within Google Cloud Platform

3. Are you allowing the traffic for the TCP port 3306 using firewall rules ( which would be like 0.0.0.0/0 port tcp:3306)? 

4. Please clarify on your step 5 of telnetting from local. 

5. I am not sure if I have understood your question correctly, can you elaborate more about "Google Cloud App Engine having security groups" 

Also, you can visit this stackoverflow thread for more information.