Question : ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Answered by : icymilktea27
>>> sudo mysql -u root -p
>>> USE mysql;
>>> UPDATE user SET plugin='mysql_native_password' WHERE User ='root';
>>> FLUSH PRIVILEGES;
>>> exit;
>>> service mysql restart;
Source : https://askubuntu.com/questions/1029177/error-1698-28000-access-denied-for-user-rootlocalhost-at-ubuntu-18-04 | Last Update : Thu, 16 Jul 20
Question : Got error: 1698: Access denied for user 'root'@'localhost' when trying to connect
Answered by : icymilktea27
$ 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 : https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost | Last Update : Tue, 25 Aug 20
Question : ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Answered by : thoughtful-trout-5mro3ksnqh44
sudo mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
flush privileges;
quit
sudo service mysql stop
sudo service mysql start
Source : https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost | Last Update : Tue, 13 Sep 22
Question : ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Answered by : lo-rednib
SET PASSWORD FOR 'bob'@localhost = PASSWORD("");
Source : https://mariadb.com/kb/en/set-password/ | Last Update : Wed, 16 Jun 21
Question : ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Answered by : rad
//Just use sudo in command!
sudo mysql -u root -p
Source : | Last Update : Thu, 18 Nov 21