How to connect to local mysql server without password?

Question

linux

I installed VestaCP along with mysql server.
While picking root privileges, he broke his login without a password using the mysql or mysql -u root command.
Now, when I write one of these commands, I get:
'Access denied for user 'root'@'localhost' (using password: YES)'
There is nothing in the database, except for the settings from the vesta and its standard user database.

Answer 1

.my.cnf in the user's home view

Answer 2

" (using password: YES)" - means, after all, the password is set when connecting. Try explicitly specifying an empty password.

Answer 3

you can add
skip-grant-tables to my.cnf
this will allow you to connect without a password

Answer 4

Debian (and clones) have a special user, with settings in /etc/mysql/debian.cnf. You can use it to set a password for any user.