Redeploy of MySQL service breaks all connections
After redeploying MySQL service (without any changes, i added a new variable) others services start raising this error on connection attempt:
ERROR -- : RSA Encryption not supported - caching_sha2_password plugin was built with GnuTLS support (ActiveRecord::ConnectionNotEstablished)
Solution:Jump to solution
changing MySQL StartCommand to
docker-entrypoint.sh mysqld --innodb-use-native-aio=0 --disable-log-bin --default-authentication-plugin=mysql_native_password
and running SQL:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
seem to have resolved the issue...3 Replies
Project ID:
5a24ad58-38fd-44b0-ac79-47f2f1093c71Project ID: 5a24ad58-38fd-44b0-ac79-47f2f1093c71
Solution
changing MySQL StartCommand to
docker-entrypoint.sh mysqld --innodb-use-native-aio=0 --disable-log-bin --default-authentication-plugin=mysql_native_password
and running SQL:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
seem to have resolved the issue