Authentication Plugin 'Mysql_Clear_Password' Cannot Be Loaded in Navicat
I Try to Connect with My Database and Use Navicat with Macos, but I Get an Error and Not Able to Connect. I Tried Many Different Things but Not Able to Connect...
I try to connect with my database and use Navicat with MacOS , but I get an error and not able to connect. I tried many different things but not able to connect yet. any help really appreciates and it's really great to help me.
Error :
Connection Failed
Authentication plugin 'mysql_clear_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/mysql_clear_password.so, 2): image not found
2 Answers
I got the same error in my MySQLWorkbench, went through the available ui configs and ticked the
Enable Cleartext Authentication Plugin
Steps need to be taken:
- Open Connect to Database window
- Choose Advanced option
- Tick Enable Cleartext Authentication Plugin option
You could try starting Navicat from the terminal. This assumes the app is 'Navicat Premium Essentials'.
LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=y /Applications/Navicat\ Premium\ Premium\ Essentials
This solved the issue for me with Sequel Pro. See:
Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.
