How to setup MariaDB on Linux in Azure/AWS/GCP
To install MariaDB on Ubuntu or CentOS and run on any of the cloud platforms, the best way is to use the readily available images in the marketplaces. Deploy with the latest version of MariaDB. Check the links below to deploy straight into your environment.
Setup MariaDB Ubuntu on Azure
Deploy MariaDB on Ubuntu 18.04 LTS in Azure
Deploy MariaDB on Ubuntu 20.04 LTS in Azure
Setup MariaDB Ubuntu on AWS
Deploy MariaDB on Ubuntu 18.04 LTS in AWS
Deploy MariaDB on Ubuntu 20.04 LTS in AWS
Getting Started
Once your MariaDB server has been deployed, the following links explain how to connect to a Linux VM:
- How to connect to a Linux VM on Azure
- How to connect to a Linux VM on AWS
- How to connect to a Linux VM on GCP
Once connected and logged in, the following section explains how to start using MariaDB.
Using MariaDB
To improve the security of MariaDB and change the root user password, remove the anonymous user, restrict root user access to the local machine and remove the test database, run the following command:
sudo mysql_secure_installation
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:
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
