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 25, 2021 03:15AM

Ah!

Well 2 things, first I noticed its MariaDB locally, that must have come with XAMPP, and also it was set already?

C:\Users\bill>mysql -uroot -p
Enter password: **************
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.4.18-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> SELECT plugin from mysql.user where User='root';
+-----------------------+
| plugin |
+-----------------------+
| mysql_native_password |
| |
| |
+-----------------------+
3 rows in set (0.21 sec)

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 25, 2021 03:15AM


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.