i installed heidisql as sudo user and cannot access as root

Can't Access MySQL as Root User After Installing HeidiSQL on Ubuntu 20.04

When you install HeidiSQL on Ubuntu 20.04 and run it with a sudo user, you might encounter an issue where you cannot access the database as the root user. This problem occurs because the default settings of MySQL do not allow users to log in as the root user without a password.

To resolve this issue, you need to set up a strong password for your MySQL root user and enable the VALIDATE PASSWORD component, which helps ensure that you use difficult passwords for database access. Here's how to do it:

First, open a terminal and run the following command to start the interactive script:

```

sudo mysql_secure_installation

```

This script will guide you through a series of questions to help you set up a strong password for your MySQL root user.

Once done, you can then run the following command to install the VALIDATE PASSWORD component:

```

sudo apt install mysql-server -y

```

After installing the component, you can test its strength by running the `mysql` command with the `-p` option and entering your password:

```

mysql -p

```

Replace `` with the strong password you set up earlier.

If you want to execute a series of commands as the root user without having to prefix every command with `sudo`, I recommend using `sudo -i` to grab a login shell as the root user. This means that login-specific resource files such as `.bashrc` and `.profile` will be executed before running the shell.

By following these steps, you should now be able to access your MySQL database as the root user without any issues.

I installed heidisql as sudo user and cannot access as root