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

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

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

描述

 
    用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月04日 21:56

Thanks for a very interesting blog. What else may I get that kind of info written in such a perfect approach? I’ve a undertaking that I am simply now operating on, and I have been at the look out for such info. mieszkania szczecin

Avatar_small
Oliviaseo 说:
2020年12月04日 22:10

i really like this article please keep it up. biura nieruchomosci szczecin

Avatar_small
Oliviaseo 说:
2020年12月12日 21:58

AHSEC Officially Conduct HS Examination in 33 Administrative Geographical units called Districts wise. AHSEC officially announce the results in the month of June, Annually and Private and Regular Students Participate in Assam HS Examination every year more than laks of students. Assam HS Exam are conducted by Assam Higher Secondary Education Council Only, AHSEC HS Model Paper 2021 Available Students you can Download in Pdf format form this web page below given links. Assam State HS Regular and Private Students Prepare their Exam from these Sample Papers, Students have to Register for Appearing in Public Exam 2021. AHSEC Question Paper 2021 for Sceince

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
Buy terfamex-fenterm 说:
2021年1月27日 01:25

Buy terfamex-fentermina 30mg is a hunger inhibitor, that ensure that body do not abuse a necessary diet.

Avatar_small
dark web/deep web/d 说:
2022年8月08日 16:51

There are countless places out there that have to do with the dark web and by joining up at a large forum you should have no problem gathering enough information to start making your case. dark web links

Avatar_small
dark web/deep web/d 说:
2022年8月08日 17:22

This strange phenomenon has been noted by researchers who have studied the behavior of people looking for products or services on the Internet. They have noticed that those who buy their items on the "Dream Market" tend to visit more often than those who don't. deep web

Avatar_small
dark web/deep web/d 说:
2022年8月08日 17:46

Instead, they are links used by companies to advertise their products or services. For example, one company may use links on message boards and discussion forums to advertise its products or services. dark web sites

Avatar_small
dark web/deep web/d 说:
2022年8月08日 18:07

The dark web marketplaces are still growing in size and popularity. As the name suggests, you will need to watch out for scam sites that are set up only to steal your information and promote their own products and services instead.  dark web links

Avatar_small
dark web/deep web/d 说:
2022年8月08日 18:27

But when you venture into the Dark Web, you'll run into several problems. First, you have to use a specific browser. The major browsers like Internet Explorer and Firefox won't work in the dark because they are unable to connect with the Dark Web.  dark web

Avatar_small
dark web/deep web/d 说:
2022年8月08日 18:45

However, there are a few things that you need to be careful about. You must make sure that the products you recommend are high quality, well received and popular.  work from home jobs

Avatar_small
dark web/deep web/d 说:
2022年8月08日 19:04

One secret to making money online is learning how to drive traffic to your website using an affiliate marketing campaign. The reason you must learn about this type of marketing is because it is the most effective and the most cost efficient way of advertising.  affiliate marketing success


登录 *


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