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.
Create MySQL Database in Google App Engine.
To create MySQL Database in Google App Engine, you need to follow the following steps.
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.
Here you will find different types of options such as Overview, Permissions, Settings, Support. Click on the Settings option of your project.
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.
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
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.
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.