/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

2 votes348 views3 answers
Mysql kill
SQL
2 votes333 views1 answer
Sql server current date minus 5 years
SQL
0 vote328 views1 answer
How to reset the database value in SQL server
SQL
1 vote325 views1 answer
Drop table if exists oracle
SQL
-1 vote316 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote329 views1 answer
Oracle cpu metric
SQL
0 vote303 views1 answer
Sql select most frequent value in group
SQL
0 vote315 views1 answer
18446744073709551615 mariadb left join order by
SQL
3 votes297 views1 answer
Oracle user quota unlimited
SQL
1 vote307 views1 answer
Postgresql last element of array
SQL