Follow dba-ninja.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

dba-ninja.com Links

Dba_db2_button

Sqlserver_dba_button

How to enable mysql_clear_password plugin?

13 March,2025 by Rambler

Question: I'm getting the following eeror when attempting to connect to a server using MySQL Shell . How can I fix the issue?

 

MySQL SQL > \connect johnk@myserver:27018
Creating a session to 'johnk@myserver:27018'
Please provide the password for 'johnk@myserver:27018': *********************
MySQL Error 2059 (HY000): Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabled

 

Answer:  By default the MySQL shell has cleartext authentication turned off , to avoid accidental usage of clear text passwords. But if you must use cleartext passwords , enable the the system environment variable LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN

--if on Windows

Set system environment variable LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN = Y

c:\mysqlsh 

MySQL SQL > \connect johnk@myserver:27018
Creating a session to 'johnk@myserver:27018'
Please provide the password for 'johnk@myserver:27018': *********************
Your MySQL connection id is 48705


Author: Rambler (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to enable mysql_clear_password plugin?


dba-ninja.com