Connecting to MySQL database in Google Compute Engine - Remote Access

This page help you to access MYSQL database in Google Compute Engine from your system or network.

1. Get your public IP address.
2. Open Google Compute Engine in browser window
3. Navigate to /etc/mysql/
4. Open my.cnf file and add line:  bind-address = <internal IP>
5. Restart mysql server: $ service mysql restart
6. Sign in as mysql root user: $mysql -u root -p
7. Create new user: mysql>CREATE USER 'user1'@'<internal-ip-my-client>' IDENTIFIED BY '<some-password>'
8. Provide access to the user: mysql> GRANT ALL PRIVILEGES ON *.* TO 'user1'@'<internal-ip-my-client>' IDENTIFIED BY '<some-password>'; 
9. Restart mysql server