Recently, I did some maintenance on Innotop and I merged several pull requests including one to support MySQL 8.0 (thank you yoku0825 for the contribution).
As you know, Innotop is written in Perl and to be able to use it with MySQL 8.0, you need to have Perl DBD for MySQL compatible with MySQL 8.0 too (a driver that support the new default authentication plugin, caching_sha2_password
).
If you are using Fedora 29, I created such package and you can download it here: perl-DBD-MySQL-4.046-5.mysql8.fc29.x86_64
We can see the difference between the default package and this one.
Old package:
$ ldd /usr/lib64/perl5/vendor_perl/auto/DBD/mysql/mysql.so ... libmariadb.so.3 => /lib64/libmariadb.so.3 (0x00007f08f026d000) ... libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007f08f0033000) libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007f08efd57000) ...
New package:
$ ldd /usr/lib64/perl5/vendor_perl/auto/DBD/mysql/mysql.so ... libmysqlclient.so.21 => /usr/lib64/mysql/libmysqlclient.so.21 (0x00007fa3ad611000) ... libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007fa3ad1ae000) libdl.so.2 => /lib64/libdl.so.2 (0x00007fa3ad1a6000) ...
Now you can use again Innotop with MySQL 8.0 !
Thank you again to all contributors and don’t hesitate to submit your patches.
[…] https://lefred.be/content/innotop-for-mysql-8-0/ […]
[…] https://lefred.be/content/innotop-for-mysql-8-0/ […]