[Opensim-dev] MySQL 8.0 Anyone?

[Jeff Kelley]

At 1:08 PM -0700 3/30/22, Mike Higgins wrote:

>Has anyone else run OpenSim on MySQL 8.0 on Linux? Do they play well together?

Make sure that

    default-authentication-plugin = mysql_native_password

is in the configuration files chain. Chek it with

mysql> SHOW VARIABLES LIKE '%authentication%';
+-------------------------------+-----------------------+
| Variable_name                 | Value                 |
+-------------------------------+-----------------------+
| authentication_policy         | *,,                   |
| default_authentication_plugin | mysql_native_password |
+-------------------------------+-----------------------+
2 rows in set (0.01 sec)


I had a Debian update that broke the configuration chain ( /etc/mysql 
my.cnf aliased to /etc/alternatives/my.cnf, itself pointing back to 
mariadb.cnf).


-- Jeff