Solve the problem that the Node.js mysql client does not support the authentication protocol
|
Preface The mysql module (project address is https://github.com/mysqljs/mysql) is an open source MySQL driver written in JavaScript that can operate MySQL in Node.js applications. However, during use, the "ER_NOT_SUPPORTED_AUTH_MODE" problem occurred. This article describes the cause and solution of this problem. Error message When I try to connect to MySQL 8 using the mysql module, I get the following error message: D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\index.js:17 throw error; ^ Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client at Handshake.Sequence._packetToError (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14) at Handshake.ErrorPacket (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18) at Protocol._parsePacket (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\protocol\Protocol.js:291:23) at Parser._parsePacket (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\protocol\Parser.js:433:10) at Parser.write (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\protocol\Parser.js:43:10) at Protocol.write (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\protocol\Protocol.js:38:16) at Socket.<anonymous> (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\Connection.js:91:28) at Socket.<anonymous> (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\Connection.js:525:10) at Socket.emit (events.js:196:13) at addChunk (_stream_readable.js:290:12) -------------------- at Protocol._enqueue (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\protocol\Protocol.js:144:48) at Protocol.handshake (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\protocol\Protocol.js:51:23) at Connection.connect (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\node_modules\mysql\lib\Connection.js:119:18) at Object.<anonymous> (D:\workspaceGithub\nodejs-book-samples\samples\mysql-demo\index.js:12:12) at Module._compile (internal/modules/cjs/loader.js:759:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:770:10) at Module.load (internal/modules/cjs/loader.js:628:32) at Function.Module._load (internal/modules/cjs/loader.js:555:12) at Function.Module.runMain (internal/modules/cjs/loader.js:826:10) at internal/main/run_main_module.js:17:11 Cause of error The reason for this error is that currently, the latest MySQL module does not fully support the "caching_sha2_password" encryption method of MySQL 8, and "caching_sha2_password" is the default encryption method in MySQL 8. Therefore, the following command uses the "caching_sha2_password" encryption method by default, and the account and password cannot be used in the mysql module. mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; Query OK, 0 rows affected (0.12 sec) Workaround The solution is to modify the password of user root and specify the encryption method that the mysql module can support: mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; Query OK, 0 rows affected (0.12 sec) The above statement shows that the encryption method using "mysql_native_password" is specified. This method is supported by the mysql module. Run the application again and you can see the following console output:
$ node index.js
The result is: RowDataPacket { user_id: 1, username: '老卫' }Among them, "RowDataPacket { user_id: 1, username: '老卫' }" is the result of the database query. Source code The examples in this section can be found in the "mysql-demo" application at https://github.com/waylau/nodejs-book-samples. The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: WeChat applet implements a simple handwritten signature component
>>: Detailed explanation of browser negotiation cache process based on nginx
Recommend
Vue code highlighting plug-in comprehensive comparison and evaluation
Table of contents Comprehensive comparison From t...
Vue3.0+vite2 implements dynamic asynchronous component lazy loading
Table of contents Create a Vite project Creating ...
VMware Workstation 15 Pro Installation Guide (for Beginners)
01. VMware Workstation Pro 15 Download Download: ...
CSS and CSS3 flexible box model to achieve element width (height) adaptation
1. CSS realizes fixed width on the left and adapt...
Negative distance (empathy) - iterative process of mutual influence
Negative distance refers to empathy. Preface (rai...
Solution to the problem of var in for loop
Preface var is a way to declare variables in ES5....
Detailed explanation of the interaction between React Native and IOS
Table of contents Prerequisites RN passes value t...
Solution to the problem of passing values between html pages
The first time I used the essay, I felt quite awkw...
Detailed explanation of the Svelte implementation principle for simple and easy JavaScript development
Table of contents Demo1 create_fragment SvelteCom...
This article will show you how to use SQL CASE WHEN in detail
Table of contents Simple CASEWHEN function: This ...
CSS and JS to achieve romantic meteor shower animation
1. Rendering 2. Source code HTML < body > &...
Detailed explanation of JavaScript's built-in objects Math and strings
Table of contents Math Objects Common properties ...
Let's talk about the v-on parameter problem in Vue
Use of v-on:clock in Vue I'm currently learni...
In-depth analysis of the various backgrounds, usage scenarios and techniques of CSS
This article has been included on GitHub https://...
CentOS7 firewall and port related commands introduction
Table of contents 1. Check the current status of ...