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
How to implement paging query in MySQL
SQL paging query:background In the company's ...
Example operation MySQL short link
How to set up a MySQL short link 1. Check the mys...
How to migrate the data directory in Docker
Table of contents View Disk Usage Disk Cleanup (D...
How to implement input checkbox to expand the click range
XML/HTML CodeCopy content to clipboard < div s...
The difference between ID and Name attributes of HTML elements
Today I am a little confused about <a href=&quo...
Analysis and solution of the reason why overflow-y: visible; does not work in CSS
Scenario A recent requirement is an h5 page for m...
How to use Linux tr command
01. Command Overview The tr command can replace, ...
Vue uses dynamic components to achieve TAB switching effect
Table of contents Problem Description What is Vue...
CentOS 6.6 source code compilation and installation of MySQL 5.7.18 tutorial detailed explanation
1. Add users and groups 1. Add mysql user group #...
Detailed explanation of using JavaScript WeakMap
A WeakMap object is a collection of key/value pai...
Detailed tutorial on installing Spring boot applications on Linux systems
Unix/Linux Services systemd services Operation pr...
Introduction to Semantic HTML Tags
In the past few years, DIV+CSS was very popular in...
How to modify the user and group of a file in Linux
In Linux, when a file is created, the owner of th...
Complete Tutorial on Deploying Java Web Project on Linux Server
Most of this article refers to other tutorials on...
TinyEditor is a simple and easy-to-use HTML WYSIWYG editor
A few days ago, I introduced to you a domestic xh...