How to setup MariaDB on Windows in Azure/AWS/GCP
To install MariaDB on Windows and run on any of the cloud platforms, the best way is to use the readily available images in the marketplaces. Choose between Windows 2016 or 2019 and deploy with the latest version of MariaDB, Mysql Workbench and HeidiSQL for Database administration. Check the links below to deploy straight into your environment.
Getting Started
RDP into new server
Once you have deployed MariaDB on Windows server, the first step is to RDP into the new instance once it has fully booted up. The following links explain how to connect the VM once it has finished being deployed:
- How to RDP to AWS Windows Instance
- How to RDP to Google GCP Windows Instance
- How to RDP to Azure Windows Virtual Machine
Once logged in, you’re now ready to start setting up your new server as per the following sections depending on which cloud platform you’re using.
Using MariaDB on Azure
MariaDB is ready to use as soon as you login.
MariaDB root login details are:
User: root
Pass: blank (no password set)
Documentation on using MariaDB and the pre installed tools can be found on the following links:
MariaDB Documentation:
https://mariadb.org/documentation/
Using HeidiSQL:
https://www.heidisql.com/#featurelist
Using MySQL Workbench:
Using MariaDB on AWS
MariaDB is ready to use as soon as you login.
MariaDB root login details are:
User: root
Password: Password is the VM Instance ID. To find the Instance ID you will find on the top right of the desktop or within the AWS console under the EC2 VM properties
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.
Documentation on using MariaDB and the pre installed tools can be found on the following links:
MariaDB Documentation:
https://mariadb.org/documentation/
Using HeidiSQL:
https://www.heidisql.com/#featurelist
Using MySQL Workbench:
Using MariaDB on GCP
MariaDB is ready to use as soon as you login.
MariaDB root login details are:
User: root
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/MariaDB 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.
Documentation on using MariaDB and the pre installed tools can be found on the following links:
MariaDB Documentation:
https://mariadb.org/documentation/
Using HeidiSQL:
https://www.heidisql.com/#featurelist
Using MySQL Workbench:
MariaDB Firewall Ports
MariaDB is configured to use the following ports:
TCP 3306
To setup AWS firewall rules refer to – AWS Security Groups
To setup Azure firewall rules refer to – Azure Network Security Groups
To setup Google GCP firewall rules refer to – Creating GCP Firewalls
Support
If you require any help with the installation of MariaDB, leave a comment below or contact us directly if you are experiencing any issues
Want some help (hire us)?
If you would like us to implement any type of server or solution in Azure, get in contact with us with your requirements and we will see how we can help
