Installation Steps:

1. On your Launch an instance page, in the Key pair section, either select an existing SSH key pair name or create a new one, such as aws-ec2-instance-key-us-east-1.

2. Edit your instance's security group inbound rules. Click on Add Rule, select the type as SSH, and set the source to My IP or manually enter your machine's IP address. This will allow only your machine to connect to the EC2 instance using SSH. To make your database server accessible via TCP: Click on Add Rule, select the type as MYSQL/Aurora, and manually enter the source which are allowed to connect to the server (e.g. your instance security group id, your instance/application server ip, etc)

3. Once you have downloaded the SSH key file to your machine, you can use it for secure authentication when connecting to remote instance.

[Linux/Mac] Change the permissions using chmod 400 aws-ec2-instance-key-us-east-1.pem. You can find more information click here 

Connect to the instance using SSH: ssh -i aws-ec2-instance-key-us-east-1.pem ec2-user@YOUR-INSTANCE-IP

[Windows] Refer to the following links for instructions on connecting to the instance using SSH: OpenSSH Setup  or Putty Setup 

MariaDB Setup:

Once you have logged in to the instance using SSH, secure and set the root password by running: sudo mysql_secure_installation

• Enter current password for root (enter for none):
• Switch to unix_socket authentication [Y/n] : n
• Change the root password? [Y/n]: Y
• Note down the root user password which you set in the previous step.
• Remove anonymous users? [Y/n]: Y
• Disallow root login remotely? [Y/n]: Y
• Remove test database and access to it? [Y/n]: Y
• Reload privilege tables now? [Y/n]: Y

Your MariaDB installation is successfully running.

Here are a few additional steps you may find helpful:

• When launching an instance, consider attaching an Elastic IP to ensure that it remains unchanged when you stop and start your instance.
• To connect to your remote database server, you can use a SQL client such as DBeaver  for Windows or Sequel Ace  for Mac. These clients provide a graphical interface for managing and interacting with your database.

Connecting to Server:

Please replace the following credentials in bold with your own in the application.

• DB_CONNECTION=mysql
• DB_HOST=ec2-127-0-0-1.ap-south-1.compute.amazonaws.com
• DB_PORT=3306
• DB_DATABASE=my_database
• DB_USERNAME=db_user
• DB_PASSWORD=my_db_password

MariaDB Config : sudo nano /etc/my.cnf.d/mariadb-server.cnf

sudo systemctl restart mariadb

You are all set! If you enjoyed using our MariaDB AMI, we would greatly appreciate a 5-star rating from you. Thank you!

Advanced-level support and optimization will be promptly provided upon request. For further assistance, please refer to the support section.