blocks|key|102256|text|我认为一些MySQL版本的建立连接的身份验证有点混乱。我所要做的就是将行"insecureAuth"+:+true添加到CreateConnection(...)凭据中。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|102257|var+connection+=+mysql.createConnection({
++host+++++:+'localhost',
++user+++++:+'root',
++password+:+'********',
++database+:+'vod_bill_database',
++insecureAuth+:+true
});+|code-block|syntax|javascript|102258|错误现在已消失，客户端已成功连接。|102259|entityMap^0|10|L|1O|L|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

I figure that some MySQL versions have the authentication for the establishment of a connection a bit messed up. All I had to do was add the line <code>&quot;insecureAuth&quot; : true</code> to the <code>CreateConnection(...)</code> credentials.
<pre><code>var connection = mysql.createConnection({
 host : 'localhost',
 user : 'root',
 password : '********',
 database : 'vod_bill_database',
 insecureAuth : true
}); 
</code></pre>
The error is gone now, and the client is successfully connecting.

blocks|key|2852277|text|现在8.0版本是改变插件的方式:使用这个例子：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2852278|ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'password'|code-block|syntax|javascript|2852279|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For now 8.0 version is way to change plugin :
Use this example:

<pre><code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
</code></pre>

blocks|key|102340|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|102341|📷|atomic|offset|length|102342|102343|重新配置身份验证方法，在那里您可以选择5.1的传统类型密码支持|102344|错误的原因|style|BOLD|102345|*您安装了最新的Mysql+8.0，它有不同的身份验证方法。降级5.6或5.1是一个简单的解决方案|102346|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/136b1266171951314293765ebb26f2aa.png|imageAlt^0|0|0|1|0|0|0|0|3|2|0|0|1D|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@$E|10|F|11|1|12]]|A|$]]|$1|G|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|15|8|@$E|16|F|17|L|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|18|8|@$E|19|F|1A|L|M]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W|X|-4]]]]

<a href="https://i.stack.imgur.com/iOcCe.png" rel="noreferrer"><img src="https://i.stack.imgur.com/iOcCe.png" alt="enter image description here"></a>

Do Reconfigure Authentication Method,there you select legacy type password support for 5.1

Reason for the error

*You Installed latest Mysql 8.0 ,it has deferent authentication method. degrading 5.6 or 5.1 is simple solution

blocks|key|105237|text|这个Q/A帖子中排名最高的答案大部分是准确/有效的，但至少可以说是杂乱无章的。然而，这里有一个解决方案；解决方案是在三个答案中找到零碎的东西。为了在一篇文章中提供一个更容易阅读和解释的答案和解决方案，更有帮助和节省时间，我将尝试用一套清晰、简洁和有序的说明来回答这个问题，这套说明涵盖了Ubuntu用户正在经历的整个问题。此外，我将添加必要的信息，这些信息不包括在其他答案中，以了解正在解决的问题。问题不是SQL的问题，而是Ubuntu的问题。为了让读者明白持久化的问题是什么，“ROOT”用户在Ubuntu中没有密码。Ubuntu用户使用sudo命令，并通过使用sudo+cmd的权限来组织权限，几乎所有事情都是如此，当然也有例外，还有一个Ubuntu根用户选项，但是现在在这里讨论这些事情是没有帮助的。需要注意的重要事项如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|105238|105239|Ubuntu缺少“超级用户密码”，这就是为什么每个遇到我们讨论的问题的人都会运行Ubuntu操作系统/外壳的发行版。我们不能给Ubuntu+SHELL一个‘根密码’，但是，我们可以，并且我们将给我们的'MYSQL-COMMUNITY-SERVER'.|unordered-list-item|105240|一个‘根密码’|105241|首先，您需要NPM、NodeJS、MySql和NPM的MySql驱动程序。如果你还没有，你甚至不应该阅读这篇文章，因为你甚至不能100%25地知道你正在解决的问题是不是这样的……|105242|...If您确实拥有列表中的所有内容，并且正在运行Ubuntu+dist。，并且收到错误验证消息和连接错误消息，如下所示|105243|105244|错误：(28000)：拒绝用户访问'ajc'@'localhost'|105245|ERROR:+ERROR_NOT_SUPPORTED_AUTH_MODE:客户端不支持服务器请求的身份验证协议；请考虑升级MySQL+Client+|105246|的客户端不支持服务器请求的身份验证协议；请考虑升级MySQL+client|105247|105248|那么你可能是在正确的地方。|105249|105250|要解决此问题，请先创建一个空的“dot+JS”文件进行测试，然后将其命名为“sqltest.js”或其他任何名称。|105251|105252|105253|将下面的代码添加到其中。|105254|105255|在名为'createConnection‘的方法中，|105256|是一个JSON+OBJ参数，用于保存与MySql数据库服务器建立有效连接所需的凭证值。用户必须等于'root'，并且数据库必须存在。此外，对于以后的测试，还可以向数据库添加一个测试表，其中包含一些BS数据。“|105257|105258|let+mysql+=+require('mysql');

let+connection+=+mysql.createConnection({
++++host+++++:+'localhost',
++++user+++++:+'root',
++++password+:+'********',
++++database+:+'DB_App_00',
});



connection.connect(function(err)+{
++++if+(err)+{
++++++return+console.error('error:+'+%2B+err.message);
++++}
++
++++console.log('Connected+to+the+MySQL+server.');
++});|code-block|syntax|javascript|105259|现在打开一个终端窗口，进行典型的更新和升级，这很重要，这就是为什么每个tut都要求你这样做的原因。|105260|~$:+sudo+apt+update
~$:+sudo+apt+upgrade|105261|让connection+=+mysql.createConnection({主机：‘本地主机’，用户：‘根’，密码：‘*’，数据库：'DB_App_00'，})；|105262|现在键入以下cmd|105263|~$:+sudo+mysql+-u+root|105264|105265|它应该会提示你输入你的Ubuntu密码，输入密码并输入。|105266|105267|现在，这里是可以被认为是解决问题的良药和/或治疗方法的步骤。您的终端应该是打开的，并且您应该在MYSQL服务器的内部，位于用户“root”下。终端的光标应该在空白的mysql命令行上闪烁。在CMDL中复制并粘贴以下内容：|105268|mysql>+ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'ChoosePassword';

mysql>+FLUSH+PRIVILEGES;|105269|105270|下一部分是显而易见的，将“ChoosePassword”更改为您将记住的密码，同时将密码保留在单引号内。绝对不更改任何其他内容，请按ENTER|105271|105272|105273|如果您正确地遵循了这些步骤，您现在就拥有了一个具有自己密码的MySQL“根用户”。通过在Ubuntu+CMDL上复制并粘贴以下内容来测试它：|105274|105275|+~$:+mysql+-u+root+-p+|105276|105277|它将提示您输入新密码，然后键入密码并输入|105278|105279|...you应该在，现在退出。|105280|mysql>exit|105281|105282|返回到'testsql.js‘文件，将用户的凭据更改为超级用户，将密码更改为您的密码，将有效的数据库更改为主机，将主机更改为本地主机，除非您唯一需要不同的主机名。|105283|105284|let+connection+=+mysql.createConnection({
++++host+++++:+'localhost',
++++user+++++:+'root',
++++password+:+'********',
++++database+:+'DB_App_00',
});|105285|现在使用node运行节点测试文件|105286|~$:+node+testsql.js|105287|如果没有说connected你做错了什么，但如果一切顺利，你应该连接。我花了一些功夫才让它起作用，但这个答案应该会节省你阅读所有其他一半的书面答案的时间。|105288|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|2R|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|2S|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|2T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|2U|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|2V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|2W|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|2X|8|@]|9|@]|A|$]]|$1|M|3|N|5|E|7|2Y|8|@]|9|@]|A|$]]|$1|O|3|P|5|E|7|2Z|8|@]|9|@]|A|$]]|$1|Q|3|R|5|E|7|30|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|31|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|32|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|33|8|@]|9|@]|A|$]]|$1|W|3|X|5|E|7|34|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|35|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|36|8|@]|9|@]|A|$]]|$1|10|3|11|5|E|7|37|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|38|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|39|8|@]|9|@]|A|$]]|$1|15|3|16|5|E|7|3A|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|3B|8|@]|9|@]|A|$]]|$1|18|3|19|5|1A|7|3C|8|@]|9|@]|A|$1B|1C]]|$1|1D|3|1E|5|6|7|3D|8|@]|9|@]|A|$]]|$1|1F|3|1G|5|1A|7|3E|8|@]|9|@]|A|$1B|1C]]|$1|1H|3|1I|5|6|7|3F|8|@]|9|@]|A|$]]|$1|1J|3|1K|5|6|7|3G|8|@]|9|@]|A|$]]|$1|1L|3|1M|5|1A|7|3H|8|@]|9|@]|A|$1B|1C]]|$1|1N|3|-4|5|6|7|3I|8|@]|9|@]|A|$]]|$1|1O|3|1P|5|E|7|3J|8|@]|9|@]|A|$]]|$1|1Q|3|-4|5|6|7|3K|8|@]|9|@]|A|$]]|$1|1R|3|1S|5|6|7|3L|8|@]|9|@]|A|$]]|$1|1T|3|1U|5|1A|7|3M|8|@]|9|@]|A|$1B|1C]]|$1|1V|3|-4|5|6|7|3N|8|@]|9|@]|A|$]]|$1|1W|3|1X|5|E|7|3O|8|@]|9|@]|A|$]]|$1|1Y|3|-4|5|6|7|3P|8|@]|9|@]|A|$]]|$1|1Z|3|-4|5|6|7|3Q|8|@]|9|@]|A|$]]|$1|20|3|21|5|E|7|3R|8|@]|9|@]|A|$]]|$1|22|3|-4|5|6|7|3S|8|@]|9|@]|A|$]]|$1|23|3|24|5|1A|7|3T|8|@]|9|@]|A|$1B|1C]]|$1|25|3|-4|5|6|7|3U|8|@]|9|@]|A|$]]|$1|26|3|27|5|E|7|3V|8|@]|9|@]|A|$]]|$1|28|3|-4|5|6|7|3W|8|@]|9|@]|A|$]]|$1|29|3|2A|5|6|7|3X|8|@]|9|@]|A|$]]|$1|2B|3|2C|5|1A|7|3Y|8|@]|9|@]|A|$1B|1C]]|$1|2D|3|-4|5|6|7|3Z|8|@]|9|@]|A|$]]|$1|2E|3|2F|5|E|7|40|8|@]|9|@]|A|$]]|$1|2G|3|-4|5|6|7|41|8|@]|9|@]|A|$]]|$1|2H|3|2I|5|1A|7|42|8|@]|9|@]|A|$1B|1C]]|$1|2J|3|2K|5|6|7|43|8|@]|9|@]|A|$]]|$1|2L|3|2M|5|1A|7|44|8|@]|9|@]|A|$1B|1C]]|$1|2N|3|2O|5|6|7|45|8|@]|9|@]|A|$]]|$1|2P|3|-4|5|6|7|46|8|@]|9|@]|A|$]]]|2Q|$]]

The top-rated answers in this Q/A thread are for the most part accurate/valid, but unorganized to say the least. A solution is here, however; the solution is pieces and bits found amongst three answers. To offer an answer and solution that exist in a single post is easier to read, interpret, and all-around more helpful and a time saver, I will make an attempt to answer the question with a clear, concise, and orderly set of instructions that covers the whole Problem that Ubuntu users are experiencing. In addition, I will add information necessary, not included in other answers, for understanding the issue being solved. Like that the problem is not a SQL problem it is an Ubuntu. To bring clarity to readers, of what the problem in persistence is; the 'ROOT' user doesn't have a password in Ubuntu. Ubuntu users use the sudo command, and organize authority through the permission of use of the sudo cmd for pretty much everything, there are exceptions and there is a Ubuntu Root User option, but it doesn't help to discuss those things right here, right now. The important thing to note is the following:
<ul>
<li>Ubuntu lacks a 'ROOT PASSWORD' and this is why everyone experiencing the issue that we are discussing runs a Distribution of the Ubuntu OS/SHELL. We cannot give Ubuntu SHELL a 'ROOT PASSWORD', however, we can, and we are, going to give a 'ROOT PWD' to our 'MYSQL-COMMUNITY-SERVER'.</li>
</ul>
Firstly you need NPM, NodeJS, MySql, and NPM's MySql Driver. If you don't already have them you shouldn't even be reading this, because your cant even know 100% if the issue you are solving is this...
...If you do have everything on the list, and are running a Ubuntu dist., and are getting error authentication messages and Connection err messages that look like the following
<ul>
<li>ERROR: (28000): Access denied for user 'ajc'@'localhost'</li>
<li>ERROR: ERROR_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client</li>
<li>'Client does not support authentication protocol requested by server; consider upgrading MySQL client</li>
</ul>
Then you are likely in the right place.
<ul>
<li>To solve the problem start by creating an Empty 'dot JS' file for testing, call it 'sqltest.js' or whatever you like.
</li>
<li>Add the CODE bellow to it.
</li>
<li>In the method called 'createConnection' is a JSON OBJ parameter holding the credential values to make a valid connection to the MySql database server. The user has to equal to 'root', and the database has to exist. Also for a later test add a testing table to the database, with some BS data.&quot;
</li>
</ul>
<pre><code>let mysql = require('mysql');

let connection = mysql.createConnection({
 host : 'localhost',
 user : 'root',
 password : '********',
 database : 'DB_App_00',
});



connection.connect(function(err) {
 if (err) {
 return console.error('error: ' + err.message);
 }
 
 console.log('Connected to the MySQL server.');
 });


</code></pre>
Now open a terminal window, and do your typical updates &amp; upgrades, this is important, which is why every tut asks you to do them.
<pre><code>~$: sudo apt update
~$: sudo apt upgrade
</code></pre>
let connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '********',
database : 'DB_App_00',
});
Now type the following cmd
<pre><code>~$: sudo mysql -u root

</code></pre>
<ul>
<li>It should prompt you for your Ubuntu Password, type it and [ENTER].</li>
</ul>
Now here is the step that could be considered the medicine and/or the cure to the problem. Your terminal should be open, and you should be inside of the MYSQL Server, under the user 'root'. The terminal should have the cursor flashing at a blank mysql command-line. Within the CMDL copy &amp; paste this:
<pre><code>mysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ChoosePassword';

mysql&gt; FLUSH PRIVILEGES;

</code></pre>
<ul>
<li>The next part is obvious, change 'ChoosePassword' to a password you will remember while leaving the password within single quotation marks. Change absolutely nothing else, press [ENTER]
</li>
<li>If you followed the steps correctly, you now have a MySQL 'ROOT USER' with its own password now. Test it by copy and paste the following at the Ubuntu CMDL:
</li>
</ul>
<pre><code> ~$: mysql -u root -p 
</code></pre>
<ul>
<li>It will prompt you for your new password, type it and [ENTER]</li>
</ul>
...you should be in, now exit.
<pre><code>mysql&gt;exit
</code></pre>
<ul>
<li>Back to your 'testsql.js' file, alter the credentials to root for the user, password to your password, a valid database, and host to localhost, unless you have a unique need for a different hostname.</li>
</ul>
<pre><code>
let connection = mysql.createConnection({
 host : 'localhost',
 user : 'root',
 password : '********',
 database : 'DB_App_00',
});


</code></pre>
now use node to run the node test file
<pre><code>~$: node testsql.js
</code></pre>
If it doesn't say connected you did something wrong, but if all went well, you should connect. It took some effort before I got it to work, but this answer should save you some time from reading all the other half written answers.

blocks|key|2852482|text|您可以更改现有用户以使用mysql_native_password，也可以创建一个新用户。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2852483|CREATE+USER+'new_user'@'%25'+IDENTIFIED+WITH+mysql_native_password+BY+'***';
GRANT+USAGE+ON+*.*+TO+'new_user'@'%25';
ALTER+USER+'new_user'@'%25'+REQUIRE+NONE+WITH+MAX_QUERIES_PER_HOUR+0+MAX_CONNECTIONS_PER_HOUR+0+MAX_UPDATES_PER_HOUR+0+MAX_USER_CONNECTIONS+0;
GRANT+ALL+PRIVILEGES+ON+`new_user`.*+TO+'new_user'@'%25';
FLUSH+PRIVILEGES;|code-block|syntax|javascript|2852484|将new_user替换为您的新用户名，并设置密码。|2852485|现在，您可以使用mysql包从节点访问mysql。|2852486|+npm+install+mysql|2852487|建议对此包使用池连接。|2852488|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You can either alter an existing user to use mysql_native_password, or create a new user,

<pre><code>CREATE USER 'new_user'@'%' IDENTIFIED WITH mysql_native_password BY '***';
GRANT USAGE ON *.* TO 'new_user'@'%';
ALTER USER 'new_user'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
GRANT ALL PRIVILEGES ON `new_user`.* TO 'new_user'@'%';
FLUSH PRIVILEGES;
</code></pre>

replace new_user with your new user name, and set your password.

Now you can access mysql from node using the mysql package,

<pre><code> npm install mysql
</code></pre>

recommended to use pool connection for this package.

blocks|key|2852545|text|您可以使用包mysql2而不是mysql。我遇到了同样的问题，使用mysql2对我很有效。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2852546|您可以使用npm+i+mysql2安装此软件包|2852547|entityMap^0|6|6|F|5|X|6|0|5|C|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|I|$]]

You can use the package <code>mysql2</code> instead of <code>mysql</code>. I ran into the same issue and using <code>mysql2</code> worked for me.
You can install this package using <code>npm i mysql2</code>

blocks|key|105177|text|第一次运行此代码->|type|unstyled|depth|inlineStyleRanges|entityRanges|data|105178|ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'password';|code-block|syntax|javascript|105179|第二位|105180|flush+privileges;|105181|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

1st run this code -> 

<pre><code>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
</code></pre>

2nd 

<pre><code>flush privileges;
</code></pre>

blocks|key|105126|text|尝试旧版本的mysql，如5.6.40，它默认使用SHA256_password身份验证where新版本8.0。默认情况下，使用更安全的sha2_password身份验证，并抛出此身份验证协议错误。MYSQL+installer+5.6.40|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|105127|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-web-community-5.6.40.1.msi^0|0|J|2I|8|2R|M|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@$9|S|A|T|1|U]]|E|$]]|$1|F|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

try the older version of mysql like 5.6.40, it uses by default SHA256_password auth where new version 8.0. uses by default sha2_password auth which is more secure and throw this authentication protocol error.
<a href="https://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-web-community-5.6.40.1.msi" rel="nofollow noreferrer">MYSQL installer 5.6.40</a>

blocks|key|105260|text|var+connection+=+mysql.createConnection({
++host+++++:+'localhost',
++user+++++:+'root',
++password+:+'********',
++database+:+'vod_bill_database',
++port+:+3308+
});+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|105261|我也有同样的错误，因为我把phpmyadmin中的端口从3306改为3308，所以我不得不在这里写port:+3308，然后它就开始工作了。|unstyled|105262|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>var connection = mysql.createConnection({
 host : 'localhost',
 user : 'root',
 password : '********',
 database : 'vod_bill_database',
 port : 3308 
}); 
</code></pre>

I had the same error and since i changed my port in phpmyadmin from 3306 to 3308 therefore here also i had to write port: 3308 and it started working.

blocks|key|102348|text|为了克服这个错误，请使用以下代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|102349|var+connectionString+=+'mysql://*root:*password@*localhost/*database?charset=utf8_general_ci&timezone=-0700';+
var+connection=+mysql.createConnection(connectionString);+|code-block|syntax|javascript|102350|但请确保根据您的设置更改了connectionString中的*标记。|102351|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

in order to overcome this error use the following code:

<pre><code>var connectionString = 'mysql://*root:*password@*localhost/*database?charset=utf8_general_ci&amp;timezone=-0700'; 
var connection= mysql.createConnection(connectionString); 
</code></pre>

but make sure that you changed the * marks in the connectionString based on your setup.

blocks|key|105314|text|只需在MySQL上创建一个新用户|type|unstyled|depth|inlineStyleRanges|entityRanges|data|105315|CREATE+USER+'foo'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'bar';|code-block|syntax|javascript|105316|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

just create a new user on MySQL
<pre><code>CREATE USER 'foo'@'localhost' IDENTIFIED WITH mysql_native_password BY 'bar';
</code></pre>

blocks|key|105276|text|黄色的yow兄弟！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|105277|//+mysql.ts
const+pool+=+mysql.createPool({
++++connectionLimit:+10,
++++host:+"localhost",
++++user:+"root",
++++password:+"password",
++++database:+"rest-resume-api",
});|code-block|syntax|javascript|105278|然后我有一个docker-compose文件，比如|105279|#+docker-compose.yml

version:+'3.3'

services:
++db:
++++image:+mysql
++++restart:+always
++++command:+--default-authentication-plugin=mysql_native_password
++++environment:
++++++MYSQL_DATABASE:+'rest-resume-api'
++++++MYSQL_USER:+'root'
++++++MYSQL_ROOT_PASSWORD:+'password'
++++ports:
++++++-+'3306:3306'
++++expose:
++++++-+'3306'
++++volumes:
++++++-+my-db:/var/lib/mysql2
volumes:
++my-db:|105280|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

yellow yow bros !

<pre class="lang-js prettyprint-override"><code>// mysql.ts
const pool = mysql.createPool({
 connectionLimit: 10,
 host: "localhost",
 user: "root",
 password: "password",
 database: "rest-resume-api",
});
</code></pre>

and then I have a docker-compose file such as

<pre><code># docker-compose.yml

version: '3.3'

services:
 db:
 image: mysql
 restart: always
 command: --default-authentication-plugin=mysql_native_password
 environment:
 MYSQL_DATABASE: 'rest-resume-api'
 MYSQL_USER: 'root'
 MYSQL_ROOT_PASSWORD: 'password'
 ports:
 - '3306:3306'
 expose:
 - '3306'
 volumes:
 - my-db:/var/lib/mysql2
volumes:
 my-db:

</code></pre>

<h4>Failed to Connect to MySQL DB via MySQL JavaScript Module</h4>
        I added a &quot;MySQL&quot; database to my &quot;Node.js&quot; server. After going through the &quot;MySQL&quot; setup process — to ensure the DB was working — I attempted to connect to the server via the JavaScript de facto code snippet (example below), and to my dismay, the connection attempt failed.
 
 
<h4>When the Connection Failed, the Following Error was Logged:</h4>
<blockquote>
&quot;ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication
protocol requested by server; consider upgrading MariaDB client&quot;
</blockquote>
        The error was perplexing to me, as I already uninstalled &quot;MariaDB&quot;, and installed &quot;MySQL&quot; in its place. What I would like to know is what is causing the error, and how can I fix it so I am able to connect to the Database?
<hr />
<pre><code>
 // This is my attempt of connection

 var mysql = require('mysql');
 
 var connection = mysql.createConnection({
 host : 'localhost',
 user : 'root',
 password : '********',
 database : 'foobarDb'
 }); 
</code></pre>

ER_NOT_SUPPORTED_AUTH_MODE - MySQL server

身份验证

数据库

服务器

MariaDB

Docker

Ubuntu

MySQL

JSON

​无法通过MySQL JavaScript模块连接到MySQL DB后来，我在我的“MySQL”服务器上添加了一个“Node.js”数据库。在完成"MySQL"设置过程之后-为了确保数据库正常工作-我尝试通过JavaScript事实代码片段(示例如下)连接到服务器，但令我沮丧的是，连接尝试失败了。​​当连接失败时，会记录以下错误： "ER_NOT_SUPPORTED_AUTH_MODE:客户端不支

问ER_NOT_SUPPORTED_AUTH_MODE - MySQL服务器
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ER_NOT_SUPPORTED_AUTH_MODE - MySQL服务器EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ER_NOT_SUPPORTED_AUTH_MODE - MySQL服务器
EN