[Opensim-users] Ubuntu 19.10 upgrade broke my mysql access to opensimulator

[Teravus Ovares]

I have also dealt with this with work phone systems.   The trick is
changing the authentication method for your users on your mysql server.
 The new versions of mysql use sha2 by default.  Old plugins don't support
it.   That said, you can switch back to the old authentication method
per-user in mysql with a command

On Sat, Dec 7, 2019 at 9:10 PM Dahlia Trimble <dahliatrimble at gmail.com>
wrote:

> I don't think the mysql connector is compatible with mysql 8. I had the
> same problem and I had to use 5.7.27
>
> On Sat, Dec 7, 2019 at 7:19 PM Clint Ellis <rcellis at protonmail.com> wrote:
>
> > I am getting an error complaining that
> > "MySql.Data.MySqlClient.MySqlException: Authentication method
> > 'caching_sha2_password' not supported by any of the available plugins"
> > Running MySQL 8.0, and Opensim 0.9.0 as well as OpenSim 0.9.1.  Both
> throw
> > the same error.
> > Any ideas what is going on?
> >
> > RC
> > _______________________________________________
> > Opensim-users mailing list
> > Opensim-users at opensimulator.org
> > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
> >
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>