/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 vote185 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
39 votes249 views5 answers
Sql drop column
SQL
0 vote148 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
2 votes140 views1 answer
Mysql add boolean column
SQL
0 vote183 views1 answer
Mariadb hours between two dates
SQL
0 vote162 views1 answer
Create dabase postgresql
SQL
0 vote138 views1 answer
Sql grant select only
SQL
28 votes139 views4 answers
Delete database mysql
SQL
31 votes153 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote151 views1 answer
Count number of entires by months sql
SQL