Percona Xtrabackup have some issue with percona mysql 8.0?

MySQL & MariaDB Percona XtraBackup
1

Mysql: mysql Ver 8.0.21-12 for Linux on x86_64 (Percona Server (GPL), Release ‘12’, Revision ‘7ddfdfe’)

Xtarbackup: xtrabackup version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4)

xtrabackup --backup --user=root–password=‘root’ --no-version-check --target-dir=/home/mysqlbkp

201204 17:38:03 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set

Failed to connect to MySQL server: Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory.

mysql -u root -proot … is working well.

2

Hi,

Your issue is because you are using xtrabackup 2.4 to backup an 8.0 server. Please use xtrabackup version 8 and you will be fine.