blocks|key|97606|text|从PHP7.4开始，这不再是一个问题。在mysqlnd.中添加了对+caching_sha2+身份验证方法的支持|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|97607|97608|目前，PHP+mysqli扩展不支持新的caching_sha2身份验证功能。你必须等到他们发布更新。|97609|查看MySQL+developers的相关帖子：https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/|97610|他们没有提到PDO，也许你应该试着连接PDO。|97611|entityMap|0|LINK|mutability|MUTABLE|url|https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/^0|0|S|Y|C|1B|9|Y|C|0|0|0|1F|0|0|3C|O|2O|0|0|0|N|0^^$0|@$1|2|3|4|5|6|7|V|8|@$9|W|A|X|B|C]|$9|Y|A|Z|B|C]|$9|10|A|11|B|C]|$9|12|A|13|B|D]]|E|@]|F|$]]|$1|G|3|-4|5|6|7|14|8|@]|E|@]|F|$]]|$1|H|3|I|5|6|7|15|8|@$9|16|A|17|B|C]]|E|@]|F|$]]|$1|J|3|K|5|6|7|18|8|@$9|19|A|1A|B|C]]|E|@$9|1B|A|1C|1|1D]]|F|$]]|$1|L|3|M|5|6|7|1E|8|@$9|1F|A|1G|B|C]]|E|@]|F|$]]|$1|N|3|-4|5|6|7|1H|8|@]|E|@]|F|$]]]|O|$P|$5|Q|R|S|F|$T|U]]]]

As of PHP 7.4, this is no longer an issue. Support for <code>caching_sha2</code> authentication method has been added to mysqlnd.

<hr>

Currently, PHP mysqli extension do not support new caching_sha2 authentication feature.
You have to wait until they release an update.

Check related post from MySQL developers: <a href="https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/" rel="noreferrer">https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/</a>

They didn't mention PDO, maybe you should try to connect with PDO.

blocks|key|2842074|text|我通过SQL命令来解决这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2842075|ALTER+USER+'mysqlUsername'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'mysqlUsernamePassword';|code-block|syntax|javascript|2842076|由https://dev.mysql.com/doc/refman/8.0/en/alter-user.html引用的|offset|length|2842077|如果要创建新用户|2842078|+CREATE+USER+'jeffrey'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'password';|2842079|由https://dev.mysql.com/doc/refman/8.0/en/create-user.html引用的|2842080|这对我很管用|2842081|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/alter-user.html|1|https://dev.mysql.com/doc/refman/8.0/en/create-user.html^0|0|0|1|1J|0|0|0|0|1|1K|1|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@$I|15|J|16|1|17]]|A|$]]|$1|K|3|L|5|6|7|18|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|19|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|1A|8|@]|9|@$I|1B|J|1C|1|1D]]|A|$]]|$1|Q|3|R|5|6|7|1E|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]|10|$5|V|W|X|A|$Y|11]]]]

I solve this by SQL command:

<pre><code>ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';
</code></pre>

which is referenced by <a href="https://dev.mysql.com/doc/refman/8.0/en/alter-user.html" rel="noreferrer">https://dev.mysql.com/doc/refman/8.0/en/alter-user.html</a>

if you are creating new user 

<pre><code> CREATE USER 'jeffrey'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
</code></pre>

which is referenced by <a href="https://dev.mysql.com/doc/refman/8.0/en/create-user.html" rel="noreferrer">https://dev.mysql.com/doc/refman/8.0/en/create-user.html</a>

this works for me

blocks|key|97203|text|ALTER+USER+'mysqlUsername'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'mysqlUsernamePassword';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|97204|删除ALTER+USER后的引号(')，保留mysql_native_password+BY后的引号(')|unstyled|offset|length|style|CODE|97205|它对我也很有效。|97206|entityMap^0|0|2|A|M|O|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|P|8|@$G|Q|H|R|I|J]|$G|S|H|T|I|J]]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$]]|$1|M|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|N|$]]

<pre><code>ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';
</code></pre>

Remove quotes (') after <code>ALTER USER</code> and keep quote (') after <code>mysql_native_password BY</code>

It is working for me also.

blocks|key|2842132|text|适用于我(PHP5.6%2B+PDO+/WindowsServer8.0/+MySQL+7+64位)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2842133|编辑文件C:\ProgramData\MySQL\MySQL+Server+8.0\my.ini：|offset|length|style|CODE|2842134|default_authentication_plugin=mysql_native_password|code-block|syntax|javascript|2842135|在MySQL外壳中重置Window上的MySQL服务...|2842136|ALTER+USER+my_user@'%25'+IDENTIFIED+WITH+mysql_native_password+BY+'password';|2842137|entityMap^0|0|4|18|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

It's working for me (PHP 5.6 + PDO / MySQL Server 8.0 / Windows 7 64bits)

Edit the file <code>C:\ProgramData\MySQL\MySQL Server 8.0\my.ini</code>: 

<pre><code>default_authentication_plugin=mysql_native_password
</code></pre>

Reset MySQL service on Windows, and in the MySQL Shell...

<pre><code>ALTER USER my_user@'%' IDENTIFIED WITH mysql_native_password BY 'password';
</code></pre>

blocks|key|2630775|text|我在命令行中运行了以下命令ALTER+USER+'root'+@+'localhost'+identified+with+mysql_native_password+BY+'root123';，最后在本地服务中重新启动了MySQL。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2630776|entityMap^0|D|2B|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

I ran the following command
<code>ALTER USER 'root' @ 'localhost' identified with mysql_native_password BY 'root123';</code> in the command line and finally restart MySQL in local services.

blocks|key|2842302|text|如果你在Windows上，根本不可能使用caching_sha2_password，你可以执行以下操作：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2842303|重新运行MySQL+Installer|2842304|select+(顶部项目)旁边的MySQL+Installer|unordered-list-item|2842305|
|2842306|select+"Reconfigure“并单击"+next”，直到出现"Authentication+Method“和"Use+Strong+Password+Encryption+|2842307|
+Authentication+(RECOMMENDED)”to+"Use+MySQL+Authentication+Method+(Retain+5.X+Compatibility)|2842308|click+"Next"|2842309|2842310|enter+your+Root+Account+Password+in+Accounts+|2842311|2842312|+Roles，然后单击"Check"|2842313|2842314|click+"Next“，然后继续单击”Next“，直到出现"Apply+Configuration"|2842315|2842316|click”|2842317|
“|2842318|”|2842319|2842320|安装程序将为您进行所需的所有配置更改。|2842321|entityMap^0|K|L|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|1D|8|@$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1G|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1H|8|@]|D|@]|E|$]]|$1|K|3|L|5|6|7|1I|8|@]|D|@]|E|$]]|$1|M|3|N|5|J|7|1J|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|1K|8|@]|D|@]|E|$]]|$1|Q|3|R|5|J|7|1L|8|@]|D|@]|E|$]]|$1|S|3|L|5|6|7|1M|8|@]|D|@]|E|$]]|$1|T|3|U|5|J|7|1N|8|@]|D|@]|E|$]]|$1|V|3|L|5|6|7|1O|8|@]|D|@]|E|$]]|$1|W|3|X|5|J|7|1P|8|@]|D|@]|E|$]]|$1|Y|3|L|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|Z|3|10|5|J|7|1R|8|@]|D|@]|E|$]]|$1|11|3|L|5|6|7|1S|8|@]|D|@]|E|$]]|$1|12|3|13|5|J|7|1T|8|@]|D|@]|E|$]]|$1|14|3|15|5|6|7|1U|8|@]|D|@]|E|$]]|$1|16|3|17|5|J|7|1V|8|@]|D|@]|E|$]]|$1|18|3|-4|5|6|7|1W|8|@]|D|@]|E|$]]|$1|19|3|1A|5|6|7|1X|8|@]|D|@]|E|$]]|$1|1B|3|-4|5|6|7|1Y|8|@]|D|@]|E|$]]]|1C|$]]

If you're on Windows and it's not possible to use <code>caching_sha2_password</code> at all, you can do the following:

<ol>
<li>rerun the MySQL Installer</li>
<li>select "Reconfigure" next to MySQL Server (the top item)</li>
<li>click "Next" until you get to "Authentication Method"</li>
<li>change "Use Strong Password Encryption for Authentication (RECOMMENDED)" to "Use Legacy Authentication Method (Retain MySQL 5.X Compatibility)</li>
<li>click "Next"</li>
<li>enter your Root Account Password in Accounts and Roles, and click "Check"</li>
<li>click "Next"</li>
<li>keep clicking "Next" until you get to "Apply Configuration"</li>
<li>click "Execute"</li>
</ol>

The Installer will make all the configuration changes needed for you.

blocks|key|2842323|text|我在Ubuntu+18.04中尝试过，这是唯一对我有效的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2842324|ALTER+USER+my_user@'%25'+IDENTIFIED+WITH+mysql_native_password+BY+'password';|code-block|syntax|javascript|2842325|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|$]]

I tried this in Ubuntu 18.04
and is the only solution that worked for me:

<pre><code>ALTER USER my_user@'%' IDENTIFIED WITH mysql_native_password BY 'password';
</code></pre>

blocks|key|97291|text|我认为在没有caching_sha2_password加密的情况下配置mysql服务器是没有用的，我们必须找到一种通过网络发布、发送或获取安全信息的方法。正如您在下面的代码中所看到的，我没有使用变量$db_name，而是在mysql服务器中使用一个具有标准配置密码的用户。只需创建一个标准用户密码并配置所有权限即可。它是有效的，但我所说的没有段安全性。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|97292|<?php
$db_name="db";
$mysql_username="root";
$mysql_password="****";
$server_name="localhost";
$conn=mysqli_connect($server_name,$mysql_username,$mysql_password);

if+($conn)+{
++++echo+"connetion+success";
}
else{
++++echo+mysqli_error($conn);
}

?>|code-block|syntax|javascript|97293|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|$]]

I think it is not useful to configure the mysql server without caching_sha2_password encryption, we have to find a way to publish, send or obtain secure information through the network. As you see in the code below I dont use variable $db_name, and Im using a user in mysql server with standar configuration password. 
Just create a Standar user password and config all privilages. it works, but how i said without segurity.

<pre><code>&lt;?php
$db_name="db";
$mysql_username="root";
$mysql_password="****";
$server_name="localhost";
$conn=mysqli_connect($server_name,$mysql_username,$mysql_password);

if ($conn) {
 echo "connetion success";
}
else{
 echo mysqli_error($conn);
}

?&gt;
</code></pre>

blocks|key|97305|text|如果你使用的是Mac，下面是如何修复它的方法。这是在大量的试验和错误之后。希望这对其他人有帮助..|type|unstyled|depth|inlineStyleRanges|entityRanges|data|97306|调试：|97307|$mysql+--verbose+--help+%7C+grep+my.cnf

$+which+mysql
/usr/local/bin/mysql|code-block|syntax|javascript|97308|分辨率:+nano+/usr/local/etc/my.cnf|97309|添加:+default-authentication-plugin=mysql_native_password|97310|-------
#+Default+Homebrew+MySQL+server+config
[mysqld]
#+Only+allow+connections+from+localhost
bind-address+=+127.0.0.1
default-authentication-plugin=mysql_native_password
------|97311|最后运行:+brew服务重新启动mysql|97312|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|X|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

If you're on a Mac, here's how to fix it. This is after tons of trial and error. Hope this helps others..

Debugging:

<pre><code>$mysql --verbose --help | grep my.cnf

$ which mysql
/usr/local/bin/mysql
</code></pre>

Resolution:
nano /usr/local/etc/my.cnf

Add: default-authentication-plugin=mysql_native_password

<pre><code>-------
# Default Homebrew MySQL server config
[mysqld]
# Only allow connections from localhost
bind-address = 127.0.0.1
default-authentication-plugin=mysql_native_password
------
</code></pre>

Finally Run: brew services restart mysql

blocks|key|97319|text|像许多人一样，我也有同样的问题。尽管用户被设置为使用mysql_native_password，并且我可以从命令行进行连接，但是我可以让mysqli()进行连接的唯一方法是添加|type|unstyled|depth|inlineStyleRanges|entityRanges|data|97320|97321|+default-authentication-plugin=mysql_native_password|blockquote|97322|97323|97324|的mysqld部分，在我的ubuntu+19.10设置中，/etc/mysql/mysql.conf.d/mysqld.cnf|97325|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|M|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|N|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|O|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|P|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Q|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|K|$]]

Like many many people, I have had the same problem. Although the user is set to use mysql_native_password, and I can connect from the command line, the only way I could get mysqli() to connect is to add

<blockquote>
 default-authentication-plugin=mysql_native_password
</blockquote>

to the [mysqld] section of, in my setup on ubuntu 19.10, /etc/mysql/mysql.conf.d/mysqld.cnf

blocks|key|2630966|text|现在您可以升级到PHP7.4，默认情况下MySQL将与caching_sha2_password一起使用，因此默认的MySQL安装将与mysqli_connect一起工作，无需配置。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2630967|entityMap^0|R|L|1V|E|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Now you can upgrade to PHP7.4 and MySQL will go with <code>caching_sha2_password</code> by default, so default MySQL installation will work with <code>mysqli_connect</code> No configuration required.

blocks|key|97335|text|我使用的是Laravel5.8，MAMP服务器通过在.env文件中添加DB_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock解决了这个错误，如下所示|type|unstyled|depth|inlineStyleRanges|entityRanges|data|97336|DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=8889
DB_DATABASE=dbname
DB_USERNAME=root
DB_PASSWORD=root
DB_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock|code-block|syntax|javascript|97337|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|$]]

I am using laravel 5.8 and having MAMP server got this error resolved by adding DB_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock in .env file like below
<pre><code>DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=8889
DB_DATABASE=dbname
DB_USERNAME=root
DB_PASSWORD=root
DB_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock
</code></pre>

blocks|key|97416|text|在我的例子中，当我使用WAMP服务器时，我用以下命令修复了它|type|unstyled|depth|inlineStyleRanges|entityRanges|data|97417|97418|注意mySQL的"my.ini“文件中的端口。在我的例子中，当我切换b/w+MariaDB和MySQL+DB时，它被更改为MySQL+3308。|ordered-list-item|97419|97420|​|97421|📷|atomic|offset|length|97422|97423|97424|在创建mysqli对象时使用端口号。|97425|97426|97427|97428|97429|使用上面的步骤，我能够成功地运行程序。|97430|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/3a252f4ab11949199b4a2f5e93ade3dd.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/9b2f1c554551366a715962eb5915da8b.png^0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|1|1|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1A|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1D|8|@]|9|@$L|1E|M|1F|1|1G]]|A|$]]|$1|N|3|H|5|6|7|1H|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|P|3|Q|5|E|7|1J|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|S|3|H|5|6|7|1L|8|@]|9|@]|A|$]]|$1|T|3|J|5|K|7|1M|8|@]|9|@$L|1N|M|1O|1|1P]]|A|$]]|$1|U|3|H|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1R|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14|15|-4]]|16|$5|10|11|12|A|$13|17|15|-4]]]]

In my case when I was using WAMP server I fixed it using following
<ol>
<li>Note the port in mySQL's &quot;my.ini&quot; file. In my case it was changed to 3308 when I was switching b/w MariaDB and MySQL DB.</li>
</ol>
<a href="https://i.stack.imgur.com/o7Cr5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o7Cr5.png" alt="enter image description here" /></a>
<ol start="2">
<li>Use the port number when you create mysqli object.</li>
</ol>
<a href="https://i.stack.imgur.com/ctgV5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ctgV5.png" alt="enter image description here" /></a>
Using the above steps I was able to run the program successfully.

blocks|key|97864|text|phpMyAdmin图形用户界面方式|type|unstyled|depth|inlineStyleRanges|entityRanges|data|97865|注意：如果根用户帐户有问题，此方法可能不起作用。|offset|length|style|BOLD|97866|97867|以超级用户身份登录到phpMyAdmin。|ordered-list-item|97868|切换到“用户帐户”选项卡。|97869|选择出现错误的用户名。|97870|从顶部按钮切换到“登录信息”部分。|97871|在“登录信息”框中，将“身份验证插件”从“缓存sha2身份验证”更改为“本地MySQL身份验证”。此外，您还必须填写其他必填字段，显然，包括用户名和通过单击bottom.|97872|Return+back+to+terminal的"Go“按钮并享受它。:)|97873|97874|entityMap^0|0|0|3|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|13|8|@]|9|@]|A|$]]|$1|L|3|M|5|K|7|14|8|@]|9|@]|A|$]]|$1|N|3|O|5|K|7|15|8|@]|9|@]|A|$]]|$1|P|3|Q|5|K|7|16|8|@]|9|@]|A|$]]|$1|R|3|S|5|K|7|17|8|@]|9|@]|A|$]]|$1|T|3|U|5|K|7|18|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|X|$]]

<h3>phpMyAdmin GUI way</h3>
Note: This method may not work if you have the problem with root user account.
<ol>
<li>Login to phpMyAdmin as root.</li>
<li>Switch to &quot;User Accounts&quot; tab.</li>
<li>Select the username you get error with.</li>
<li>From the top buttons, switch to &quot;Login Information&quot; section.</li>
<li>In &quot;Login Information&quot; box, change &quot;Authentication plugin&quot; from &quot;Caching sha2 authentication&quot; to &quot;Native MySQL authentication&quot;. Also, you must fill in other required fields, obviously, including username and password.</li>
<li>Save it by clicking on the &quot;Go&quot; button at the bottom.</li>
<li>Return back to terminal and enjoy. :)</li>
</ol>

blocks|key|97876|text|在我的例子中，我使用了PHP+Symfony框架，这是一个愚蠢的错误。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|97877|paramers.yml中的数据库凭据错误。|97878|相应地更改凭据后，问题就解决了。|97879|entityMap^0|F|7|0|0|C|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|R|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|K|$]]

In my case, i'm using PHP <code>Symfony</code> framework and it's a silly mistake.
The database credential was wrong in <code>paramers.yml</code>.
After changing the credentials accordingly the problem was gone.

I am using php <code>mysqli_connect</code> for login to a MySQL database (all on localhost)

<pre><code>&lt;?php
//DEFINE ('DB_USER', 'user2');
//DEFINE ('DB_PASSWORD', 'pass2');
DEFINE ('DB_USER', 'user1');
DEFINE ('DB_PASSWORD', 'pass1');
DEFINE ('DB_HOST', '127.0.0.1');
DEFINE ('DB_NAME', 'dbname');

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if(!$dbc){
 die('error connecting to database'); 
}
?&gt;
</code></pre>

this is the mysql.user table:
<a href="https://i.stack.imgur.com/fyMXv.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/fyMXv.jpg" alt="mysql.user table"></a>

MySQL Server ini File:

<pre><code>[mysqld]
# The default authentication plugin to be used when connecting to the server
default_authentication_plugin=caching_sha2_password
#default_authentication_plugin=mysql_native_password
</code></pre>

with <code>caching_sha2_password</code> in the MySQL Server ini file, it's not possible at all to login with user1 or user2;

<blockquote>
 error: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in...
</blockquote>

with <code>mysql_native_password</code> in the MySQL Server ini file, it's possible to login with user1, but with user2, same error;

<hr>

how can I login using <code>caching_sha2_password</code> on the mySql Server?

php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

身份验证

SQL数据库

SQL Server

数据库

服务器

MariaDB

Windows

Ubuntu

MySQL

我使用php mysqli_connect登录到一个MySQL数据库(全部在本地主机上)<?php//DEFINE ('DB_USER', 'user2');//DEFINE ('DB_PASSWORD', 'pass2');DEFINE ('DB_USER', 'user1');DEFINE ('DB_PASSWOR...

问php mysqli_connect:客户端未知的身份验证方法[caching_sha2_password]
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问php mysqli_connect:客户端未知的身份验证方法[caching_sha2_password]EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问php mysqli_connect:客户端未知的身份验证方法[caching_sha2_password]
EN