Connect to a remote MariaDB server using VirtualMin

When managing a website, it is important to have access to your database server to store and retrieve data efficiently. In this article, we will guide you through the process of connecting to a remote MariaDB server using VirtualMin, a popular web hosting control panel.

Step 1: Install VirtualMin

If you haven't already installed VirtualMin on your server, you can follow the official installation guide provided by VirtualMin. Once installed, you can access your VirtualMin control panel by visiting http://your-server-ip:10000 in your web browser.

Step 2: Create a Remote MariaDB User

To connect to a remote MariaDB server, you need to create a user with the necessary permissions. Follow these steps:

1. Log in to your VirtualMin control panel.
2. Navigate to the Webmin section.
3. Click on System and then Users and Groups.
4. Click on Create a new user.
5. Fill in the required information, including the username and password for the remote MariaDB user.
6. Under Member of groups, select mysql.
7. Click on Create to save the user.

Step 3: Allow Remote Access to MariaDB Server

By default, MariaDB only allows connections from the localhost. To enable remote access, follow these steps:

1. Go back to the VirtualMin control panel.
2. Navigate to the Webmin section.
3. Click on Servers and then MariaDB Database Server.
4. Click on Database Server and then Access Control.
5. Click on Add record.
6. Enter the IP address of the server you want to connect from in the Hosts field.
7. Under Database, select All databases.
8. Under Username, select the remote MariaDB user you created earlier.
9. Click on Create to save the record.

Step 4: Connect to Remote MariaDB Server

Now that you have created a remote MariaDB user and allowed remote access, you can connect to the server using a MySQL client. Here's how:

1. Download and install a MySQL client such as MySQL Workbench or HeidiSQL.
2. Launch the MySQL client.
3. Enter the IP address of the remote MariaDB server in the Server Host field.
4. Enter the username and password of the remote MariaDB user you created.
5. Click on Connect to establish the connection.

That's it! You have successfully connected to a remote MariaDB server using VirtualMin. Now you can manage your databases and perform various operations from your MySQL client.

References