/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 vote123 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote111 views1 answer
Mysql date format unix timestamp
SQL
-2 votes132 views1 answer
Mysql not empty
SQL
0 vote124 views1 answer
Postgresql inline table
SQL
0 vote126 views1 answer
Recently updated stored procedure in sql server
SQL
2 votes95 views1 answer
Oracle sql drop column if exists
SQL
8 votes107 views1 answer
Oracle find text in functions
SQL
0 vote62 views1 answer
Split a string with expression and get the last value of split sql
SQL
10 votes75 views2 answers
Mysql select timestamp group by day
SQL
3 votes137 views1 answer
What is having
SQL