Shell/Bash: error 1698 (28000): access denied for user 'root'@'localhost' Example
Shell/Bash Example: This is the "error 1698 (28000): access denied for user 'root'@'localhost'" Example. compiled from many sources on the internet by SimpleTutorials.org
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;
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
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
SET PASSWORD FOR 'bob'@localhost = PASSWORD("");
RROR 1698 (28000): Access denied for user 'root'@'localhost
sudo mysql -u root -p
* Summary: This "error 1698 (28000): access denied for user 'root'@'localhost'" Shell/Bash Example is compiled from the internet. If you have any questions, please leave a comment. Thank you!