!
Hubzilla Support Forum !
Hubzilla DevelopmentI found that #
Hubzilla (and seems a lot of other #
PHP software) have issue with #
MySQL 8. In my case this is a latest release 8.0.12.
According
documentation MySQL changed Preferred Authentication Plugin on new
caching_sha2_password
type. It causes authentication errors like
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client
To avoid this replace authentication scheme for users on
mysql_native_password
by
ALTER USER 'user@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Until software will not be updated to work with the new password schema will be a good idea to leave the old driver on by
adding default_authentication_plugin = mysql_native_password
in
[mysqld]
section of MySQL configuration file.