How to setup MariaDB on Linux in Azure/AWS/GCP

20 Aug

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.

Getting Started

Once your MariaDB server has been deployed, the following links explain how to connect to a Linux VM:

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:

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.