/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

14 votes331 views2 answers
Oracle add column with default value
SQL
3 votes363 views2 answers
See mysql users ubuntu
SQL
1 vote348 views3 answers
Read all columns of a table sql
SQL
17 votes292 views2 answers
How to assign date field for table in mysql
SQL
0 vote316 views1 answer
Report in database
SQL
2 votes341 views1 answer
Sqlplus clear screen
SQL
0 vote320 views1 answer
Sqlite commands
SQL
0 vote301 views1 answer
Mysql regex exact match
SQL
3 votes318 views4 answers
Stop MySQL
SQL
0 vote347 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL