Knowledge base → Working with the MariaDB database through the HeidiSQL editor for Windows via SSH

Date of publication: 19.07.2023

Sometimes there are tasks when you need to quickly access the database to work with tables. This is especially true for applications that work without a control panel and do not have the phpMyAdmin application installed on the server, as is the case with using shared hosting. Let's consider an example when you need to connect to a database that is configured for local connections only, i.e. with ip (127.0.0.1).

To solve this problem, we use the application HeidiSQL for Windows.

Let's run the application and make the database connection settings specified in the configuration file of our application. Please note, since we will use the SSH tunnel, we specify the ip address 127.0.0.1, otherwise, in order for the external ip connection to work, we will need to allow this in the MariaDB settings on the server itself.

Now on the SSH tunnel tab, specify the login and password, in our case from the root user.

Specify the host or external ip address of the server, as well as the port. Now you can try to connect, the database editor will open, in which you can select a database that is allowed for editing by the user we specified in the settings tab.

In some cases, this phpMyAdmin alternative will be very handy.

No Comments Yet