blocks|key|2843535|text|您可以使用以下Alter命令更改用户的密码加密：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2843536|2843537|+ALTER+USER+'username'@'ip_address‘通过’mysql_native_password‘标识为密码；|blockquote|2843538|2843539|2843540|或|offset|length|style|BOLD|2843541|我们可以通过让它与旧密码插件一起工作来避免这个错误：|2843542|首先将my.cnf文件中的身份验证插件更改为Windows中的Linux+/+my.ini文件|2843543|2843544|+mysqld|2843545|2843546|default_authentication_plugin=mysql_native_password|2843547|2843548|重新启动mysql服务器以使更改生效，并尝试通过MySQL与任何mysql客户端连接。|2843549|如果仍然无法连接，则会出现以下错误：|2843550|Unable+to+load+plugin+'caching_sha2_password'|code-block|syntax|javascript|2843551|这意味着你的用户需要上面的插件。因此，在更改默认插件后，尝试使用create+user或grant命令创建新用户。然后，新用户需要本地插件，您将能够连接MySQL。|2843552|谢谢|2843553|entityMap^0|0|0|0|0|0|0|1|0|0|3|Q|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1F|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1I|8|@$J|1J|K|1K|L|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|1L|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1M|8|@$J|1N|K|1O|L|M]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|S|3|T|5|E|7|1Q|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1S|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1U|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1V|8|@]|9|@]|A|$]]|$1|12|3|13|5|14|7|1W|8|@]|9|@]|A|$15|16]]|$1|17|3|18|5|6|7|1X|8|@]|9|@]|A|$]]|$1|19|3|1A|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|1B|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]]|1C|$]]

You can change the encryption of the user's password by altering the user with below Alter command :

<blockquote>
 ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY
 'password';
</blockquote>

OR

We can avoid this error by make it work with old password plugin:

First change the authentication plugin in my.cnf file for Linux / my.ini file in Windows:

<blockquote>
 [mysqld] 
 
 default_authentication_plugin=mysql_native_password
</blockquote>

Restart the mysql server to take the changes in affect and try connecting via MySQL with any mysql client.

If still unable to connect and getting the below error:

<pre><code>Unable to load plugin 'caching_sha2_password'
</code></pre>

It means your user needs the above plugin. So try creating new user with create user or grant command after changing default plugin. then new user need the native plugin and you will able to connect MySQL.

Thanks

blocks|key|2632114|text|您可以像这样更改密码的加密。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2632115|ALTER+USER+'yourusername'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'youpassword';|code-block|syntax|javascript|2632116|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|$]]

you can change the encryption of the password like this.

<pre><code>ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';
</code></pre>

blocks|key|100849|text|注意:对于MAC+OS|type|unstyled|depth|inlineStyleRanges|entityRanges|data|100850|在系统首选项>初始化数据库>服务器工作台中，再次键入您的新password.|100851|Choose+'Use+legacy+password'|unordered-list-item|100852|
|100853|Start+|100854|+MySQL。|ordered-list-item|100855|现在连接到|100856|+MySQL+|100857|100858|100859|​|100860|📷|atomic|offset|length|100861|100862|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/b4c57fc548b6e05d82bd4d715ccac1ef.jpeg|imageAlt^0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1C|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1D|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|1E|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1F|8|@]|9|@]|A|$]]|$1|N|3|O|5|M|7|1G|8|@]|9|@]|A|$]]|$1|P|3|Q|5|M|7|1H|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1K|8|@]|9|@]|A|$]]|$1|V|3|W|5|X|7|1L|8|@]|9|@$Y|1M|Z|1N|1|1O]]|A|$]]|$1|10|3|U|5|6|7|1P|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|12|$13|$5|14|15|16|A|$17|18|19|-4]]]]

Note: For MAC OS

<ol>
<li>Open MySQL from System Preferences > Initialize Database ></li>
<li>Type your new password.</li>
<li>Choose 'Use legacy password'</li>
<li>Start the Server again.</li>
<li>Now connect the MySQL Workbench</li>
</ol>

<img src="https://i.stack.imgur.com/qGdmc.jpg" alt="Image description">

blocks|key|98524|text|Windows10的：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|98525|打开命令提示符：|98526|cd+"C:\Program+Files\MySQL\MySQL+Server+8.0\bin"

C:\Program+Files\MySQL\MySQL+Server+8.0\bin>+mysql+-u+root+-p
Enter+password:+*********

mysql>+ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'newrootpassword';
Query+OK,+0+rows+affected+(0.10+sec)

mysql>+exit|code-block|syntax|javascript|98527|或者，您可以按如下方式更改my.ini配置：|98528|[mysqld]

default_authentication_plugin=mysql_native_password|98529|重新启动MySQL服务器并再次打开工作台。|98530|entityMap^0|A|1|0|0|0|D|6|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|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|O|3|P|5|J|7|12|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|13|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|T|$]]

For Windows 10:

Open the command prompt:

<pre><code>cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"

C:\Program Files\MySQL\MySQL Server 8.0\bin&gt; mysql -u root -p
Enter password: *********

mysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newrootpassword';
Query OK, 0 rows affected (0.10 sec)

mysql&gt; exit
</code></pre>

Alternatively, you can change the my.ini configuration as the following:

<pre><code>[mysqld]

default_authentication_plugin=mysql_native_password
</code></pre>

Restart the MySQL Server and open the Workbench again.

blocks|key|2632446|text|我也有同样的问题，但是Aman+Aggarwal的回答对运行MySQL8.x的Docker容器不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2632447|docker+exec+-it+CONTAINER_ID+bash|code-block|syntax|javascript|2632448|然后以root用户身份登录mysql|2632449|mysql+--user=root+--password|2632450|输入root用户的密码(默认为'root')，最后运行：|2632451|ALTER+USER+'username'+IDENTIFIED+WITH+mysql_native_password+BY+'password';|2632452|你已经准备好了。|2632453|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|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I had the same problem, but the answer by Aman Aggarwal didn't work for me with a Docker container running mysql 8.X. 
I loged in the container

<pre><code>docker exec -it CONTAINER_ID bash
</code></pre>

then log into mysql as root

<pre><code>mysql --user=root --password
</code></pre>

Enter the password for root (Default is 'root')
Finally Run:

<pre><code>ALTER USER 'username' IDENTIFIED WITH mysql_native_password BY 'password';
</code></pre>

You're all set.

blocks|key|2632217|text|目前(+2018/04/23)，您需要下载开发版本。GA不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2632218|我无法连接到最新的GA版本(6.3.10)。|2632219|它与mysql-workbench-community-8.0.11-rc-winx64.msi+(来自https://dev.mysql.com/downloads/workbench/的选项卡开发版本)协同工作。|offset|length|style|CODE|BOLD|2632220|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/downloads/workbench/^0|0|0|2|1A|2Q|4|1G|16|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|6|7|U|8|@$F|V|G|W|H|I]|$F|X|G|Y|H|J]]|9|@$F|Z|G|10|1|11]]|A|$]]|$1|K|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Currently (on 2018/04/23), you need to download a development release. The GA ones do not work.

I was not able to connect with the latest GA version (6.3.10).

It worked with <code>mysql-workbench-community-8.0.11-rc-winx64.msi</code> (from <a href="https://dev.mysql.com/downloads/workbench/" rel="noreferrer">https://dev.mysql.com/downloads/workbench/</a>, tab Development Releases).

blocks|key|98799|text|好了，在这上面浪费了很多时间，所以这是截至2019年3月19日的摘要|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|98800|如果您专门尝试在MySql+8%2B中使用Docker镜像，然后使用SequelPro访问在该docker容器上运行的数据库，那么您就不走运了。|98801|请参阅sequelpro+issue+2699|98802|我的设置是sequelpro+1.1.2，使用docker桌面2.0.3.0+(mac+-+mojave)，并尝试使用mysql:latest+(v8.0.15)。|98803|正如其他人所报告的，使用MySQL5.7不需要任何东西就可以工作：|98804|docker+run+-p+3306:3306+--name+mysql1+-e+MYSQL_ROOT_PASSWORD=secret+-d+mysql:5.7|code-block|syntax|javascript|98805|当然，在docker上使用MySql+8%2B也是可能的，在这种情况下(如果需要)，这里为caching_sha2_password类型问题提供的其他答案也是有效的。但是sequelpro对MySql+8%2B来说是行不通的|CODE|98806|最后，我放弃了sequelpro+(2013-2014年的一个值得信赖的朋友)，转而安装了DBeaver。一切都开箱即用。对于docker，我使用：|98807|docker+run+-p+3306:3306+--name+mysql1+-e+MYSQL_ROOT_PASSWORD=secret+-d+mysql:latest+--default-authentication-plugin=mysql_native_password|98808|您可以使用以下命令快速浏览mysql数据库：|98809|docker+exec+-it+mysql1+bash

mysql+-u+root+-p

show+databases;|98810|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/sequelpro/sequelpro/issues/2699|1|https://dbeaver.io/download/^0|W|2|0|8|8|W|9|0|3|K|0|0|0|0|0|17|L|0|19|7|1|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|@$9|1H|A|1I|B|C]|$9|1J|A|1K|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|1L|8|@]|D|@$9|1M|A|1N|1|1O]]|E|$]]|$1|J|3|K|5|6|7|1P|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|N|3|O|5|P|7|1R|8|@]|D|@]|E|$Q|R]]|$1|S|3|T|5|6|7|1S|8|@$9|1T|A|1U|B|U]]|D|@]|E|$]]|$1|V|3|W|5|6|7|1V|8|@]|D|@$9|1W|A|1X|1|1Y]]|E|$]]|$1|X|3|Y|5|P|7|1Z|8|@]|D|@]|E|$Q|R]]|$1|Z|3|10|5|6|7|20|8|@]|D|@]|E|$]]|$1|11|3|12|5|P|7|21|8|@]|D|@]|E|$Q|R]]|$1|13|3|-4|5|6|7|22|8|@]|D|@]|E|$]]]|14|$15|$5|16|17|18|E|$19|1A]]|1B|$5|16|17|18|E|$19|1C]]]]

Ok, wasted a lot of time on this so here is a summary as of 19 March 2019

If you are specifically trying to use a Docker image with MySql 8+, and then use SequelPro to access your database(s) running on that docker container, you are out of luck.

See the <a href="https://github.com/sequelpro/sequelpro/issues/2699" rel="noreferrer">sequelpro issue 2699</a>

My setup is sequelpro 1.1.2 using docker desktop 2.0.3.0 (mac - mojave), and tried using mysql:latest (v8.0.15).

As others have reported, using mysql 5.7 works with nothing required: 

<pre><code>docker run -p 3306:3306 --name mysql1 -e MYSQL_ROOT_PASSWORD=secret -d mysql:5.7
</code></pre>

Of course, it is possible to use MySql 8+ on docker, and in that situation (if needed), other answers provided here for <code>caching_sha2_password</code> type issues do work. But sequelpro is a NO GO with MySql 8+

Finally, I abandoned sequelpro (a trusted friend from back in 2013-2014) and instead installed <a href="https://dbeaver.io/download/" rel="noreferrer">DBeaver</a>. Everything worked out of the box. For docker, I used:

<pre><code>docker run -p 3306:3306 --name mysql1 -e MYSQL_ROOT_PASSWORD=secret -d mysql:latest --default-authentication-plugin=mysql_native_password
</code></pre>

You can quickly peek at the mysql databases using:

<pre><code>docker exec -it mysql1 bash

mysql -u root -p

show databases;
</code></pre>

blocks|key|2632612|text|我在我的Windows10+PC上使用"MySQL+Web+Installer“安装MySQL，在尝试使用MySQL工作台进行连接时也遇到了同样的问题。我通过从安装程序窗口重新配置服务器修复了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2632613|​|2632614|📷|atomic|2632615|2632616|单击“重新配置”选项将允许重新配置服务器。单击“下一步”，直到您到达“身份验证方法”。|2632617|2632618|2632619|2632620|在此选项卡上，使用第二个选项“使用旧身份验证方法(保留MySQL+5.x兼容性)”。|2632621|保持其他所有东西不变，这就是我解决问题的方法。|2632622|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/downloads/windows/installer/8.0.html|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/9bf19a59282e342fad85bb2db9fdacd6.png|imageAlt|2|https://ask.qcloudimg.com/http-save/yehe-900000/eb3acee3eb81cd818e9ceee4451f1140.png^0|K|J|0|0|0|0|1|1|0|0|0|0|0|1|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@$A|19|B|1A|1|1B]]|C|$]]|$1|D|3|E|5|6|7|1C|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|1D|8|@]|9|@$A|1E|B|1F|1|1G]]|C|$]]|$1|I|3|E|5|6|7|1H|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1I|8|@]|9|@]|C|$]]|$1|L|3|E|5|6|7|1J|8|@]|9|@]|C|$]]|$1|M|3|G|5|H|7|1K|8|@]|9|@$A|1L|B|1M|1|1N]]|C|$]]|$1|N|3|E|5|6|7|1O|8|@]|9|@]|C|$]]|$1|O|3|P|5|6|7|1P|8|@]|9|@]|C|$]]|$1|Q|3|R|5|6|7|1Q|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1R|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]|10|$5|11|W|12|C|$13|14|15|-4]]|16|$5|11|W|12|C|$13|17|15|-4]]]]

I was installing MySQL on my Windows 10 PC using "<a href="https://dev.mysql.com/downloads/windows/installer/8.0.html" rel="noreferrer">MySQL Web Installer</a>" and was facing the same issue while trying to connect using MySQL workbench. I fixed the issue by reconfiguring the server form the Installer window.

<a href="https://i.stack.imgur.com/USJtr.png" rel="noreferrer"><img src="https://i.stack.imgur.com/USJtr.png" alt="MySQL Web Installer - Home Screen"></a>

Clicking on the "Reconfigure" option it will allow to reconfigure the server. Click on "Next" until you reach "Authentication Method".

<a href="https://i.stack.imgur.com/m0E1M.png" rel="noreferrer"><img src="https://i.stack.imgur.com/m0E1M.png" alt="MySQL Installer - Authentication Method"></a>

Once on this tab, use the second option "Use Legacy Authentication Method (Retain MySQL 5.x Compatibility)". 

Keep everything else as is and that is how I solved my issue.

blocks|key|101317|text|注意:适用于Linux+(Debian、Ubuntu、Mint)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|101318|我得到了这个错误：|offset|length|style|BOLD|101319|MySQL+Error+Message:+Plugin+caching_sha2_password+could+not+be+loaded:+/usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so:+cannot+open+shared+object+file:+No+such+file+or+directory|code-block|syntax|javascript|101320|我用以下步骤解决了这个问题：|101321|在mysql控制台上输入|101322|：$+mysql+-u+root+-p，如果您没有根用户的密码，则输入：|ordered-list-item|CODE|101323|101324|使用mysql+db：mysql>+use+mysql;的|101325|101326|101327|更改您的用户以解决问题：mysql>+ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'password';，Alter|101328|101329|101330|101331|退出...mysql>+quit;|101332|101333|101334|Done!|101335|101336|entityMap^0|0|0|9|0|0|0|0|1|I|0|0|B|H|0|0|0|C|2H|0|0|0|0|5|C|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1E|8|@$D|1F|E|1G|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1H|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1I|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1J|8|@]|9|@]|A|$]]|$1|Q|3|R|5|S|7|1K|8|@$D|1L|E|1M|F|T]]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1O|8|@$D|1P|E|1Q|F|T]]|9|@]|A|$]]|$1|X|3|-4|5|S|7|1R|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1T|8|@$D|1U|E|1V|F|T]]|9|@]|A|$]]|$1|11|3|-4|5|S|7|1W|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|14|3|15|5|S|7|1Z|8|@$D|20|E|21|F|T]]|9|@]|A|$]]|$1|16|3|-4|5|6|7|22|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|23|8|@]|9|@]|A|$]]|$1|18|3|19|5|S|7|24|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|25|8|@]|9|@]|A|$]]|$1|1B|3|-4|5|6|7|26|8|@]|9|@]|A|$]]]|1C|$]]

Note: For Linux (Debian, Ubuntu, Mint)
I got this error:
<pre><code>MySQL Error Message: Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
</code></pre>
I solved it with these steps:
<ol>
<li>Enter on mysql console: <code>$ mysql -u root -p</code>, if you don't have a password for root user, then:
</li>
<li>Use mysql db: <code>mysql&gt; use mysql;</code>
</li>
<li>Alter your user for solve the problem: <code>mysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';</code>
</li>
<li>Exit... <code>mysql&gt; quit;</code>
</li>
<li>Done!
</li>
</ol>

blocks|key|2843588|text|是像这样吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2843589|docker+run+-p+3306:3306+-e+MYSQL_ALLOW_EMPTY_PASSWORD=yes+-d+mysql+--default-authentication-plugin=mysql_native_password
mysql+-uroot+--protocol+tcp|code-block|syntax|javascript|2843590|Try+in+PWD|offset|length|2843591|https://github.com/GitHub30/docs/blob/change-default_authentication_plugin/mysql/stack.yml|2843592|或者你应该使用MySQL工作台8.0.11。|2843593|entityMap|0|LINK|mutability|MUTABLE|url|https://labs.play-with-docker.com/?stack=https://raw.githubusercontent.com/GitHub30/docs/change-default_authentication_plugin/mysql/stack.yml|1^0|0|0|0|A|0|0|0|2I|1|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Z|8|@]|9|@$I|10|J|11|1|12]]|A|$]]|$1|K|3|L|5|6|7|13|8|@]|9|@$I|14|J|15|1|16]]|A|$]]|$1|M|3|N|5|6|7|17|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|L]]]]

like this?

<pre><code>docker run -p 3306:3306 -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d mysql --default-authentication-plugin=mysql_native_password
mysql -uroot --protocol tcp
</code></pre>

<a href="https://labs.play-with-docker.com/?stack=https://raw.githubusercontent.com/GitHub30/docs/change-default_authentication_plugin/mysql/stack.yml" rel="noreferrer">Try in PWD</a>

<a href="https://github.com/GitHub30/docs/blob/change-default_authentication_plugin/mysql/stack.yml" rel="noreferrer">https://github.com/GitHub30/docs/blob/change-default_authentication_plugin/mysql/stack.yml</a>

or You shoud use MySQL Workbench 8.0.11.

blocks|key|100999|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|101000|开放式MySQL命令行客户端|unordered-list-item|101001|使用新的pass|101002|创建新用户|101003|考虑到顶部bin文件夹的路径示例，以下是您需要在命令提示符中逐行运行的代码：|101004|cd+C:\Program+Files\MySQL\MySQL+Server+5.7\bin
MySQL+-u+root+-p++++
current+password...***++
CREATE+USER+'nativeuser'@'localhost'++
IDENTIFIED+WITH+mysql_native_password+BY+'new_password';|code-block|syntax|javascript|101005|101006|之后，您可以再次访问工作台(在创建新的本地主机连接并使用新的凭据开始使用该程序之后，您应该能够这样做)。|101007|101008|使用上面提到的用户名(本地用户)设置新的本地主机连接，使用密码(new_password)登录|101009|​|101010|📷|atomic|offset|length|101011|101012|礼貌:+Career365团队回答了UDEMY常见问题|101013|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/a88535e5ce6db4279a4e9dcbcc02403f.png|imageAlt^0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|1D|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|1E|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|1F|7|@]|8|@]|9|$]]|$1|F|3|G|4|5|6|1G|7|@]|8|@]|9|$]]|$1|H|3|I|4|5|6|1H|7|@]|8|@]|9|$]]|$1|J|3|K|4|L|6|1I|7|@]|8|@]|9|$M|N]]|$1|O|3|-4|4|5|6|1J|7|@]|8|@]|9|$]]|$1|P|3|Q|4|C|6|1K|7|@]|8|@]|9|$]]|$1|R|3|-4|4|5|6|1L|7|@]|8|@]|9|$]]|$1|S|3|T|4|5|6|1M|7|@]|8|@]|9|$]]|$1|U|3|V|4|5|6|1N|7|@]|8|@]|9|$]]|$1|W|3|X|4|Y|6|1O|7|@]|8|@$Z|1P|10|1Q|1|1R]]|9|$]]|$1|11|3|V|4|5|6|1S|7|@]|8|@]|9|$]]|$1|12|3|13|4|5|6|1T|7|@]|8|@]|9|$]]|$1|14|3|-4|4|5|6|1U|7|@]|8|@]|9|$]]]|15|$16|$4|17|18|19|9|$1A|1B|1C|-4]]]]

<ul>
<li>Open MySQL Command Line Client</li>
<li>Create a new user with a new pass</li>
</ul>

Considering an example of a path to a bin folder on top, here's the code you need to run in the command prompt, line by line:

<pre><code>cd C:\Program Files\MySQL\MySQL Server 5.7\bin
MySQL -u root -p 
current password...*** 
CREATE USER 'nativeuser'@'localhost' 
IDENTIFIED WITH mysql_native_password BY 'new_password';
</code></pre>

<ul>
<li>Then, you can access Workbench again (you should be able to do that after creating a new localhost connection and using the new credentials to start using the program). </li>
</ul>

Set up a new local host connection with the user name mentioned above (native user), login using the password (new_password)

<a href="https://i.stack.imgur.com/R5Ibi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/R5Ibi.png" alt="Image"></a>

Courtesy: UDEMY FAQs answered by Career365 Team

blocks|key|2632953|text|虽然这不应该是一个真正的解决方案，但如果您被卡住了，它确实可以在本地工作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2632954|ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'';|code-block|syntax|javascript|2632955|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|$]]

Although this shouldn't be a real
 solution, it does work locally if you are stuck

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

blocks|key|100886|text|用于Windows10的、|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|100887|100888|在C:\ProgramData\MySQL\MySQL+Server+8.0\中修改my.ini文件|ordered-list-item|CODE|100889|100890|mysqld+default_authentication_plugin=mysql_native_password|100891|Restart+MySQL服务。|unordered-list-item|100892|
|100893|在命令行上登录到MySQL，并在MySQL中执行以下命令：|100894|100895|-+Create+a+new+user.|code-block|syntax|javascript|100896|创建用户'+USER+'@'localhost‘，标识为'password'；|100897|-授予所有权限。|100898|将*+.*上的所有权限授予'user'@'localhost'；|100899|​|100900|100901|打开MySQL工作台，然后使用新用户credentials.|100902|打开一个新连接|100903|我也面临着同样的问题，而且这个方法奏效了。|100904|entityMap^0|C|1|0|0|0|1E|1|12|16|6|0|0|0|1M|0|0|G|0|0|0|T|0|0|0|0|13|0|0|8|0|0|W|0|0|1|0|0|0|U|0|0|7|0|0|L|0^^$0|@$1|2|3|4|5|6|7|1H|8|@$9|1I|A|1J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|1K|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|1L|8|@$9|1M|A|1N|B|C]|$9|1O|A|1P|B|J]|$9|1Q|A|1R|B|J]]|D|@]|E|$]]|$1|K|3|-4|5|6|7|1S|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|1T|8|@$9|1U|A|1V|B|C]]|D|@]|E|$]]|$1|N|3|O|5|P|7|1W|8|@$9|1X|A|1Y|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|S|3|T|5|P|7|20|8|@$9|21|A|22|B|C]]|D|@]|E|$]]|$1|U|3|-4|5|6|7|23|8|@]|D|@]|E|$]]|$1|V|3|W|5|X|7|24|8|@]|D|@]|E|$Y|Z]]|$1|10|3|11|5|6|7|25|8|@$9|26|A|27|B|C]]|D|@]|E|$]]|$1|12|3|13|5|6|7|28|8|@$9|29|A|2A|B|C]]|D|@]|E|$]]|$1|14|3|15|5|6|7|2B|8|@$9|2C|A|2D|B|C]]|D|@]|E|$]]|$1|16|3|17|5|6|7|2E|8|@$9|2F|A|2G|B|C]]|D|@]|E|$]]|$1|18|3|-4|5|6|7|2H|8|@]|D|@]|E|$]]|$1|19|3|1A|5|I|7|2I|8|@$9|2J|A|2K|B|C]]|D|@]|E|$]]|$1|1B|3|1C|5|6|7|2L|8|@$9|2M|A|2N|B|C]]|D|@]|E|$]]|$1|1D|3|1E|5|6|7|2O|8|@$9|2P|A|2Q|B|C]]|D|@]|E|$]]|$1|1F|3|-4|5|6|7|2R|8|@]|D|@]|E|$]]]|1G|$]]

For Windows 10,

<ol>
<li>Modify <code>my.ini</code> file in <code>C:\ProgramData\MySQL\MySQL Server 8.0\</code>

<pre><code>[mysqld]
default_authentication_plugin=mysql_native_password
</code></pre></li>
<li>Restart the MySQL Service.</li>
<li>Login to MySQL on the command line, and execute the following commands in MySQL:

<ul>
<li>Create a new user.

<pre class="lang-sql prettyprint-override"><code>CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
</code></pre></li>
<li>Grant all privileges.

<pre class="lang-sql prettyprint-override"><code>GRANT ALL PRIVILEGES ON * .* TO 'user'@'localhost';
</code></pre></li>
</ul></li>
<li>Open MySQL workbench, and open a new connection using the new user credentials.</li>
</ol>

I was facing the same issue and this worked.

blocks|key|101179|text|这是我的docker-compose中的数据库定义：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|101180|dataBase:
++++image:+mysql:8.0
++++volumes:
++++++++-+db_data:/var/lib/mysql
++++networks:
++++++++z-net:
++++++++++++ipv4_address:+172.26.0.2
++++restart:+always
++++entrypoint:+['docker-entrypoint.sh',+'--default-authentication-plugin=mysql_native_password']
++++environment:
++++++++MYSQL_ROOT_PASSWORD:+supersecret
++++++++MYSQL_DATABASE:+zdb
++++++++MYSQL_USER:+zuser
++++++++MYSQL_PASSWORD:+zpass
++++ports:
++++++++-+"3333:3306"|code-block|syntax|javascript|101181|这里的相关行是入口点。|offset|length|style|BOLD|101182|在构建并构建它之后，您可以使用以下命令对其进行测试：|101183|$+mysql+-u+zuser+-pzpass+--host=172.26.0.2++zdb+-e+"select+1;"
Warning:+Using+a+password+on+the+command+line+interface+can+be+insecure.
%2B---%2B
%7C+1+%7C
%2B---%2B
%7C+1+%7C
%2B---%2B|101184|entityMap^0|0|0|7|3|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

This is my databdase definition in my docker-compose:

<pre><code>dataBase:
 image: mysql:8.0
 volumes:
 - db_data:/var/lib/mysql
 networks:
 z-net:
 ipv4_address: 172.26.0.2
 restart: always
 entrypoint: ['docker-entrypoint.sh', '--default-authentication-plugin=mysql_native_password']
 environment:
 MYSQL_ROOT_PASSWORD: supersecret
 MYSQL_DATABASE: zdb
 MYSQL_USER: zuser
 MYSQL_PASSWORD: zpass
 ports:
 - "3333:3306"
</code></pre>

The relevant line there is entrypoint.

After build and up it, you can test it with:

<pre><code>$ mysql -u zuser -pzpass --host=172.26.0.2 zdb -e "select 1;"
Warning: Using a password on the command line interface can be insecure.
+---+
| 1 |
+---+
| 1 |
+---+
</code></pre>

blocks|key|98572|text|对于那些使用Docker或Docker+Compose的用户，我遇到了这个错误，因为我没有设置我的MySQL镜像版本。Docker会自动尝试获取最新版本8。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|98573|我将MySQL设置为5.7，并重新构建了图像，它正常工作：|98574|version:+'2'
services:+
++db:
+++image:+mysql:5.7|code-block|syntax|javascript|98575|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

For those using Docker or Docker Compose, I experienced this error because I didn't set my MySQL image version. Docker will automatically attempt to get the latest version which is 8.

I set MySQL to 5.7 and rebuilt the image and it worked as normal:

<pre><code>version: '2'
services: 
 db:
 image: mysql:5.7
</code></pre>

blocks|key|2844297|text|我发现|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2844298|ALTER+USER+'username'@'ip_address'+IDENTIFIED+WITH+mysql_native_password+BY+'password';|code-block|syntax|javascript|2844299|它本身并不起作用。我还需要设置|2844300|[mysqld]
++++default_authentication_plugin=mysql_native_password|2844301|在运行PHP+7.0的Ubuntu+18.04上的/etc/mysql/mysql.conf.d/mysqld.cnf中|2844302|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I found that 

<pre><code>ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';
</code></pre>

didn't work by itself. I also needed to set

<pre><code>[mysqld]
 default_authentication_plugin=mysql_native_password
</code></pre>

in /etc/mysql/mysql.conf.d/mysqld.cnf
on Ubuntu 18.04 running PHP 7.0

blocks|key|2632541|text|这是在Windows10上安装了Windows8.0之后对我起作用的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2632542|假设MySQL用户名为root，密码为admin|offset|length|style|CODE|2632543|打开命令提示符，然后输入以下命令：|2632544|2632545|+cd+C:\Program+Files\MySQL\MySQL+Server8.0\bin|blockquote|2632546|2632547|mysql_upgrade+-uroot+-padmin|2632548|mysql+-uroot+-padmin|2632549|ALTER+USER+'root'@'localhost‘由'admin'标识为mysql_native_password|2632550|entityMap^0|0|B|4|J|5|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]|$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|14|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|16|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|17|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|18|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|V|$]]

Here is the solution which worked for me after MySQL 8.0 Installation on Windows 10.

Suppose MySQL username is <code>root</code> and password is <code>admin</code>

Open command prompt and enter the following commands:

<blockquote>
 cd C:\Program Files\MySQL\MySQL Server 8.0\bin
 
 mysql_upgrade -uroot -padmin
 
 mysql -uroot -padmin
 
 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY
 'admin'
</blockquote>

blocks|key|2632242|text|如果你像我一样在GitLab+CI上收到这个错误:只需从最新版本改为5.7版本;)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2632243|#+.gitlab-ci.yml

rspec:
++services:
++++#+-+mysql:latest+(I'm+using+latest+version+and+it+causes+error)
++++-+mysql:5.7+#(then+I've+changed+to+this+specific+version+and+fix!)|code-block|syntax|javascript|2632244|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|$]]

If you are getting this error on GitLab CI like me: 
Just change from latest to 5.7 version ;)

<pre><code># .gitlab-ci.yml

rspec:
 services:
 # - mysql:latest (I'm using latest version and it causes error)
 - mysql:5.7 #(then I've changed to this specific version and fix!)
</code></pre>

blocks|key|101159|text|打开我的sql命令提示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|101160|​|101161|📷|atomic|offset|length|101162|101163|然后输入mysql密码|101164|101165|101166|101167|最后使用：|101168|ALTER+USER+'username'@'ip_address'+IDENTIFIED+WITH+mysql_native_password+BY+'password';|style|CODE|101169|参考：https://stackoverflow.com/a/49228443/6097074|101170|谢谢。|101171|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/0e546f2af0494bad321f931c82cc8bd0.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/1bf3a132c7a4e181528c45176bd4fa97.png|2|LINK|MUTABLE|url|https://stackoverflow.com/a/49228443/6097074^0|0|0|0|1|0|0|0|0|0|0|1|1|0|0|0|0|2F|0|3|18|2|0|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1F|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1G|8|@]|9|@$G|1H|H|1I|1|1J]]|A|$]]|$1|I|3|C|5|6|7|1K|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1L|8|@]|9|@]|A|$]]|$1|L|3|C|5|6|7|1M|8|@]|9|@]|A|$]]|$1|M|3|E|5|F|7|1N|8|@]|9|@$G|1O|H|1P|1|1Q]]|A|$]]|$1|N|3|C|5|6|7|1R|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1S|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1T|8|@$G|1U|H|1V|S|T]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1W|8|@]|9|@$G|1X|H|1Y|1|1Z]]|A|$]]|$1|W|3|X|5|6|7|20|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|21|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15|16|-4]]|17|$5|11|12|13|A|$14|18|16|-4]]|19|$5|1A|12|1B|A|$1C|1D]]]]

Open my sql command promt:

<a href="https://i.stack.imgur.com/5bET0.png" rel="noreferrer"><img src="https://i.stack.imgur.com/5bET0.png" alt="step 1"></a>

then enter mysql password

<a href="https://i.stack.imgur.com/4n3ag.png" rel="noreferrer"><img src="https://i.stack.imgur.com/4n3ag.png" alt="step 2"></a>

finally use:

<code>ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';</code>

refer:<a href="https://stackoverflow.com/a/49228443/6097074">https://stackoverflow.com/a/49228443/6097074</a>

Thanks.

blocks|key|2632750|text|对我来说，这是因为在一个项目中，我使用的是Docker镜像mysql:latest+(版本5，运行良好)，在后来的构建中，最新版本切换到了版本8，and+stopped+working。I+changed+my+image+to+mysql:5和I+and+no+longer+getting+this+error.|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2632751|entityMap|0|LINK|mutability|MUTABLE|url|https://circleci.com/gh/dcycle/realistic_dummy_content/132|1|https://github.com/dcycle/realistic_dummy_content/pull/23/files|2|https://circleci.com/gh/dcycle/realistic_dummy_content/134^0|21|J|0|2N|R|1|3L|S|2|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]|$A|W|B|X|1|Y]]|C|$]]|$1|D|3|-4|5|6|7|Z|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]|N|$5|G|H|I|C|$J|O]]]]

For me this started happening because on a project, I was using Docker image mysql:latest (which was version 5, and which was working fine), and during a later build, the latest version was switched to version 8, <a href="https://circleci.com/gh/dcycle/realistic_dummy_content/132" rel="noreferrer">and stopped working</a>. I <a href="https://github.com/dcycle/realistic_dummy_content/pull/23/files" rel="noreferrer">changed my image to mysql:5</a> and I was <a href="https://circleci.com/gh/dcycle/realistic_dummy_content/134" rel="noreferrer">no longer getting this error</a>.

blocks|key|98319|text|当使用的工具与MySQL8不兼容时会出现此错误，请尝试更新至最新版本的MySQL+MySQL8工作台|type|unstyled|depth|inlineStyleRanges|entityRanges|data|98320|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|$]]

This error comes up when the tool being used is not compatible with MySQL8, try updating to the latest version of MySQL Workbench for MySQL8

blocks|key|98106|text|与上面的答案几乎一样，但可能是在简单的查询中，在MySQL升级后，我在spring+boot应用程序和hibernate中得到了这个错误。我们通过对数据库运行以下查询创建了一个新用户。我相信这是一个临时的解决办法，用sha256_password代替最新和良好的身份验证caching_sha2_password。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|98107|CREATE+USER+'username'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'pa$$word';

GRANT+ALL+PRIVILEGES+ON+*+.*+TO+'username'@'localhost';|code-block|syntax|javascript|98108|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|$]]

Almost like answers above but may be in simple queries, I was getting this error in my spring boot application along with hibernate after MySQL upgrade. We created a new user by running the queries below against our DB. I believe this is a temp work around to use sha256_password instead of latest and good authentication caching_sha2_password. 

<pre><code>CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pa$$word';

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

blocks|key|2632513|text|用于macOS的MySQLWorkbench+8.0.11解决了这一问题。我可以建立与root密码保护的mysql实例在docker中运行的连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2632514|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|$]]

MySQLWorkbench 8.0.11 for macOS addresses this.
I can establish connection with root password protected mysql instance running in docker.

blocks|key|2632927|text|如果您尝试从另一台计算机(无论是否为Docker+)从基于文本的MySQL客户端连接到MySQL服务器|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2632928|这里的大多数答案都涉及到从桌面客户端连接，或者要求您切换到较旧的身份验证方法。如果你将其与MySQL客户端(基于文本)连接，我将其与Docker容器中的Debian+Buster一起使用。|2632929|假设您已经设置了apt系统和wget，请执行以下操作：|2632930|2632931|sudo+apt-get+update|ordered-list-item|CODE|2632932|sudo+apt-get+install+lsb-release+-y|2632933|Download一个Debian包，它会从MySQL+web+site.|2632934|sudo+dpkg+-i+mysql-apt-config_0.8.13-1_all.deb中为你更新apt源代码，并选择你想要的选项。在我的例子中，我只需要将enabled.|2632935|sudo+apt-get+update|2632936|sudo+apt-get+install+mysql-client+-y|2632937|Done.设置为MySQL+Tools+&+Connectors现在，您可以运行新的MySQL客户端并使用新的身份验证方法进行连接。|2632938|2632939|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/downloads/repo/apt/^0|0|1F|0|0|0|0|0|J|0|0|Z|0|L|E|0|0|0|1A|0|0|J|0|0|10|0|8|O|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1C|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|1D|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]|$1|K|3|L|5|M|7|1F|8|@$9|1G|A|1H|B|N]]|D|@]|E|$]]|$1|O|3|P|5|M|7|1I|8|@$9|1J|A|1K|B|N]]|D|@]|E|$]]|$1|Q|3|R|5|M|7|1L|8|@]|D|@$9|1M|A|1N|1|1O]]|E|$]]|$1|S|3|T|5|M|7|1P|8|@$9|1Q|A|1R|B|N]]|D|@]|E|$]]|$1|U|3|V|5|M|7|1S|8|@$9|1T|A|1U|B|N]]|D|@]|E|$]]|$1|W|3|X|5|M|7|1V|8|@$9|1W|A|1X|B|N]]|D|@]|E|$]]|$1|Y|3|Z|5|M|7|1Y|8|@$9|1Z|A|20|B|N]]|D|@]|E|$]]|$1|10|3|-4|5|6|7|21|8|@]|D|@]|E|$]]|$1|11|3|-4|5|6|7|22|8|@]|D|@]|E|$]]]|12|$13|$5|14|15|16|E|$17|18]]]]

If you are trying to connect to a MySQL server from a text-based MySQL client from another computer (be it Docker or not)

Most answers here involve connecting from a desktop client, or ask you to switch to an older authentication method. If you're connecting it with the MySQL client (text-based), I made it work with a Debian Buster in a Docker container.

Say you have the apt system and wget set up, do the following:

<ol>
<li><code>sudo apt-get update</code></li>
<li><code>sudo apt-get install lsb-release -y</code></li>
<li>Download a Debian package which update apt sources for you from the <a href="https://dev.mysql.com/downloads/repo/apt/" rel="nofollow noreferrer">MySQL web site</a>.</li>
<li><code>sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb</code> and select the options you want. In my case I only need <code>MySQL Tools &amp; Connectors</code> to be enabled.</li>
<li><code>sudo apt-get update</code></li>
<li><code>sudo apt-get install mysql-client -y</code></li>
<li>Done. You can now run the new MySQL client and connect with the new authentication method.</li>
</ol>

blocks|key|101303|text|下面的解决方案对我很有效|type|unstyled|depth|inlineStyleRanges|entityRanges|data|101304|📷|atomic|offset|length|101305|​|101306|转到Mysql工作台->服务器->用户和权限1.单击添加帐户|101307|2.在登录选项卡下，提供新的详细信息，并确保将身份验证类型选择为标准，然后选择相应的管理角色和架构权限|style|BOLD|101308|101309|101310|101311|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/66ae965593e7009544bb653b6b9c28ad.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/9c33bbaeabb6f2f846f76ca7f8d0c2c6.png^0|0|0|1|0|0|0|0|W|2|0|0|0|1|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|@$E|14|F|15|1|16]]|A|$]]|$1|G|3|H|5|6|7|17|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|18|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|19|8|@$E|1A|F|1B|M|N]]|9|@]|A|$]]|$1|O|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|P|3|C|5|D|7|1D|8|@]|9|@$E|1E|F|1F|1|1G]]|A|$]]|$1|Q|3|H|5|6|7|1H|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y|Z|-4]]|10|$5|U|V|W|A|$X|11|Z|-4]]]]

The below solution worked for me 
<a href="https://i.stack.imgur.com/TMWIz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TMWIz.png" alt="enter image description here"></a>

Go to Mysql Workbench -> Server-> Users and Privileges
1.Click Add Account 

2.Under Login Tab provide new details and make sure to choose the Authentication Type as standard and choose respective administrative roles and Schema Privileges

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

blocks|key|101305|text|实际上，MySql在安装时允许两种类型的身份验证。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|101306|101307|Password+Encryption|ordered-list-item|101308|Legacy+Encryption|101309|101310|​|101311|📷|atomic|offset|length|101312|101313|Read+Here|101314|因此，通过检查遗留身份验证，该问题已得到解决。|101315|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/8ee6a8e664cce1e122730bb77f5937d0.png|imageAlt|1|LINK|MUTABLE|url|https://dev.mysql.com/doc/mysql-installer/en/server-authentication-method.html^0|0|0|0|0|0|0|0|1|0|0|0|0|9|1|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|G|5|E|7|1B|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1D|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1E|8|@]|9|@$N|1F|O|1G|1|1H]]|A|$]]|$1|P|3|J|5|6|7|1I|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1J|8|@]|9|@$N|1K|O|1L|1|1M]]|A|$]]|$1|S|3|T|5|6|7|1N|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11|12|-4]]|13|$5|14|Y|15|A|$16|17]]]]

Actually MySql allows two type of authentication at the time of installation.
<ol>
<li>Password Encryption</li>
<li>Legacy Encryption</li>
</ol>
<a href="https://i.stack.imgur.com/hTpU0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hTpU0.png" alt="enter image description here" /></a>
<a href="https://dev.mysql.com/doc/mysql-installer/en/server-authentication-method.html" rel="nofollow noreferrer">Read Here</a>
So by checking legacy authentication the issue was resolved.

blocks|key|101389|text|在下载和安装MySql时尝试使用传统密码，这对我很有帮助。或者遵循Santhosh+Shivan在Mac+OS上发布的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|101390|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|$]]

Try using legacy password while downloading and installing MySql, that helped me.
Or follow the method posted by Santhosh Shivan for Mac OS.

blocks|key|2633027|text|我在M1+(arm64)中运行docker，在docker+bash中直接更改的方法对我不起作用。相反，我将mysql镜像更改为mysql:8.0.26，平台设置为linux/x86_64，并将default_authentication_plugin=mysql_native_password添加到my.cnf，然后重新构建容器。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2633028|entityMap^0|1S|C|2A|C|2P|1F|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

I run docker in M1 (arm64), the direct way of changing in the docker bash does not work for me. Instead, I change the mysql image to be
<code>mysql:8.0.26</code>
and the platform is set as
<code>linux/x86_64</code>
and add <code>default_authentication_plugin=mysql_native_password </code> to my.cnf
Then, you rebuild your container.

blocks|key|101178|text|我在mac上下载了8.0.11-rc的开发版本。使用以下docker命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|101179|docker+run+--name+mysql+-p+3406:3306+-e+MYSQL_ROOT_PASSWORD=mypassword+-d+mysql|code-block|syntax|javascript|101180|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|$]]

Downloading a development release of 8.0.11-rc worked for me on a mac. with the following docker commands:

<pre><code>docker run --name mysql -p 3406:3306 -e MYSQL_ROOT_PASSWORD=mypassword -d mysql
</code></pre>

blocks|key|101338|text|刚刚下载了与最新加密兼容的最新mysqlworkbench：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|101339|https://downloads.mysql.com/archives/workbench/|offset|length|101340|注意:在Mac+big+Sur上，最新的两个版本:+8.0.22和8.0.23存在错误，无法工作。|101341|在这些问题得到解决之前，使用8.0.21|style|BOLD|101342|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1B|0|0|0|C|8|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|6|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Y|8|@$D|Z|E|10|J|K]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|C]]]]

Just downloaded the latest mysqlworkbench which is compatible with the latest encryption:
<a href="https://downloads.mysql.com/archives/workbench/" rel="nofollow noreferrer">https://downloads.mysql.com/archives/workbench/</a>
Note: On Mac big Sur, the latest two versions: 8.0.22 and 8.0.23 are buggy and do not work.
Use 8.0.21 until these are fixed

blocks|key|2632827|text|我通过安装MySQL+5.7解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2632828|第1步-启用MySQL存储库|2632829|首先，您需要在系统上启用MySQL+5.7社区版本yum存储库。yum存储库配置的rpm包可以在MySQL官方网站上找到。根据您的操作系统版本，使用以下命令中的on。|2632830|关于CentOS和RHEL7|2632831|yum+localinstall+https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm|code-block|syntax|javascript|2632832|关于CentOS和RHEL6|2632833|yum+localinstall+https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm|2632834|在Fedora+27上|2632835|dnf+install+https://dev.mysql.com/get/mysql57-community-release-fc27-9.noarch.rpm|2632836|在Fedora+26上|2632837|dnf+install+https://dev.mysql.com/get/mysql57-community-release-fc26-9.noarch.rpm|2632838|在Fedora+25上|2632839|dnf+install+https://dev.mysql.com/get/mysql57-community-release-fc25-9.noarch.rpm|2632840|第2步-安装MySQL+5.7服务器|2632841|因为您已经成功地在系统上启用了MySQL+yum存储库。现在，根据您的操作系统版本使用以下命令安装MySQL+5.7社区服务器。|2632842|关于CentOS和RHEL+7/6|2632843|yum+install+mysql-community-server|2632844|关于Fedora+27/26/25|2632845|+dnf+install+mysql-community-server|2632846|来源：https://tecadmin.net/install-mysql-5-7-centos-rhel/|offset|length|2632847|entityMap|0|LINK|mutability|MUTABLE|url|https://tecadmin.net/install-mysql-5-7-centos-rhel/^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|1F|0|0^^$0|@$1|2|3|4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1S|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1T|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|1U|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1V|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|1W|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|1X|8|@]|9|@]|A|$]]|$1|S|3|T|5|J|7|1Y|8|@]|9|@]|A|$K|L]]|$1|U|3|V|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|W|3|X|5|J|7|20|8|@]|9|@]|A|$K|L]]|$1|Y|3|Z|5|6|7|21|8|@]|9|@]|A|$]]|$1|10|3|11|5|J|7|22|8|@]|9|@]|A|$K|L]]|$1|12|3|13|5|6|7|23|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|24|8|@]|9|@]|A|$]]|$1|16|3|17|5|6|7|25|8|@]|9|@]|A|$]]|$1|18|3|19|5|J|7|26|8|@]|9|@]|A|$K|L]]|$1|1A|3|1B|5|6|7|27|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|J|7|28|8|@]|9|@]|A|$K|L]]|$1|1E|3|1F|5|6|7|29|8|@]|9|@$1G|2A|1H|2B|1|2C]]|A|$]]|$1|1I|3|-4|5|6|7|2D|8|@]|9|@]|A|$]]]|1J|$1K|$5|1L|1M|1N|A|$1O|1P]]]]

I solved this problem by installing MySQL 5.7:

<h1>Step 1 – Enable MySQL Repository</h1>

First of all, You need to enable MySQL 5.7 community release yum repository on your system. The rpm packages for yum repository configuration are available on MySQL official website. Use on of below command as per your operating system version.

<h2>On CentOS and RHEL 7</h2>

<pre><code>yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
</code></pre>

<h2>On CentOS and RHEL 6</h2>

<pre><code>yum localinstall https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm
</code></pre>

<h2>On Fedora 27</h2>

<pre><code>dnf install https://dev.mysql.com/get/mysql57-community-release-fc27-9.noarch.rpm
</code></pre>

<h2>On Fedora 26</h2>

<pre><code>dnf install https://dev.mysql.com/get/mysql57-community-release-fc26-9.noarch.rpm
</code></pre>

<h2>On Fedora 25</h2>

<pre><code>dnf install https://dev.mysql.com/get/mysql57-community-release-fc25-9.noarch.rpm
</code></pre>

<h1>Step 2 – Install MySQL 5.7 Server</h1>

As you have successfully enabled MySQL yum repository on your system. Now, install MySQL 5.7 community server using following commands as per your operating system version.

<h2>On CentOS and RHEL 7/6</h2>

<pre><code>yum install mysql-community-server
</code></pre>

<h2>On Fedora 27/26/25</h2>

<pre><code> dnf install mysql-community-server
</code></pre>

source: <a href="https://tecadmin.net/install-mysql-5-7-centos-rhel/" rel="nofollow noreferrer">https://tecadmin.net/install-mysql-5-7-centos-rhel/</a>

blocks|key|2844220|text|回滚到以前的安装(到MySQL+Community+Server5.7和Workbench+6.1)并设置新的MySQL凭据对我来说很有效！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2844221|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|$]]

Rolling back to the previous installations (to MySQL Community Server 5.7 and Workbench 6.1)and setting up new MySQL credentials worked for me!

I am connecting MySQL - 8.0 with MySQL Workbench and getting the below error:

<blockquote>
 Authentication plugin 'caching_sha2_password' cannot be loaded:
 dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image
 not found
</blockquote>

I have tried with other client tool as well.

Any solution for this?

Authentication plugin 'caching_sha2_password' cannot be loaded

我正在使用MySQL工作台连接MySQL - 8.0，并收到以下错误：无法加载图像身份验证插件'caching_sha2_password‘：dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so，2)：找不到图像我也尝试过其他客户端工具。有什么解决方案吗？

问无法加载身份验证插件'caching_sha2_password‘
EN

回答 32

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法加载身份验证插件'caching_sha2_password‘EN

回答 32

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法加载身份验证插件'caching_sha2_password‘
EN