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
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |