/Shell/Bash/Got error: 1698: Access denied for user 'root'@'localhost' when trying to connect

Got error: 1698: Access denied for user 'root'@'localhost' when trying to connect

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

>>> sudo mysql -u root -p

>>> USE mysql;

>>> UPDATE user SET plugin='mysql_native_password' WHERE User ='root';

>>> FLUSH PRIVILEGES;

>>> exit;

>>> service mysql restart;

Source: askubuntu.com

Got error: 1698: Access denied for user 'root'@'localhost' when trying to connect

$ sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;

$ service mysql restart

Source: stackoverflow.com

Similar codes

1 vote183 views1 answer
Linux convert files in folder
Shell/Bash
4 votes199 views3 answers
Brew services start mongodb
Shell/Bash
-1 vote179 views6 answers
Install bootstrap laravel 8
Shell/Bash
0 vote192 views1 answer
Gunicorn port 8080
Shell/Bash
-1 vote173 views2 answers
Conda install ipywidgets
Shell/Bash
2 votes203 views1 answer
Npm install react-final-form
Shell/Bash
0 vote204 views1 answer
Recursively change file permissions linux
Shell/Bash
4 votes140 views1 answer
Bash find if string include substring
Shell/Bash
0 vote181 views2 answers
Psycopg2.OperationalError: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?
Shell/Bash
13 votes184 views5 answers
Git set remote tracking branch
Shell/Bash