/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

3 votes257 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote235 views1 answer
Insert set mysql
SQL
0 vote223 views1 answer
Sql query interview questions githu
SQL
3 votes232 views2 answers
How to start postgresql on windows
SQL
0 vote221 views1 answer
Where case insensitive like mysql
SQL
0 vote212 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote243 views1 answer
Mysql select all and rename one
SQL
0 vote226 views1 answer
Replace sqlalchemy
SQL
2 votes238 views1 answer
Sql string_agg
SQL
0 vote236 views1 answer
Close sql query vb.net
SQL