Tuesday, January 9, 2018

[google-cloud-sql-discuss] Unable to access mysql (running in one server) from another server

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.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/8cb4e727-2faf-43d3-84a4-21522049f8e5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment