/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

1 vote299 views1 answer
Login to database mysql terminal
SQL
15 votes272 views2 answers
Open postgress in terminal mac
SQL
1 vote233 views1 answer
Oracle boolean to varchar
SQL
0 vote269 views1 answer
How to fix mysql stop unexpectedly
SQL
36 votes290 views6 answers
Rename table sql
SQL
3 votes296 views1 answer
Oracle transaction commit rollback example
SQL
0 vote301 views1 answer
What is database username and password in mysqliconnect
SQL
4 votes282 views1 answer
Phone number sql
SQL
0 vote317 views1 answer
How to inner join 4 tables in sql
SQL
0 vote267 views3 answers
Mysqli count down
SQL