It is not executed in mysql 8.0.12.

[yuta-hayashi]

When trying to use this tool in Docker's mysql: latest (8.0.12), the error INFO [0000] Can not set time zone to UTC: this authentication plugin is not supported is displayed and can not be executed.

However, it works in Docker's mysql:5.6 case.
Also, in 8.0.12 the query SET @@ session.time_zone = "+00: 00"; could be executed directly.

Of course, the database schema is the same.
What is the cause?

[vchau]

I'm seeing the same issue when i try to use this against mysql 5.6 on AWS RDS

[guriandoro]

This is due to the new 8.0 default for authentication plugin: caching_sha2_password

A workaround is to create a user with old auth plugin:

create user new_user@localhost identified with mysql_native_password by 'secret';
grant ... on *.* to new_user@localhost;

Then use this new user with mysql_random_data_load, and it should work fine.