Horje
ERROR 1698 (28000): Access denied for user 'root'@'localhost' Code Example
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("");
Source: mariadb.com
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
//Just use sudo in command!
sudo mysql -u root -p




Shell

Related
git temporarily ignore changes to tracked file Code Example git temporarily ignore changes to tracked file Code Example
install tmux ubuntu Code Example install tmux ubuntu Code Example
make kitty terminal the default terminal on ubuntu Code Example make kitty terminal the default terminal on ubuntu Code Example
tmux for ubuntu Code Example tmux for ubuntu Code Example
How do I check my WSL version? Code Example How do I check my WSL version? Code Example

Type:
Code Example
Category:
Coding
Sub Category:
Code Example
Uploaded by:
Admin
Views:
21