Need help again. This time it's with MySQL on windows 10. I have a fair amount of experience with MySQL on Linux and a little with it on windows. I have real problems understanding windows and the workbench program for MySQL. Phpmyadmin is so much simpler to use for me.
My problem is I have V 8.0.13.0 (2018) of MySQL running on my desktop computer and it is working just fine. I a new region running just fine on OSgrid using the built in MySQLlite that comes with opensim but want to use a more robust database than that. The version I installed of MySQL on this system is V 8.0.29.0 (2022). I can't see any difference in my setup between the two systems, but opensim fails with the following error when it tries to access the database. 2022-04-26 16:24:00,252 ERROR [SERVICE BASE]: Failed to load plugin OpenSim.Region.Framework.Interfaces.ISimulationDataStore from OpenSim.Data.MySQL.dll with args Data Source=localhost;Database=osg-romantica;User ID=*****;Password=******;Old Guids=true;SslMode=None; System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: Authentication method 'caching_sha2_password' not supported by any of the available plugins. The configuration line for MySQL in both systems is identical with the exception of the database name. ConnectionString = "Data Source=localhost;Database=osg-romantica;User ID=*****;Password=*****;Old Guids=true;SslMode=None;" I have tried using both the above line with and without the SslMode=None; parameter and it makes no difference. Before I see if installing the older version fixes it I wanted to ask if I'm missing something new in the workbench program that I need to do to define the server and it's parameters. Slow Putzo _______________________________________________ Opensim-users mailing list Opensim-users@opensimulator.org http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
