search

dbcli / mycli

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
http://mycli.net
Other
11.39k stars 657 forks source link

Root user cannot log in #980

Open toptools opened 3 years ago

toptools commented 3 years ago

The latest version of mariadb uses the "unix_socket" plugin My root user has no password. I can use sudo mysql sudo mysql -u root Direct Login No login password Only need sudo password

He asked me to fill in the password , But my root user has no password

I can use mycli to log in to the database of other usernames But i can't use sudo mycli -h 127.0.0.1 sudo mycli -h 127.0.0.1 -u mysql sudo mycli -h 127.0.0.1 -u root mycli -h 127.0.0.1 mycli -h 127.0.0.1 -u mysql mycli -h 127.0.0.1 -u root Sign in

Failure message 1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES 1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES

Do I have to use the root password?

wjWu00 commented 3 years ago

Solution: you need to use two passwordes. and setup your mysql server to get the password.

the first password will be the password for your labtop. the second password will be the mysql server password.

After entering two password, you will going into it.