mysqldatabasemacosnavicat
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 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
Solution
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
- Connect to mysql in a docker container from the host
- Executing SQL scripts on docker container
- XAMPP - Error: MySQL shutdown unexpectedly
- Undefined Module Mysl - Ballerina
- DBeaver error resolving maven dependencies
- ERROR - Must Declare Scalar Variable - C#
- Cannot delete or update a parent row: a foreign key constraint fails. Foreign keys exist though
- MySQL: IF EXISTS ... TRUNCATE
- mysql COUNT and Sum with join 2 tables
- Install Navicat on Linux Ubuntu 12.04
- How do I set MySQL temporarily to read-only through the command line?
- How to increment column values with CodeIgniter's update_batch()
- str_to_date is showing NULL when date is available
- Can I use a variable from the GET_ method to fetch MySQL data?
- select ... where id = any value. is it possible?
- Data truncated for column?
- Unable to install MySQL on Windows 10 - Installer hangs indefinitely
- Why can't I just use "HAVING" clause all the time instead of "WHERE"? It works the same basically if you use it before/without "GROUP BY"
- MySQL Workbench: Connecting to database automatically on the startup
- Select rows for a specific date using TIMESTAMP datatype
- GoLang How to load nested objects using GORM
- What COLLATE should i set to use all kind of possible languages?
- MYSQL - SELECT NULL otherwise latest DATE per group
- How do I set up replication from MySQL to MongoDB?
- NULL when value not found using substring_index in MYSQL
- How to convert an entire MySQL database characterset and collation to UTF-8?
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- MySQL - AND condition
- Problem updating a table after insert using trigger in MySQL
- How to disable max key length error in mysql