Answers for "nodejs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

SQL
1

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

npm install mysql2
Posted by: Guest on February-21-2021
0

mariadb ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MariaDB client

#SQLTools - VSCode err: 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;
Posted by: Guest on January-29-2021
0

typescript Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password ...
Posted by: Guest on February-02-2021

Code answers related to "nodejs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Code answers related to "SQL"

Browse Popular Code Answers by Language