Get the IP address of the client machine by opening the browser and navigating to this URL: http://ipv4.whatismyv6.com/. Note down the IP address shown on this page for your machine. Open Google Cloud Console in a web browser by navigating to https://console.cloud.google.com. Navigate to the Cloud SQL service and choose the instance you want to connect to. Choose the AUTHORIZATION tab of the instance and click on the Add network button. Add the IP address shown as follows and click the Save button:
To access the Cloud instance of MySQL from your local machine, MySQL must be installed in the local machine. Now open the command-line Terminal and type the following command. The IP address of the MySQL server can be found in the Cloud Console, in the overview table of the MySQL instance. Type the password and connect to the server:
mysql --host=<server ip> --user=root --password
Once connected, type the first line of the code to see the list of databases on the server. Type the second line to choose the database you want and type the third line to see a list of tables in the database. Then type the fourth line to execute a sample query. Type the quit command to exit the MySQL console. The sample database and tables were created in Chapter 1, Google Cloud and Google BigQuery:
show databases;
use EmployeeMgmt;
show tables;
SELECT * FROM EmployeeDetails;
quit;