Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MariaDB client code example
Example 1: '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
Example 2: mariadb ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MariaDB client
sudo mysql -u root
MariaDB [(none)]> update mysql.user set password=password('<yourpassword>') where user='root';
MariaDB [(none)]> flush privileges;
sudo mysql -u root -p
Enter password: *******
select user,host,password,plugin from mysql.user;
output:
+
| user | host | password | plugin |
+
| root | localhost | ***************** | unix_socket |
| root | e320 | ***************** | unix_socket |
| root | 127.0.0.1 | ***************** | unix_socket |
| root | ::1 | ***************** | unix_socket |
+
sudo mysql -u root -p
Enter password: *******
update mysql.user set plugin='' where user='root';
flush privileges;
Example 3: Couldn't connect :( Error: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client 2020
Couldn't connect :( Error: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client