dbcli
Root user cannot log in
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?
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.
