/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

0 vote180 views1 answer
Mysql create table columns with spaces
SQL
0 vote173 views1 answer
Mysql select where text contains
SQL
0 vote202 views2 answers
Mysql calcular idade
SQL
1 vote178 views1 answer
Pv mysql import
SQL
8 votes180 views1 answer
Oracle find text in functions
SQL
11 votes189 views3 answers
How to get last row of table in sql
SQL
0 vote164 views1 answer
Jooq finding lastest value in table
SQL
0 vote183 views1 answer
Pl sql disable trigger
SQL
0 vote203 views2 answers
Transaction php
SQL
1 vote178 views1 answer
Round function in sql oracle
SQL