Experienced a similar issue. Maybe this advice will help you to solve the error. Your user’s password should not contain any special characters. In my case, ’~’ in password was the whole reason of problem.

It works with Mariadb too. You must check the syntax of step 3, in MariaDB is:

ALTER USER 'rot'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('password');

Thanks @gasgen.

If this problem keeps happening to someone, the reason is that Ubuntu Mint (and other distros) no longer come with a 'blank' password by default. So, we need to reset it:

sudo mysql_secure_installation

Select the password level you want, write it, and then yes (Y) to all. Then:

 sudo mysql

And execute (change the word password with the password you have written before):

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

That's all, now you can configure local DB in DBeaver with the new password. Hope this works for you.

If this problem keeps happening to someone, the reason is that Ubuntu, Mint (and other distros) they no longer come with a 'blank' password for default. So, we need to reset it:

sudo mysql_secure_installation

Select the password level you want, write it and then yes (Y) to all. Then:

sudo mysql

And execute (change the word password with the password you have written before):

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

That's all, now you can configure local DB in DBeaver with the new password. Hope this works for you.