scline
Plugin caching_sha2_password could not be loaded
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
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?
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.