sysbench for MySQL 8.0

Alexey made this amazing tool that the majority of MySQL DBAs are using, but if you use sysbench provided with your GNU/Linux distribution or its repository on you won’t be able to use it with the new default authentication plugin in MySQL 8.0 (caching_sha2_password).

This is because most of the sysbench binaries are compiled with the MySQL 5.7 client library or MariaDB ones. There is an issue on github where Alexey explains this. So if you want to use sysbench with MySQL 8.0 and avoid the message below,
error 2059: Authentication plugin 'caching_sha2_password' cannot be loaded: 
/usr/lib64/mysql/plugin/ cannot open shared object file: 
No such file or directory
you have 3 options:
  1. modify the use to use mysql_native_password as authentication method
  2. compile sysbench linking it to mysql-community-libs-8.0.x (/usr/lib64/mysql/
  3. use the rpm for RHEL7/CentOS7/OL7 available on this post: sysbench-1.0.15-1.el7.centos.x86_64

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

One comment

Leave a Reply to How to Install and Use Sysbench - mortensiCancel Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.