How to Create Mysql Database on Google Cloud platfrom.

Cloud SQL for MySQL is a fully-managed database service that helps you set up, maintain, manage, and administer your MySQL relational databases on Google Cloud Platform.

 

  • Login to google cloud platform portal.
  • Click on SQL.

 

Fig 1

 

  • Click on Create Instance.

 

Fig 2

 

  • Select MySQL.
  • Then,click on choose MySQL.

 

Fig. 3

  • Provide the instance name & Password.
  • Select the database version for your instance: MySQL 8.0, MySQL 5.7 (default), or MySQL 5.6.
  • Select Region & Zone.

 

Fig. 4

 

  • Click on Show Configuration Options.

 

Fig. 5

 

  • Click on Machine type.

 

Fig. 6

 

  • Select Machine type as per requirement.

 

Fig. 7

 

  • Select Storage type & Capacity.

 

Fig. 8

 

  • Select Public or Private network for instance.
  • If needs to Add network then click on Add network.

 

Fig. 8

 

  • Provide New Network name & Network IP.
  • Click on Done.

 

Fig. 9

 

  • Set the Backup option.

 

Fig.10

 

  • At Maintenance, Select Preferred window & order of updates.

 

Fig.11

 

  • Click on Add Flag.

 

Fig.12

 

  • Provide the New database flag name.
  • click on done.

Fig.13

  • Click on Add Label.

 

Fig.13

 

  • Provide Key name & value for MySQL database.
  • Click on done.
  • Then,Click on Create instance.

 

Fig.14

 

 

  • After sometime database is ready then go to MySQL instance page.
  • MySQL Database is there with the name we provide.

 

Fig.15

Leave a Reply