Working with a Percona consultant to help with our migration from community versions of MySQL 5.6 to MySQL 8.0. We’re running on CentOS 7.9. One of our goals is to get some comparison metrics. To that end, here is what we’ve done: created test instances of MySQL 5.6 and MySQL 8.0 both instances…

Hi, the problem is not related to 5.6. It is 8.0 new authentication plugin. Make sure you upgrade client libraries and try again.

Also make sure you configure my.cnf in mysql 8 to include: default-authentication-plugin=mysql_native_password As by default mysql 8 tries to use SSL connections.

@Ivan_Groenewold I am using mysql8.0.34 and all client libraries are latest i.e. 8.0.34 but after moving from mysql_native_password to cashing_sha2_password all is good except percona tool kit utilities like pt-kill, pt-archiver etc are not working getting below error message - DBI connect(‘;host=1…

Issue running pt-upgrade against MySQL 5.6 and MySQL 8.0

Polyglot Projects Percona Toolkit

zafermalik October 25, 2023, 3:35pm 5

After upgrading perl-DBD-mysql version from 4.023 (which is officially latest updated version compatible with centos7) to 4.050 it is working fine.

Topic		Replies	Views
Pt-kill is not working after moving from mysql_native_password to cashing_sha2_password MariaDB Server & Utilities percona	5	1215	October 25, 2023
mysql shell can't connect to local Percona Server 5.7 Other MySQL® Questions	2	1885	January 24, 2022
in-place upgrade from stock mysql 5.5 to Percona Server 5.6 Percona Server for MySQL 5.6	1	1961	November 18, 2013
perl-DBD-MySQL-4.050-4 Breaking mysql_old_password Connections Percona Toolkit	1	1354	December 15, 2021
Percona Toolkit 3.6.0 Usage Issue with MySQL Client 9.0 on Mac OS Sonoma Percona Toolkit mysql , percona	1	267	December 7, 2024

Issue running pt-upgrade against MySQL 5.6 and MySQL 8.0

Related topics