MySQL Debug | MySQL Navicat Connection Failed

Source: Internet
Author: User

Tag: Failed color Strong Sha Description Pen nbsp Success Cos

First, the situation description:Native environment MacOS 10.13.6MySQL version 8.0.12MySQL installed successfully, and the command line successfully ran trying to connect the Nawicat times wrong,
2059 - ' Caching_sha2_password ' cannot be loaded:dlopen (. / Frameworks/2image not found

Because the authentication plug-in cannot be loaded

Second, the solution:1) Enter the System preferences, click on MySQL, restart the initialization database initialize DATABASE;2) Enter the password and select ' Use Legacy password ' (the recommended strong is selected when installing Password) 3) Restart MySQL service, reconnect Navicat, show success

MySQL Debug | MySQL Navicat Connection Failed

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.