/SQL/Uncaught PDOException: SQLSTATE[HY000] [1698]

Uncaught PDOException: SQLSTATE[HY000] [1698]

sudo mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
service mysql restart

Source: gist.github.com

Similar codes

0 vote132 views1 answer
Group by join columns per table
SQL
0 vote122 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote118 views1 answer
Difference between varchar and varchar2
SQL
0 vote124 views1 answer
How to install postgresql on wsl
SQL
1 vote129 views1 answer
Show per page table in xampp
SQL
0 vote128 views1 answer
Update one column from another column in same table
SQL
0 vote120 views1 answer
IIF
SQL
3 votes131 views2 answers
MySQL query to get column names
SQL
1 vote137 views1 answer
Import mysql dump database command line linux
SQL
9 votes115 views2 answers
Get first 3 letters in sql
SQL