ERROR 1045 (28000): Plugin sha256_password could not be loaded about slickstack

[corzel]

Hi Jesse,
I'm using 2 vps with Ubuntu 20.04.1 LTS (GNU/Linux 5.4.0-42-generic x86_64). 1 for DB server with Mysql Server version: 8.0.20-0 and 1 for web server with SlickStack.

I just ran ss-install-mysql and error disappeared.

As I said, everything works fine, but I use ss-purge because "I feel" (I didn't do a real test) that clear caches option in wordpress isn't do the job so I do it in terminal.

Btw, it would be useful to have an option to turn off all server caches as in cloudflare developer mode.

If you want me to provide more information about the system, just tell me or if you want to check directly on my server, there is no problem.

[jessuppi]

Hello @corzel I'm not sure what OS you are running but that does not look like Ubuntu.

SlickStack only supports Ubuntu 20.04 LTS with MySQL 8.0 at this time, running other software is at your own risk. If you want to play around with other software that is awesome but please provide more information to the community and maybe as you continue to debug the situation you can post your findings here. Cheers!

[jessuppi]

Sorry, I read over your Issue very quickly. I think this is simply a failed MySQL connection here, due to authentication... an open Issue we are having with the newest MySQL 8.0 builds: #49

Anyway sha256_password and caching_sha2_password are both supported by MySQL 8.0:

https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

...It seems you installed MariaDB instead of MySQL perhaps, so even if your initial setup worked fine, the SlickStack scripts are probably unable to connect to your database based on default script settings:

MariaDB Server does not currently support either the sha256_password or the caching_sha2_password authentication plugins. See MDEV-9804 for more information.

MariaDB Server does not support either of these authentication plugins. This is mainly because:

To use the protocol, one has to distribute the server's public key to all MariaDB users, which can be cumbersome and impractical.
The server gets the password in clear text which can cause problems if the user is convinced to connect to a malicious server.

From here: https://mariadb.com/kb/en/authentication-plugin-sha-256/

The real issue is that the ss-install-mysql SlickStack script is currently broken as far as initial MySQL configuration.

[jessuppi]

Following up on this complicated issue:

We have made several changes in the past few years to make the MySQL installation more straightforward. The biggest change is we now have a new separate script ss-install-mysql-database that creates databases if not exist, creates all the database users and passwords, grants privileges, and etc.

Ref: https://github.com/littlebizzy/slickstack/blob/master/bash/ss-install-mysql-database.txt

This script now supports both Ubuntu 18.04 and Ubuntu 20.04 and going forward, most of our scripts will have support for various Ubuntu LTS releases directly in the code, so that they work cross-OS versions.

We are using caching_sha2_password for Ubuntu 20.04 (MySQL 8.0) machines and mysql_native_password for Ubuntu 18.04 (MySQL 5.7) machines for best compatibility.

These improvements were made more confusing because of some breaking changes that MySQL introduced in the 8.0 version tree that were very poorly documented, so I apologize if I jumped to conclusions here @corzel

We still need to improve the MySQL installation process, it's always been the most difficult module to deal with for me personally and probably will continue to be, due to the finicky nature of MySQL.

[jessuppi]

As I said, everything works fine, but I use ss-purge because "I feel" (I didn't do a real test) that clear caches option in wordpress isn't do the job so I do it in terminal.

Btw, it would be useful to have an option to turn off all server caches as in cloudflare developer mode.

Interesting concept btw, if you can open a new Issue for this it would be great, thanks!