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:

 

 

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:

https://dev.mysql.com/doc/workbench/en/

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:

https://dev.mysql.com/doc/workbench/en/

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:

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/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:

https://dev.mysql.com/doc/workbench/en/

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

 

Disclaimer: MariaDB® is a registered trademark owned by MariaDB Corporation Ab, Inc and is licensed under GPL v2 license. No warrantee of any kind, express or implied, is included with this software. Use at your risk, responsibility for damages (if any) to anyone resulting from the use of this software rest entirely with the user. The author is not responsible for any damage that its use could cause.
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