MySQL Forums
Forum List  »  Newbie

Re: MYSQLDUMP on remote Ubuntu from Windows 10 now fails with Got error: 2059: "Authentication plugin 'caching_sha2_password' cannot be loaded:
Posted by: William Damage
Date: June 24, 2021 06:02AM

Its the stock MySQL which came with the Ubuntu 20.04 distro

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 419
Server version: 8.0.25-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Heres what I did on the server:

mysql> CREATE USER 'roottest'@'localhost' IDENTIFIED WITH mysql_native_password BY 'wibble';
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select host, user, plugin from mysql.user where user like 'root%';
+-----------+----------+-----------------------+
| host | user | plugin |
+-----------+----------+-----------------------+
| % | root | mysql_native_password |
| localhost | root | mysql_native_password |
| localhost | roottest | mysql_native_password |
+-----------+----------+-----------------------+

Heres what I did on the WIN 10 PC:

E:\www\joomla\utils>mysql -hexample.com -uroottest -p
Enter password: ******
ERROR 2059 (HY000): Authentication plugin 'sha256_password' cannot be loaded: The specified module could not be found.

Options: ReplyQuote


Subject
Written By
Posted
Re: MYSQLDUMP on remote Ubuntu from Windows 10 now fails with Got error: 2059: "Authentication plugin 'caching_sha2_password' cannot be loaded:
June 24, 2021 06:02AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.