/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 vote151 views1 answer
Amount of entries in a table psql
SQL
0 vote145 views1 answer
Mysql find missing values
SQL
0 vote154 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote163 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote145 views1 answer
Oracle sql developer closed connection
SQL
0 vote216 views1 answer
Run docker container with database as rds metabase
SQL
0 vote150 views1 answer
Mysql zerofill
SQL
5 votes136 views1 answer
Ora-00054 find lock
SQL
0 vote107 views1 answer
Deleted table in sql trigger
SQL
0 vote139 views2 answers
Sql join on wildcard
SQL