Plugin caching_sha2_password could not be loaded

[chrisgerman]

Getting the following error and yes I'm using MySql 8.0.23 when installing the docker image.

ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded: /usr/lib64/mariadb/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

[chrisgerman]

P.S. I checked the folder and I don't see caching_sha2_password.so but after doing yum update then install. It shows up?

[chrisgerman]

It seems I got it working after doing a yum update and yum upgrade, then manually adding the USER in MySQL with the following commands

USE cacti;
CREATE USER 'cacti'@'%' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'cacti'@'%';
GRANT SELECT ON mysql.time_zone_name TO 'cacti'@'%';
FLUSH PRIVILEGES;

Had to do this because MySql 8 syntax is different.

Then removed the install.lock with rm -f /cacti/install.lock to force another install after restarting the container.

I have a few issues with my database like giving it more and buffer size. I will do that and see what happens.