How to connect to MariaDB on a VPS (Virtual Private Server) with your PC?

06/17/2023 12:00 AM by Admin in Database-guides

To connect to MariaDB on a VPS (Virtual Private Server) with your PC, you can follow these steps:

1. Ensure that your VPS has MariaDB installed and running. If not, you will need to install and configure MariaDB on your VPS first.

2. Open the terminal or command prompt on your PC.

3. Use the `ssh` command to connect to your VPS. Replace `username` with your VPS username and `your_vps_ip` with the IP address of your VPS.

ssh username@your_vps_ip

4. Enter your VPS password when prompted.

5. Once you are connected to your VPS, you can use the following command to access the MariaDB command-line interface:

mysql -u username -p

Replace `username` with your MariaDB username. You will be prompted to enter the password for the user.

6. If the username and password are correct, you should now be connected to the MariaDB server.

Alternatively, you can use a graphical tool like MySQL Workbench or HeidiSQL to connect to MariaDB on your VPS. These tools provide a user-friendly interface for managing databases and executing queries.

Here's how to connect using MySQL Workbench:

1. Install MySQL Workbench on your PC if you haven't already.

2. Open MySQL Workbench and click on the "+" icon in the "MySQL Connections" section to create a new connection.

3. Enter a connection name.

4. Set the following parameters: