MariaDB

Version: 10.6.12 | OS: Ubuntu 22.04

Overview

MariaDB is a robust, open-source, multithreaded relational database engine. Designed for scalability, it can handle everything from small embedded systems to large-scale enterprise applications with billions of rows and thousands of tables.

Included Software

• MariaDB - 10.6.12

Firewall & Access

Port	Service	Purpose
22	SSH (rate limited)	Secure server access
3306	MariaDB	Database access

Initial Deployment

During the deployment process:

• MariaDB is automatically installed and configured
• Root password is set
• mysql_secure_installation is executed

You will be logged out with the message:

Please wait until the installation is completed....
Connection to $IPADDRESS closed.

Wait at least 2 minutes before logging back in.

Accessing the Instance

1. Login to your instance:

ssh ubuntu@$IPADDRESS

2. Switch to root:

sudo su -

Accessing MariaDB

• The MariaDB root password is stored in:

/root/.mariadb_root_password

• Login using the command:

mysql

Note: The root user uses unix_socket authentication and does not require a password by default.

• For password-based access, use the dbadmin user with full privileges.

Best Practices

• Allow database access only to trusted IPs via firewall rules
• Regularly update the system and database packages
• Periodically back up your data using mysqldump or replication
• Monitor logs located at /var/log/mysql/
• Use secure authentication and consider disabling remote root login

For assistance, contact Cloud4India Support.

---