How to setup MySQL Server on Windows in Google GCP

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.

Setup MySQL Server on GCP

Getting Started

 

RDP into new server

 

Once you’re new deployment has finished booting up, you will need to RDP into the server:

 

How to RDP to Google GCP Windows Instance

 

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:

setup wordpress in GCP

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

 

Apache Webserver Ports

 

TCP/80 – (http traffic)

TCP/443 – (https traffic)

 

To setup Google GCP firewall rules refer to – Creating GCP Firewalls

 

Support

 

If you have any questions about the setup of our MySQL Server on Windows solution in GCP, leave your comments below and we will reply within 24 hours.

 

Alternatively have a look at https://www.mysql.com/why-mysql/white-papers/

 

Want some help (hire us)?

 

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

Andrew Fitzgerald

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

No Comments

Post a Comment

Comment
Name
Email
Website