How to create MySQL Database in Google App Engine.

After download and install MySQL locally, you need to enable Google App Engine SQL in your Google App Engine Account. After creating Google App Engine Cloud SQL, you need to deploy your local apps or WordPress in Google App Engine. For Creating Cloud SQL, you need to enable billing system; it asks you your credit/debit card details but doesn’t worry, Google deduct your balance as per your uses, so there is nothing to worry about billing.

Before creating Google Apps SQL in Google App Engine, you need to register on the Google Cloud Platform and give the name of your Cloud console project. When you create a Cloud console project, you have to log on to Google Cloud Platform and put your specific project name after that. You need to follow some steps to create the MySQL database in Google App Engine.

mysql

Create MySQL Database in Google App Engine.

To create MySQL Database in Google App Engine, you need to follow the following steps.

STEP: 1

In this step, you have to go on your created project Name, which you have been created in before. You have to click on your project ID to enter it.

STEP: 2

Here you will find different types of options such as Overview, Permissions, Settings, Support. Click on the Settings option of your project.

STEP: 3

In the settings option, you will see different types of sections like Billing, Delete project, Rename Project. In the Billing section, you need to click on Enable billing option to access the full set of service and increase usage limits.

Create MySQL Database in Google App Engine

STEP: 4

When you click on the Enable Billing option, ‘Setup Your Billing Profile’ will be open. In the billing profile section, you have to mention Country or territory where your billing address is located. Then choose your language preference and what is your tax status. At last, you have to fill up the address form and credit/debit card details.

How to create new Cloud SQL instance

STEP: 1

After complete, your billing, one thing you need to create is the New Cloud SQL instance. Go to your Cloud console dashboard and click on your project. Here you will find the Cloud SQL option. Click on it to create new Cloud SQL.

STEP: 2

When you create a new Cloud SQL instance you will be put your Instance ID, Region, Tier option, Billing Plan
(as Per Use use you need to set it)

How to import the file into your new Cloud SQL instance.

In the Cloud SQL dashboard, you need to select the Import option to import the file into your new cloud SQL instance. When you click on the import tab, a new window will appear to introduce the database. In the case of WordPress installation in Google App Engine There, you should be mentioned Cloud Storage path (gs://appengine- php/setup.sql) and then click ok button.

Updated: October 15, 2019 — 3:34 pm

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.