Skip to main content

How to connect your Google Cloud database with Rocketadmin

This user guide outlines the procedure for establishing a Rocketadmin connection to a Google Cloud managed database.

Although the manual primarily focuses on MySQL as an example, it can also be utilized to establish connections with other types of databases supported by Google Cloud.

note

The instructions are general and do not contain any detailed explanations on specific Google Cloud features. To learn the fundamentals, find best practices and experience the full Google Cloud potential, please visit https://cloud.google.com/docs/.


Google Cloud settings​

To create a database instance​

  1. Sign in to your Google Cloud account.

  2. From the Dashboard of your project navigate to the Resources section and click on SQL:

  3. In the next screen click on Create Instance with your free credits:

  4. Choose MySQL as database engine:

  5. In case you are asked to enable Compute Engine API, click on Enable API:

  6. In the next screen select a Cloud SQL Edition from the options:

  7. Choose a preset for your edition, for example: Development:

  8. In the Instance info section:

    • select MySQL Database version

    • enter a name for your instance in the Instance ID field

    • set a password for the root user (you can review the password recommendations by expanding Password policy)

  9. Choose a Region in order to keep your data close to the services that need it:

    And you can also specify a zone withing the region, for example:

  10. To customize the instance, expand Show configurations:

  1. Click on Connections:

  1. Enable the Public IP option and click on Add a network:

  1. Enter a Name for the network and add the Rocketadmin IP address - 18.221.81.73/32 as trusted source, granting us access to your database:

  1. Click on Done to confirm.

  2. Click on Create instance to complete the settings:


To create a database user​

  1. From the Primary instance side panel click on Users:

  2. Click on Add user account.

  3. Enter a User name and a Password for your user:

  4. Allow any Host:

  5. Click on Add.

The user is created and visible in the Added users list:


To create a database​

  1. From the Primary instance side panel click on Databases:

  2. Click on Create database.

  3. Fill in the required data for the database, including Database name, Character set and Collation:

  4. Click on Create.

The database is created:


To create a table​

  1. From the Primary instance side panel click on Cloud SQL Studio:

  2. Sign in to the Cloud SQL Studio as follows:

    • select your Database

    • enter the database User name and provide the Password

  3. Click on Authenticate.

  4. From the database Explorer screen click on next to your database Tables and then on Create table:

  5. Run a query with the necessary information to create a table:

  6. Populate the table with data:


Rocketadmin settings​

The final steps of this guide include creating a Rocketadmin connection to the Google Cloud instance running MySQL and review the data in the table. Follow the guidelines:

  1. Sign in to your Rocketadmin account.

  2. In the Dashboard click on Add database:

  3. In the Connect a database screen:

    • enter a name for the connection

    • select MySQL as database type

  4. Enter the following information in the connection's details:

    • Hostname: the external IP address of your instance

    • Username, Password, Database name

  5. Click on Test connection.

  6. Once the connection is successful, click on Add. The following message appears:

  7. Click on I gave access since the Rocketadmin IP address - 18.221.81.73/32 is already added as trusted source.

Your database and table appear in the Dashboard: