Client does not support authentication protocol requested by server; consider upgrading MySQL client
Database connection failed,
Execute in MySQL window
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';
The code then:
flush privileges;
Reload permission table operation. Run the JS file again to successfully connect to the MySQL database.
Similar Posts:
- Error in connecting to MySQL via Navicat on MAC
- [Solved] Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv
- [Solved] Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by serv
- mysql 1449 The user specified as a definer does not exist
- MySQL Connect Error: Authentication plugin ‘caching_sha2_password’ cannot be loaded
- ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
- [Solved] MYSQL Error: this authentication plugin is not supported
- NodeJS Connect MYSQL Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
- [Solved] ER_NOT_SUPPORTED_AUTH_Mode node connection database error
- [Solved] MYSQL Error: django.db.utils.OperationalError: (1045:Access denied for user ‘root’@’localhost’ (using password: NO)