To setup a MySQL server in GCP, the easiest way is to use our MySQL server image from the GCP marketplace. Its the recommended way to deploy MySQL on Windows into Google GCP. Also comes preinstalled with phpMyadmin, PHP, Apache. Click on the links below to deploy to your GCP project.
Once logged in, you’re now ready to start setting up your new server as per the following sections.
MySQL Server Details
MySQL database credentials are (also used for phpMyadmin login):
MYSQL Username: root
MYSQL Password: Password is the VM Instance ID. To find the Instance ID you will find on the property details of the VM within your GCP console. Here is a screenshot of where you will find it:
NOTE: If you find the root password doesn’t work. Wait 5 mins as during the first boot a start script is setting the root MySQL password and could still be running. You can see if its still running by viewing any Windows task schedule jobs. Wait for it to finish and then try logging in again.
MySQL location
C:\tools\mysql\current\
PHP Files location:
C:\php
Apache location
C:\Apache24
PhpMyadmin location:
C:\Apache24\htdocs\phpmyadmin
MySQL Server Ports
The following ports need to be opened in GCP if you are using a firewall appliance or any security groups.
3306 – TCP (MySQL) 33060 – TCP (MySQL X Protocol) 6446 – TCP MySQL Router 6447 – TCP MySQL Router 6448 – TCP InnoDB Cluster 6449 – TCP InnoDB Cluster
If you would like us to implement the MySQL server into your environment and fully configure it and get it up and running, get in contact with us and we will get you up and running asap
Cloud Solution Architect. Helping customers transform their business to the cloud. 20 years experience working in complex infrastructure environments and a Microsoft Certified Solutions Expert on everything Cloud
00votes
Article Rating
Subscribe
Login and comment with
I allow to create an account
When you login first time using a Social Login button, we collect your account public profile information shared by Social Login provider, based on your privacy settings. We also get your email address to automatically create an account for you in our website. Once your account is created, you'll be logged-in to this account.
DisagreeAgree
Login and comment with
I allow to create an account
When you login first time using a Social Login button, we collect your account public profile information shared by Social Login provider, based on your privacy settings. We also get your email address to automatically create an account for you in our website. Once your account is created, you'll be logged-in to this account.