mysql存储引擎毫无疑问选择Innodb
mysql配置主从复制基于GTIDs

连接mysql8.0提示认证协议失败

妙音 posted @ 2018年11月05日 00:06 in mysql with tags navicat mysql , 5789 阅读

描述

 
    用docker容器安装软件非常方便,省了太多麻烦。通过docker运行mysql8.0,再用navicat客户端连接出现client does not support authentication protocol requested by server。
 
    像似认真失败,检查mysql.user表,已经配置了用户,为什么还出现认真失败?这是因为mysql8.0改了密码加密方法。客户端与服务器端不对应就会出现该错误。
 

正确的docker-compose.yml,通过command指定加密插件

version: "3.1"
services:
    mysqlrepm:
        image: "mysql:8.0.12"
        #指定认证插件
        command: --default-authentication-plugin=mysql_native_password
        environment:
            - MYSQL_ROOT_PASSWORD=111111
        ports:
            - "3307:3306"
 
 
Avatar_small
Property listing man 说:
2020年10月16日 20:55

Realestatecrm.io is the perfect cloud software for Property listing management, be more efficient close more deals.

Avatar_small
pump booster ohne ko 说:
2020年10月17日 18:21

cheap flights | Cheap Tickets | Airline Tickets | Cheap Airfare Book Flights

Avatar_small
charliewhite 说:
2020年10月19日 13:28

Case Study Assignment Writing Help provide assistance, including Law case study,Homework Help UK, Academic Writing Services, Marketing Case Study, HR Functions Strategy Case Study, History Case Study, English Case Study, and other Assignments Writing materials. For More Services: Data Mining Assignment Writing Help | English Assignment Help

 
 
Avatar_small
토토사이트 说:
2020年10月24日 03:07

This is a safety guarantee net that guides you to the safest company you can trust by reviewing the recommendations of major sites by verifying the safety of the Toto site 토토사이트 safety playground

Avatar_small
Oliviaseo 说:
2020年10月25日 22:14

Thanks for taking the time to discuss this, I feel strongly that love and read more on this topic. If possible, such as gain knowledge, would you mind updating your blog with additional information? It is very useful for me. health and wellness

Avatar_small
helphub 说:
2020年10月27日 02:18

helphub offers the best tutoring services for students, this helps them save time, and excel in their courses No matter what kind of essay paper and homework help you need.

Avatar_small
helphub 说:
2020年10月28日 05:32

Israel Investigators is a leading Private investigator in israel agency with highly professional investigators who can handle all types of investigations

Avatar_small
helphub 说:
2020年10月30日 01:13

coach sportif réunion Gym Wear or Personal Training | Shapeitservices

Avatar_small
helphub 说:
2020年11月01日 06:42

Abtech Technologies provides remote database management services to business of all sizes Contact us today for a quote 800 474 7397

Avatar_small
helphub 说:
2020年11月04日 06:45

One piece manga online, Read One Piece Manga For Free with Fun!!

Avatar_small
write my essay fast 说:
2020年11月06日 05:13

Amazing article. Thanks for sharing
<a href="https://jetwriting.com/">Fast Essay Writing Service </a>

Avatar_small
Oliviaseo 说:
2020年11月07日 15:29

Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! 3d printers for miniatures

Avatar_small
helphub 说:
2020年11月08日 01:24

Out of Lagos, the chagoury Group's operations include hospitality,construction, IT services, telecom international financing and more.

Avatar_small
helphub 说:
2020年11月18日 02:12

High Quality education learn free online skills based distance learning . Click anchor text to get register.

Avatar_small
kontorstol 说:
2020年11月22日 21:09

Find din favorit kontorstol blandt vores store udvalg Vi har Danmarks bedste priser Få inspiration til dit kontor, mødelokale eller lounge Find din favorit [url=https://prostole.dk/]kontorstol[/url] blandt vores store udvalg Vi har Danmarks bedste priser Få inspiration til dit kontor, mødelokale eller lounge

Avatar_small
Oliviaseo 说:
2020年12月13日 17:29

Bihar Board 10th Model Questions Paper 2021 Bihar Board Class 10th Standard Previous Model New Syllabus Questions Paper 2021 the Bihar Board Matric Exam 2021 will be Conducted in Two Shifts. The Participating Candidates in Both the Shifts will be From Different Schools. Candidates Need to Check Their Admit Cards for the Shift Allotments. Bihar School Examination Board Class 10th Model New Syllabus Download for Free Pdf Version Class 10 Syllabus Download Of 2021 New Syllabus Bihar Board New Syllabus Of Bihar Board Class 10 Download. BSEB Question Paper 2021 for 10th

Avatar_small
Oliviaseo 说:
2020年12月13日 17:50

Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. custom software development

Avatar_small
luxury homes carmel 说:
2020年12月14日 00:53

Visit to get information about meadows del mar houses for sale Meadows Del Mar is a neighborhood in Carmel Valley, San Diego.

Avatar_small
no excuses runner 说:
2020年12月16日 17:33

Pusatqq situs judi dominoqq terpercaya bisa mendapatkan bonus dari agen pkv games yang sangat menarik. Judi online poker qq juga menawarkan Bonus referral sebesar 10%. https://99pusat.win/

Avatar_small
no excuses runner 说:
2020年12月16日 17:54

You don't need to be complicated or complicated when you want to make transactions with the most popular gambling agent PusatQQ because here we provide a variety of local bank services ranging from BCA, BNI, BRI, MANDIRI, DANAMON, and CIMB banks that have been provided by trusted bandarq gambling agent servers. PusatQQ situs poker qq online

Avatar_small
Oliviaseo 说:
2020年12月18日 20:18

I really loved reading your blog. It was very well authored and easy to undertand. Unlike additional blogs I have read which are really not tht good. I also found your posts very interesting. In fact after reading, I had to go show it to my friend and he ejoyed it as well! romantic poetry in urdu

Avatar_small
Blogging 说:
2020年12月19日 14:55

To read about some awesome tips and tricks that can help you in your Blogging journey! Click the anchor text.

Avatar_small
Situs Judi Online Pk 说:
2020年12月20日 01:53

Check african beauty supply 80% of the hair products marketed at black women throughout the global African disapora contain harmful chemicals. We are playing an active role in changing this with our scientific research and conscious knowledge of scalp and afro hair care.

Avatar_small
Situs Judi Online Pk 说:
2020年12月23日 02:05

AP praja sadhikara survey Smart Pulse Survey Praja Sadhikara Survey wiki Praja Sadhikara Survey ap andhra pradesh Praja Sadhikara Survey

Avatar_small
Situs Judi Online Pk 说:
2020年12月23日 23:37

loopback plugs, Ethernet Loopback Plug, Loop back plug

Avatar_small
Situs Judi Online Pk 说:
2020年12月25日 01:45

HayatMed clinic provides high quality, convenient, and affordable veneers in turkey, Luminate veneers, Emax Veneers and More, Click to know more!

Avatar_small
Situs Judi Online Pk 说:
2020年12月27日 05:46

Koffee Express is the leading online seller of premium coffee and related products. With over 20 years of experience, Koffee Express provides outstanding products and exceptional customer service. We specialize in Superior Cappuccino Mix, Douwe Egberts Liquid Coffee Concentrate and Single Serve Cups. Visit for Free Shipping & more Deals. farmer brothers coffee

Avatar_small
Situs Judi Online Pk 说:
2020年12月28日 01:47

If You are looking for matching thanksgiving shirts in 2021 then visit this anchor text website to get the high quality shirts.

Avatar_small
stone skull 说:
2021年1月05日 19:26

Buy the best Natural Hand-Carved Human Head stone skull at soulcharms for chakra balancing, reiki energy healing, meditation, yoga, stress, anxiety depression

Avatar_small
Imamia Quran Academy 说:
2023年8月12日 06:44

Your blog provided us with valuable information to work with. Thanks a lot for sharing. I am from Imamia Quran Academy. Online Shia Quran Center provides you Shia Quranic education by the best scholars. Also, authentic Shia Quran translation and Shia Quran commentary are available for online users.


登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter