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

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

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

$ 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

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

SET PASSWORD FOR 'bob'@localhost = PASSWORD("");

Source: mariadb.com

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

//Just use sudo in command!
sudo mysql -u root -p

Similar codes

8 votes156 views4 answers
Vue scss
Shell/Bash
38 votes162 views5 answers
Remove commit from github
Shell/Bash
0 vote175 views2 answers
Git branch inside branch
Shell/Bash
0 vote165 views1 answer
Default side-by-side NDK installation is not found.
Shell/Bash
0 vote132 views2 answers
Ubuntu 20.04 not starting gui
Shell/Bash
14 votes163 views3 answers
Installer microsoft teams ubuntu
Shell/Bash
1 vote180 views1 answer
Bash how to download password protected files
Shell/Bash
2 votes380 views1 answer
Bash symlink everything in a directory
Shell/Bash
26 votes161 views3 answers
Git cherry pick parts of a commit
Shell/Bash
0 vote163 views2 answers
Convert epoch timestamp to human readable format on osx
Shell/Bash