i installed heidisql as sudo user and cannot access as root

How to Install HeidiSQL and Access as Root

As a sudo user, you may encounter difficulties accessing your MariaDB or MySQL database using HeidiSQL. This article aims to guide you through the process of installing HeidiSQL and accessing it as root.

Before proceeding, ensure that you have shell (SSH) access to your VPS and a fresh Webdock cloud Ubuntu instance with LEMP/LAMP installed. Additionally, make sure your firewall port is open, allowing remote access to your database.

To grant remote access to an existing database, you will need to grant the appropriate privileges to a new or existing user in MySQL using the command line or phpMyAdmin. For more information on how to achieve this using the command line, refer to our instructions below.

Manual Configuration using the Command Line

If you have not run our enablement script to allow MariaDB to listen on all interfaces and your firewall port is still closed, then this has no security impact. To reiterate, any database user created in the Webdock dashboard with the word 'remote' in their username will be granted remote access on `%` - meaning that user can connect from anywhere.

However, if you want to restrict users or your firewall port by IP, you will need to follow the manual setup method below. Please note that using this approach may open up port 3306 to the world, allowing anyone who can guess your DB username and password to gain access.

Step-by-Step Instructions

1. Create a new database and database user containing the word 'remote' in their username.

2. Run the 'Enable Remote Mysql Access' script on your server (found in the Script Library).

This approach may be considered insecure, so we recommend considering alternative methods for granting remote access to your database.

In this tutorial, we have shown you how to configure MariaDB for remote connections using the Webdock dashboard or manually with shell access on a Ubuntu server running MariaDB older than v10.6. By following these steps, you will be able to install HeidiSQL and access it as root. Remember that granting remote access to your database requires careful consideration of security implications.

References

For more information on managing DNS records, refer to our Webdock DNS Guide. For instructions on how to achieve remote access using phpMyAdmin, please see our article on .

I installed heidisql as sudo user and cannot access as root