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.
Start XAMPP for MySQL and Apache
This solution uses XAMPP, making it easier to manage Apache, MySQL and FTP. Right click on XAMPP Control Panel on the desktop and choose Run as Administrator.
Once opened, click on start Apache and start MySQL
MySQL Server Details
MySQL database credentials are (also used for phpMyadmin login):
MYSQL Username: root
MYSQL Password: Password is blank, its recommended to set a strong password.
MySQL location
C:\xampp\mysql
Apache location
C:\xampp\apache
Web Root: C:\xampp\htdocs
PhpMyadmin location:
http://localhost/phpmyadmin/
C:\xampp\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
