/SQL/MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',

$ mysql -u root -p
Enter password: (enter your root password)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
mysql> FLUSH PRIVILEGES;
mysql> quit

Source: stackoverflow.com

Client does not support authentication protocol requested by server; consider upgrading MySQL client

$ mysql -u root -p
Enter password: (enter your password)

mysql> ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
mysql> FLUSH PRIVILEGES;
mysql> quit

MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password ...

Source: stackoverflow.com

Similar codes

3 votes313 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote314 views1 answer
Order by ip address sql
SQL
0 vote335 views1 answer
Changing name of column and datatype in sql
SQL
0 vote303 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote306 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote333 views1 answer
Mysql export search results
SQL
0 vote314 views1 answer
Mysql procedure between two tables
SQL
0 vote313 views2 answers
Mysql to python pandas
SQL
2 votes347 views2 answers
Mysql count rows returned
SQL
2 votes306 views1 answer
Match in sql server
SQL