Hello,
I have this error since many months, it started when I switched to MySQL 8 instead of MariaDB. MariaDB is not working for my databases anymore, I has to use MySQL 8. I am running daily backups to FTP and local with cronjobs. And I get this error when the backupjob runs automatically:
Protocol mismatch; server version = 11, client version = 10 when trying to connect
This is the logfile:
`|-Start backup[2024-01-17 00:24:02]
|-Backup database:database001
|-Database size: 2.71 GB
|-Database character set: utf8mb4
|-Partition / available disk space is: 98.56 GB, available Inode is: 18757563
|-Start exporting database: 2024-01-17 00:24:02
|-Error:Database export failed!
|-mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 2007: Protocol mismatch; server version = 11, client version = 10 when trying to connect
`
When I manually run this backup cronjob, it works without any error. This is the logfile:
`|-Start backup[2024-01-17 20:20:18]
|-Backup database:database001
|-Database size: 2.71 GB
|-Database character set: utf8mb4
|-Partition / available disk space is: 114.10 GB, available Inode is: 18744007
|-Start exporting database: 2024-01-17 20:20:18
|-Compression completed, took 61.05 seconds, compressed package size: 185.78 MB
|-Database has been backed up to: /www/backup/database/db_wp01_host600_com_20240117_202018.sql.gz
|-Keep the latest number of backups: 1 copies
|-----------------------------------------------------------------------------------------
|-Backup completed[2024-01-17 20:21:20]`
aaPanel Version LinuxStable 6.8.33 (uptodate)
MySQL 8.0.34
MySQL port 33066
Type of cron task: "backup site" or "backup database"
root .my.cnf file:
[client]
socket=/tmp/mysqlx.sock
user=root
password="password1234"
Please help, as backups are very important in production environment. Thank you.