MySQL has a plugin that allows user authentication against current user’s Windows credentials. The plugin is ‘authentication_windows.dll’.
I get the following error message from SQLyog:
Error No. 2058 Plugin authentication_windows_client could not be
loaded: The specified module could not be found.
The “authentication_windows_client” is a dll that is supposed to be loaded on the client side. Actually I think that SQLyog is looking for an older dll which has been replaced by MySQL with ‘libmysql.dll’.
How do I make SLQyog load the correct dll?
asked May 15, 2018 at 19:30
2
Sqlyog included clear text and dialog plugin but due to license issue the are not able to support window authentication plugin.
so either you may purchase the product or go for crack otherwise you cannot use sqlyog along side with mysql until someone is not cracking…
answered Jul 11, 2018 at 16:25
Asad KareemAsad Kareem
3823 silver badges11 bronze badges
Error analysis
Error information translation:
«Plug-in Cache — SHA2_ Password Unable to load»
The reason is that the SQLYOG failed to correctly parse the use of the mysql password encryption method.
Solution
Log in to mysql in the CMD command line (need to configure environment variable in advance), perform the following code
Connect MySQL sheel to localserver
\connect root@localhost
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your password';
This is for the root account, if other accounts also have the same problem, modify to correspond to the username and password, execute the statement
answered Dec 7, 2022 at 5:30
Решение:
1, как показано, подключиться к mysql через cmd
Затем введите: ALTER USER ‘root’ @ ‘localhost’, идентифицированный с помощью mysql_native_password BY ‘password’;
Будьте осторожны, чтобы не потерять одинарные кавычки. #Password — это ваш пароль mysql, обычно root.
Как показано на рисунке, модификация прошла успешно
2. Если cmd не может подключиться к mysql, появляется сообщение «mysql не является внутренней или внешней командой», поскольку системные переменные среды не настроены.
3. Вы также можете запустить MySQL через окно командной строки, которое поставляется с MySQL.
Как показано на рисунке, найдите окно и запустите окно командной строки.
Введите пароль после запуска, как показано на следующем рисунке, указывая, что соединение успешно
Solve SQLyog connection error, Error No.2058 Plugin caching_sha2_password could not be loaded
2 years ago
I was using MySql Server 5.5 and SQLyog to work with databases. Which is my favorite tool to work with MySql database. Cause of some reason I have to upgrade my MySQL Server from 5.5 to version 8 and I have done it. After upgrading I had to face the problem with SQLyog. The problem was when I try to connect with MySQL databases with SQLyog it says plugin caching_sha2_password could not be loaded. I uninstalled it and installed it again… I restart my computer. It doesn’t work. Finally, I search on google and I got the solution.
Problem:
Solution:
The caching_sha2_password and sha256_password authentication plugins provide more secure password encryption than the mysql_native_password plugin, and caching_sha2_password provides better performance than sha256_password. Due to these superior security and performance characteristics of caching_sha2_password, it is as of MySQL 8.0 the preferred authentication plugin, and is also the default authentication plugin rather than mysql_native_password. This change affects both the server and the libmysqlclient client library:
The password encryption rule used by previous versions of MySQL8 is mysql_native_password
The password encryption rule used by MySQL8 is caching_sha2_password
To Solve this problem start MySQL Command Line Client and type the following commands one by one.
1| use mysql 2| ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; 3| FLUSH PRIVILEGES;
10463
Sqlyog configures a new connection and reports an error: the error number is 2058. It is analyzed that the MySQL password encryption method has changed
solution:
alter user ‘root’ @ ‘localhost’ identified with MySQL_ native_ password BY ‘password’; (note the semicolon)
#password is the root password you set yourself
after reconfiguring the connection of sqlyog, the connection is successful and it is OK.
Read More:
Sqlyog database connection error plugin caching_sha2_password could not be loaded
Download the new version MySQL 8.0.11 installation.
To facilitate installation and viewing, I downloaded the sqlyog tool to connect to MySQL
An error is reported when configuring a new connection: the error number is 2058. It is analyzed that the MySQL password encryption method has changed.
Solution: under windows, CMD log in to MySQL – U root – P log in to your MySQL database, and then execute this SQL:
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
#Password is the root password you set yourself