blocks|key|21359|text|新的MySQL+8.0.11使用caching_sha2_password作为默认身份验证方法。我认为phpMyAdmin无法理解这种身份验证方法。您需要使用一种较旧的身份验证方法创建用户，例如CREATE+USER+xyz@localhost+IDENTIFIED+WITH+mysql_native_password+BY+'passw0rd'。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|21360|更多信息在这里https://dev.mysql.com/doc/refman/8.0/en/create-user.html和这里https://dev.mysql.com/doc/refman/8.0/en/authentication-plugins.html|21361|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/create-user.html|1|https://dev.mysql.com/doc/refman/8.0/en/authentication-plugins.html^0|G|L|2P|25|0|7|1K|0|1U|1V|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@]|D|@$9|X|A|Y|1|Z]|$9|10|A|11|1|12]]|E|$]]|$1|H|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]|P|$5|K|L|M|E|$N|Q]]]]

New MySQL 8.0.11 is using <code>caching_sha2_password</code> as default authentication method. I think that phpMyAdmin cannot understand this authentication method.
You need to create user with one of the older authentication method, e.g. <code>CREATE USER xyz@localhost IDENTIFIED WITH mysql_native_password BY 'passw0rd'</code>.

More here <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> and here <a href="https://dev.mysql.com/doc/refman/8.0/en/authentication-plugins.html" rel="noreferrer">https://dev.mysql.com/doc/refman/8.0/en/authentication-plugins.html</a>

blocks|key|2684759|text|另一个想法是:只要phpmyadmin和其他php工具不能使用它，就将这一行添加到您的文件/etc/mysql/my.cnf中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2684760|default_authentication_plugin+=+mysql_native_password|code-block|syntax|javascript|2684761|另请参阅：Mysql+Ref|offset|length|2684762|我知道这是一个安全问题，但是如果这些工具不能与caching_sha2_password一起工作怎么办？|2684763|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin^0|0|0|5|9|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@$I|X|J|Y|1|Z]]|A|$]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

Another idea: as long as the phpmyadmin and other php tools don't work with it, just add this line to your file /etc/mysql/my.cnf 

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

See also:
<a href="https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin" rel="noreferrer">Mysql Ref</a>

I know that this is a security issue, but what to do if the tools don't work with caching_sha2_password?

blocks|key|22799|text|正如@kgr提到的，MySQL+8.0.11对身份验证方法进行了一些更改。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|22800|我打开了一个关于这个的phpMyAdmin错误报告：https://github.com/phpmyadmin/phpmyadmin/issues/14220。|offset|length|22801|MySQL+8.0.4-rc对我来说工作得很好，我认为MySQL在补丁级别的发布中做出这样的改变是荒谬的。|22802|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/phpmyadmin/phpmyadmin/issues/14220^0|0|Q|1H|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

As @kgr mentioned, MySQL 8.0.11 made some changes to the authentication method.

I've opened a phpMyAdmin bug report about this: <a href="https://github.com/phpmyadmin/phpmyadmin/issues/14220" rel="nofollow noreferrer">https://github.com/phpmyadmin/phpmyadmin/issues/14220</a>.

MySQL 8.0.4-rc was working fine for me, and I kind of think it's ridiculous for MySQL to make such a change in a patch level release.

blocks|key|2474687|text|我通过执行以下操作解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2474688|2474689|将default_authentication_plugin+=+mysql_native_password添加到|ordered-list-item|offset|length|style|CODE|2474690|2474691|My.cnf|2474692|的mysqld部分进入mysql，并根据需要执行诸如CREATE+USER+'root'@'localhost'+IDENTIFIED+BY+'password';|unordered-list-item|2474693|
|2474694|Grant权限之类的操作来创建一个新用户。例如，使用新用户|2474695|
进入GRANT+ALL+PRIVILEGES+ON+*+.+*+TO+'root'@'localhost';，然后进入phpmyadmin|2474696|entityMap^0|0|0|1|1H|0|0|0|Q|1K|0|0|0|3|1G|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|Z|8|@$F|10|G|11|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|13|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|14|8|@$F|15|G|16|H|I]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|17|8|@]|9|@]|A|$]]|$1|R|3|S|5|O|7|18|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|19|8|@$F|1A|G|1B|H|I]]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|W|$]]

I solved this issue by doing the following:

<ol>
<li>Add <code>default_authentication_plugin = mysql_native_password</code> to the 
[mysqld] section of my.cnf</li>
<li>Enter mysql and create a new user by doing something like <code>CREATE USER
'root'@'localhost' IDENTIFIED BY 'password';</code></li>
<li>Grant privileges as necessary. E.g. <code>GRANT ALL PRIVILEGES ON * . * TO
'root'@'localhost';</code> and then <code>FLUSH PRIVILEGES;</code></li>
<li>Login into phpmyadmin with new user</li>
</ol>

blocks|key|22849|text|我通过执行以下操作解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|22850|22851|进入系统偏好设置->+mysql|ordered-list-item|22852|选择“初始化数据库”，然后输入一个新的根密码，选择"Use+Legacy+password+Encryption".|22853|Login+to+phpmyadmin.|22854|+with+the+new+password.|22855|22856|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|P|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|R|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|S|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|T|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

I solved this issue by doing following:

<ol>
<li>Enter to system preferences -> mysql</li>
<li>Select "Initialize database" and enter a new root password selecting "Use Legacy Password Encryption".</li>
<li>Login into phpmyadmin with the new password.</li>
</ol>

blocks|key|2474782|text|以根用户身份登录到MySQL控制台：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2474783|root@9532f0da1a2a:/#+mysql+-u+root+-pPASSWORD|code-block|syntax|javascript|2474784|并使用此处的密码更改身份验证插件：|2474785|mysql>+ALTER+USER+root+IDENTIFIED+WITH+mysql_native_password+BY+'PASSWORD';
Query+OK,+0+rows+affected+(0.08+sec)|2474786|有关首选身份验证插件的详细信息，请参阅《MySQL+8.0参考手册》|2474787|https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password|2474788|它在docker化环境中运行良好：|2474789|docker+run+--name+mysql+-e+MYSQL_ROOT_PASSWORD=PASSWORD+-p+3306:3306+-d+mysql:latest

docker+exec+-it+mysql+bash

mysql+-u+root+-pPASSWORD

ALTER+USER+root+IDENTIFIED+WITH+mysql_native_password+BY+'PASSWORD';

exit

exit

docker+run+--name+phpmyadmin+-d+--link+mysql:db+-p+8080:80+phpmyadmin/phpmyadmin:latest|2474790|因此您现在可以使用超级用户/密码登录到http://localhost:8080上的phpMyAdmin|2474791|2474792|mysql/mysql-server|2474793|如果您使用的是mysql/mysql-server+docker镜像|2474794|但请记住，在开发环境中，它只是一个“又快又脏”的解决方案。更改是不明智的。|2474795|docker+run+--name+mysql+-e+MYSQL_ROOT_PASSWORD=PASSWORD+-e+MYSQL_ROOT_HOST=%25+-p+3306:3306+-d+mysql/mysql-server:latest
docker+exec+-it+mysql+mysql+-u+root+-pPASSWORD+-e+"ALTER+USER+root+IDENTIFIED+WITH+mysql_native_password+BY+'PASSWORD';"
docker+run+--name+phpmyadmin+-d+--link+mysql:db+-p+8080:80+phpmyadmin/phpmyadmin:latest|2474796|2018年10月4日的更新解决方案|2474797|通过取消注释MySQL中的default_authentication_plugin=mysql_native_password设置来更改/etc/my.cnf默认身份验证插件|CODE|2474798|使用风险自负|2474799|docker+run+--name+mysql+-e+MYSQL_ROOT_PASSWORD=PASSWORD+-e+MYSQL_ROOT_HOST=%25+-p+3306:3306+-d+mysql/mysql-server:latest
docker+exec+-it+mysql+sed+-i+-e+'s/#+default-authentication-plugin=mysql_native_password/default-authentication-plugin=mysql_native_password/g'+/etc/my.cnf
docker+stop+mysql;+docker+start+mysql
docker+run+--name+phpmyadmin+-d+--link+mysql:db+-p+8080:80+phpmyadmin/phpmyadmin:latest|2474800|2019年1月30日更新的解决方法|2474801|docker+run+--name+mysql+-e+MYSQL_ROOT_PASSWORD=PASSWORD+-e+MYSQL_ROOT_HOST=%25+-p+3306:3306+-d+mysql/mysql-server:latest
docker+exec+-it+mysql+sed+-i+-e+'s/#+default-authentication-plugin=mysql_native_password/default-authentication-plugin=mysql_native_password/g'+/etc/my.cnf
docker+exec+-it+mysql+mysql+-u+root+-pPASSWORD+-e+"ALTER+USER+root+IDENTIFIED+WITH+mysql_native_password+BY+'PASSWORD';"
docker+stop+mysql;+docker+start+mysql
docker+run+--name+phpmyadmin+-d+--link+mysql:db+-p+8080:80+phpmyadmin/phpmyadmin:latest|2474802|default_authentication_plugin|2474803|2021年9月13日上的更新解决方案|2474804|ALTER+USER+'root'@'localhost‘通过’mysql_native_password‘标识为密码；|2474805|2474806|完全带引号*|unordered-list-item|2474807|2474808|entityMap|0|LINK|mutability|MUTABLE|url|1|http://localhost:8080/|2|https://hub.docker.com/r/mysql/mysql-server/|3|https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin^0|1|1|0|0|0|0|0|0|2X|0|0|2|6|0|0|J|L|1|0|0|0|I|0|7|I|2|0|0|0|B|6|0|0|2G|D|1F|1X|B|0|0|6|0|0|0|A|D|4|0|0|0|T|0|T|3|0|0|A|C|6|0|0|1O|0|0|0|6|0|0^^$0|@$1|2|3|4|5|6|7|28|8|@$9|29|A|2A|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|2B|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|2C|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|2D|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|2E|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|2F|8|@]|D|@$9|2G|A|2H|1|2I]]|E|$]]|$1|S|3|T|5|6|7|2J|8|@$9|2K|A|2L|B|C]]|D|@]|E|$]]|$1|U|3|V|5|H|7|2M|8|@]|D|@]|E|$I|J]]|$1|W|3|X|5|6|7|2N|8|@]|D|@$9|2O|A|2P|1|2Q]]|E|$]]|$1|Y|3|-4|5|6|7|2R|8|@]|D|@]|E|$]]|$1|Z|3|10|5|6|7|2S|8|@$9|2T|A|2U|B|C]]|D|@]|E|$]]|$1|11|3|12|5|6|7|2V|8|@]|D|@$9|2W|A|2X|1|2Y]]|E|$]]|$1|13|3|14|5|6|7|2Z|8|@]|D|@]|E|$]]|$1|15|3|16|5|H|7|30|8|@]|D|@]|E|$I|J]]|$1|17|3|18|5|6|7|31|8|@$9|32|A|33|B|C]]|D|@]|E|$]]|$1|19|3|1A|5|6|7|34|8|@$9|35|A|36|B|C]|$9|37|A|38|B|1B]|$9|39|A|3A|B|1B]]|D|@]|E|$]]|$1|1C|3|1D|5|6|7|3B|8|@$9|3C|A|3D|B|C]]|D|@]|E|$]]|$1|1E|3|1F|5|H|7|3E|8|@]|D|@]|E|$I|J]]|$1|1G|3|1H|5|6|7|3F|8|@$9|3G|A|3H|B|C]|$9|3I|A|3J|B|C]]|D|@]|E|$]]|$1|1I|3|1J|5|H|7|3K|8|@]|D|@]|E|$I|J]]|$1|1K|3|1L|5|6|7|3L|8|@$9|3M|A|3N|B|C]]|D|@$9|3O|A|3P|1|3Q]]|E|$]]|$1|1M|3|1N|5|6|7|3R|8|@$9|3S|A|3T|B|C]|$9|3U|A|3V|B|C]]|D|@]|E|$]]|$1|1O|3|1P|5|6|7|3W|8|@$9|3X|A|3Y|B|C]]|D|@]|E|$]]|$1|1Q|3|-4|5|6|7|3Z|8|@]|D|@]|E|$]]|$1|1R|3|1S|5|1T|7|40|8|@$9|41|A|42|B|C]]|D|@]|E|$]]|$1|1U|3|-4|5|6|7|43|8|@]|D|@]|E|$]]|$1|1V|3|-4|5|6|7|44|8|@]|D|@]|E|$]]]|1W|$1X|$5|1Y|1Z|20|E|$21|R]]|22|$5|1Y|1Z|20|E|$21|23]]|24|$5|1Y|1Z|20|E|$21|25]]|26|$5|1Y|1Z|20|E|$21|27]]]]

Log in to MySQL console with root user:
<pre><code>root@9532f0da1a2a:/# mysql -u root -pPASSWORD
</code></pre>
and change the Authentication Plugin with the password there:
<pre><code>mysql&gt; ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
Query OK, 0 rows affected (0.08 sec)
</code></pre>
You can read more info about the Preferred Authentication Plugin on the MySQL 8.0 Reference Manual
<a href="https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password</a>
It is working perfectly in a dockerized environment:
<pre><code>docker run --name mysql -e MYSQL_ROOT_PASSWORD=PASSWORD -p 3306:3306 -d mysql:latest

docker exec -it mysql bash

mysql -u root -pPASSWORD

ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD';

exit

exit

docker run --name phpmyadmin -d --link mysql:db -p 8080:80 phpmyadmin/phpmyadmin:latest
</code></pre>
So you can now log in to phpMyAdmin on http://localhost:8080 with root / PASSWORD
<hr />
mysql/mysql-server
If you are using <a href="https://hub.docker.com/r/mysql/mysql-server/" rel="nofollow noreferrer" title="mysql/mysql-server">mysql/mysql-server</a> docker image
But remember, it is just a 'quick and dirty' solution in the development environment. It is not wise to change the <a href="https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password" rel="nofollow noreferrer">MySQL Preferred Authentication Plugin</a>.
<pre><code>docker run --name mysql -e MYSQL_ROOT_PASSWORD=PASSWORD -e MYSQL_ROOT_HOST=% -p 3306:3306 -d mysql/mysql-server:latest
docker exec -it mysql mysql -u root -pPASSWORD -e &quot;ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD';&quot;
docker run --name phpmyadmin -d --link mysql:db -p 8080:80 phpmyadmin/phpmyadmin:latest
</code></pre>
Updated solution at 10/04/2018
Change the MySQL default authentication plugin by uncommenting the <code>default_authentication_plugin=mysql_native_password</code> setting in <code>/etc/my.cnf</code>
use at your own risk
<pre><code>docker run --name mysql -e MYSQL_ROOT_PASSWORD=PASSWORD -e MYSQL_ROOT_HOST=% -p 3306:3306 -d mysql/mysql-server:latest
docker exec -it mysql sed -i -e 's/# default-authentication-plugin=mysql_native_password/default-authentication-plugin=mysql_native_password/g' /etc/my.cnf
docker stop mysql; docker start mysql
docker run --name phpmyadmin -d --link mysql:db -p 8080:80 phpmyadmin/phpmyadmin:latest
</code></pre>
Updated workaround at 01/30/2019
<pre><code>docker run --name mysql -e MYSQL_ROOT_PASSWORD=PASSWORD -e MYSQL_ROOT_HOST=% -p 3306:3306 -d mysql/mysql-server:latest
docker exec -it mysql sed -i -e 's/# default-authentication-plugin=mysql_native_password/default-authentication-plugin=mysql_native_password/g' /etc/my.cnf
docker exec -it mysql mysql -u root -pPASSWORD -e &quot;ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD';&quot;
docker stop mysql; docker start mysql
docker run --name phpmyadmin -d --link mysql:db -p 8080:80 phpmyadmin/phpmyadmin:latest
</code></pre>
<a href="https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin" rel="nofollow noreferrer">default_authentication_plugin</a>
Updated solution at 09/13/2021
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
<ul>
<li>exactly with quotes *</li>
</ul>

blocks|key|21456|text|正如许多人在其他答案中指出的那样，changing+the+default+authentication+plugin+of+MySQL+to+native做到了这一点。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|21457|尽管如此，由于我不能使用新的caching_sha2_password插件，我将等到兼容性开发完成后再结束这个话题。|21458|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.6/en/authentication-plugins.html^0|H|1P|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

As many pointed out in other answers, <a href="https://dev.mysql.com/doc/refman/5.6/en/authentication-plugins.html" rel="nofollow noreferrer">changing the default authentication plugin of MySQL to native</a> does the trick.

Still, since I can't use the new caching_sha2_password plugin, I'll wait until compatibility is developed to close the topic.

blocks|key|2474852|text|我用MySQL+8.0.12通过运行以下命令解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2474853|mysql_upgrade+-u+root|code-block|syntax|javascript|2474854|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 solved this with MySQL 8.0.12 by running:

<pre><code>mysql_upgrade -u root
</code></pre>

blocks|key|21470|text|如果您使用的是官方的mysql+docker容器，有一个简单的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|21471|将以下行添加到您的docker-compose服务：|21472|command:+--default-authentication-plugin=mysql_native_password|code-block|syntax|javascript|21473|示例配置：|21474|mysql:
+++++image:+mysql:8
+++++networks:
+++++++-+net_internal
+++++volumes:
+++++++-+mysql_data:/var/lib/mysql
+++++environment:
+++++++-+MYSQL_ROOT_PASSWORD=root
+++++++-+MYSQL_DATABASE=db
+++++command:+--default-authentication-plugin=mysql_native_password|21475|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

If you are using the official mysql docker container, there is a simple solution:

Add the following line to your docker-compose service:

<pre><code>command: --default-authentication-plugin=mysql_native_password
</code></pre>

Example configuration:

<pre><code>mysql:
 image: mysql:8
 networks:
 - net_internal
 volumes:
 - mysql_data:/var/lib/mysql
 environment:
 - MYSQL_ROOT_PASSWORD=root
 - MYSQL_DATABASE=db
 command: --default-authentication-plugin=mysql_native_password
</code></pre>

blocks|key|2685106|text|要解决此问题，我只需在mysql控制台中运行一次查询。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2685107|对于使用以下命令登录到mysql控制台的操作|2685108|mysql+-u+{username}+-p{password}|code-block|syntax|javascript|2685109|在此之后，我只运行一个查询，如下所示：|2685110|ALTER+user+'{USERNAME}'@'localhost'+identified+with+mysql_native_password+by+'{PASSWORD}';|2685111|当我运行这个查询时，我得到了查询已执行的消息。然后使用用户名/密码登录PHPMYADMIN。|2685112|entityMap^0|B|5|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|11|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|T|$]]

To fix this issue I just run one query in my <code>mysql</code> console. 

For this login to mysql console using this

<pre><code>mysql -u {username} -p{password}
</code></pre>

After this I just run one query as given below:-

<pre><code>ALTER user '{USERNAME}'@'localhost' identified with mysql_native_password by '{PASSWORD}';
</code></pre>

when I run this query I got message that query executed. Then login to PHPMYADMIN with username/password.

blocks|key|21498|text|我基本上用András的答案解决了我的问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|21499|1-以根用户身份登录到MySQL控制台：|21500|root@9532f0da1a2a:/#+mysql+-u+root+-pPASSWORD|code-block|syntax|javascript|21501|然后键入root的密码进行auth。|21502|2-我创建了一个新用户：|21503|mysql>+CREATE+USER+'user'@'hostname'+IDENTIFIED+BY+'password';|21504|3-将所有权限授予新用户：|21505|mysql>+GRANT+ALL+PRIVILEGES+ON+*.*+To+'user'@'hostname';|21506|4-使用密码更改身份验证插件：|21507|mysql>+ALTER+USER+user+IDENTIFIED+WITH+mysql_native_password+BY+'PASSWORD';|21508|现在，phpmyadmin可以很好地记录新用户。|21509|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|15|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|16|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|17|8|@]|9|@]|A|$G|H]]|$1|S|3|T|5|6|7|18|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|19|8|@]|9|@]|A|$G|H]]|$1|W|3|X|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|Z|$]]

I solved my problem basically with András answer:

1- Log in to MySQL console with root user:

<pre><code>root@9532f0da1a2a:/# mysql -u root -pPASSWORD
</code></pre>

And type the root's password to auth.

2- I created a new user:

<pre><code>mysql&gt; CREATE USER 'user'@'hostname' IDENTIFIED BY 'password';
</code></pre>

3- Grant all privileges to the new user:

<pre><code>mysql&gt; GRANT ALL PRIVILEGES ON *.* To 'user'@'hostname';
</code></pre>

4- Change the Authentication Plugin with the password:

<pre><code>mysql&gt; ALTER USER user IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
</code></pre>

Now, phpmyadmin works fine logging the new user.

blocks|key|23000|text|我遇到了这个问题，在Windows中找不到任何ini文件，但对我有效的解决方案非常简单。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|23001|打开mysql+installer.|23002|Reconfigure+mysql+|unordered-list-item|23003|
|23004|，它是第一个链接。|23005|23006|转到身份验证方法。|23007|23008|选择'Legacy+authentication'.|23009|23010|Give+|23011|23012|(next+authentication‘.|23013|23014|Give|23015|23016|)。|23017|23018|23019|23020|就是这样，希望我的解决方案也能很好地为你工作！|23021|entityMap^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|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1B|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|1D|8|@]|9|@]|A|$]]|$1|K|3|H|5|6|7|1E|8|@]|9|@]|A|$]]|$1|L|3|M|5|F|7|1F|8|@]|9|@]|A|$]]|$1|N|3|H|5|6|7|1G|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|H|5|6|7|1I|8|@]|9|@]|A|$]]|$1|R|3|S|5|F|7|1J|8|@]|9|@]|A|$]]|$1|T|3|H|5|6|7|1K|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|1L|8|@]|9|@]|A|$]]|$1|W|3|H|5|6|7|1M|8|@]|9|@]|A|$]]|$1|X|3|Y|5|F|7|1N|8|@]|9|@]|A|$]]|$1|Z|3|H|5|6|7|1O|8|@]|9|@]|A|$]]|$1|10|3|11|5|F|7|1P|8|@]|9|@]|A|$]]|$1|12|3|H|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|13|3|-4|5|F|7|1R|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|1T|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]]|18|$]]

I had this problem, did not find any ini file in Windows, but the solution that worked for me was very simple. 
1. Open the mysql installer. 
2. Reconfigure mysql server, it is the first link. 
3. Go to authentication method. 
4. Choose 'Legacy authentication'. 
5. Give your password(next field). 
6. Apply changes.

That's it, hope my solution works fine for you as well!

blocks|key|2475095|text|在我的例子中，为了解决这个问题，我更喜欢创建一个新用户来使用PhpMyAdmin，因为修改根用户已经导致了其他应用程序的本机登录问题，比如MySQL+WorkBench。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2475096|这是我所做的：|2475097|以根用户身份登录MySQL控制台：mysql+-u+root+-p，输入您的根用户在MySQL外壳中创建新用户：|offset|length|style|CODE|2475098|CREATE+USER+'newMySqlUsername'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'mysqlNewUsernamePassword';|code-block|syntax|javascript|2475099|2475100|此时，newMysqlUsername没有权限对数据库执行任何操作。以便为用户提供对所需信息的访问权限。|unordered-list-item|2475101|2475102|GRANT+ALL+PRIVILEGES+ON+*+.+*+TO+'+newMySqlUsername'@'localhost';|2475103|2475104|完成要为新用户设置的权限后，请始终确保重新加载所有权限。|2475105|2475106|FLUSH+PRIVILEGES;|2475107|2475108|通过键入quit或\q注销，您的更改现在将生效，我们可以使用新用户登录到PhpMyAdmin，它将拥有您可以在终端中使用以下命令重新登录的终端的访问权限：|2475109|2475110|mysql+-u+newMySqlUsername+-p|2475111|entityMap^0|0|0|H|G|0|0|0|3|G|0|0|0|0|0|0|0|0|4|4|9|2|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1B|8|@$F|1C|G|1D|H|I]]|9|@]|A|$]]|$1|J|3|K|5|L|7|1E|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1G|8|@$F|1H|G|1I|H|I]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|T|3|U|5|L|7|1K|8|@]|9|@]|A|$M|N]]|$1|V|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|W|3|X|5|R|7|1M|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|Z|3|10|5|L|7|1O|8|@]|9|@]|A|$M|N]]|$1|11|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|12|3|13|5|R|7|1Q|8|@$F|1R|G|1S|H|I]|$F|1T|G|1U|H|I]]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1V|8|@]|9|@]|A|$]]|$1|15|3|16|5|L|7|1W|8|@]|9|@]|A|$M|N]]|$1|17|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]]|18|$]]

in my case, to fix it I preferred to create a new user to use with PhpMyAdmin because modifying the root user has caused native login problems with other applications such as MySQL WorkBench.

This is what I did:

<ul>
<li>Log in to MySQL console with root user: <code>mysql -u root -p</code>, enter your password.</li>
<li>Let’s create a new user within the MySQL shell:</li>
</ul>

<pre><code>CREATE USER 'newMySqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlNewUsernamePassword';
</code></pre>

<ul>
<li>At this point the <code>newMysqlUsername</code> has no permissions to do anything with the databases. So is needed to provide the user with access to the information they will need.</li>
</ul>

<pre><code>GRANT ALL PRIVILEGES ON * . * TO ' newMySqlUsername'@'localhost';
</code></pre>

<ul>
<li>Once you have finalized the permissions that you want to set up for your new users, always be sure to reload all the privileges.</li>
</ul>

<pre><code>FLUSH PRIVILEGES;
</code></pre>

<ul>
<li>Log out by typing <code>quit</code> or <code>\q</code>, and your changes will now be in effect, we can log in into PhpMyAdmin with the new user and it will have access to the databases.</li>
<li>Also you can log back in with this command in terminal:</li>
</ul>

<pre><code>mysql -u newMySqlUsername -p
</code></pre>

blocks|key|2685308|text|我用了ALTER+USER+root@localhost+IDENTIFIED+WITH+mysql_native_password+BY+'PASSWORD';，它起作用了|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2685309|entityMap^0|3|26|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 used <code>ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY 'PASSWORD';</code> it worked

blocks|key|2685311|text|+mysql>+ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'rootpassword';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2685312|通过命令行登录，之后就可以工作了。|unstyled|2685313|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> mysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'rootpassword';
</code></pre>

Login through the command line, it will work after that.

blocks|key|2475166|text|如果您在Windows上运行，则可以通过运行msi重新配置安装来更改身份验证。它将要求将默认身份验证更改为传统身份验证，然后您可以继续使用该选项将身份验证更改为传统身份验证。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2475167|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can change the Authentication if u are running on Windows by reconfiguring the installation by running the msi. It will ask for changing the default authentication to legacy, then u can proceed with that option to change the authentication to the legacy one.

blocks|key|2475169|text|使用mysql_native_password选项创建另一个用户：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2475170|在终端中：|2475171|mysql>+CREATE+USER+'su'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'123';
mysql>+GRANT+ALL+PRIVILEGES+ON+*+.+*+TO+'su'@'localhost';
mysql>+FLUSH+PRIVILEGES;|code-block|syntax|javascript|2475172|entityMap^0|2|L|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

Create another user with <code>mysql_native_password</code> option:

In terminal:

<pre><code>mysql&gt; CREATE USER 'su'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
mysql&gt; GRANT ALL PRIVILEGES ON * . * TO 'su'@'localhost';
mysql&gt; FLUSH PRIVILEGES;
</code></pre>

UPDATE 
Newer versions of phpMyAdmin solved this issue. I've successfully tested with phpMyAdmin 5.0.1

<hr>

I have installed the MySQL 8.0 server and phpMyAdmin, but when I try to access it from the browser the following errors occur:

<pre><code>#2054 - The server requested authentication method unknown to the client
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client
</code></pre>

I imagine it must have something to do with the strong passwords implemented and the relative freshness of the MySQL release.

But I know nothing of the most advanced driver and connection configuration.

Has someone faced the same problem and solved it? :D

phpMyAdmin on MySQL 8.0

身份验证

数据库

服务器

Windows

容器

Docker

MySQL

更新较新版本的phpMyAdmin解决了这个问题。我已经成功地使用phpMyAdmin 5.0.1进行了测试我已经安装了MySQL 8.0服务器和phpMyAdmin，但当我尝试从浏览器访问它时，出现以下错误：#2054 - The server requested authentication method unkn...

问MySQL 8.0上的phpMyAdmin
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL 8.0上的phpMyAdminEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL 8.0上的phpMyAdmin
EN