Easiest way to fix SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' error in MySQ

Published: 01 January 1970
on channel: Alphayo Wakarindi

4,767

This video shows how to fix SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'' error in the simplest way possible you can think of.

Step 1:

sudo mysql -u root -p

-then enter your sudo password if it’s asked.
-It will also ask for mysql password. For that one it’s blank so just press Enter.

Step 2:

USE mysql;

Step 3:

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

Step 4.
FLUSH PRIVILEGES;

Step 5.
exit;

Step 6.
$ service mysql restart

#MySQL #AccessDenied #Laravel

Watch video Easiest way to fix SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' error in MySQ online without registration, duration hours minute second in high quality. This video was added by user Alphayo Wakarindi 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,767 once and liked it 43 people.