I found this in the meeting log from today's dev meeting: [11:38] Andrew Hellershanks: Yup. Just found the setting in /etc/mysql/mysql.conf.d/mysqld.cnf in the [mysqld] section. [11:38] Andrew Hellershanks: default_authentication_plugin = mysql_native_password
It seemed to work for me so now I'm running Mysql 8 on my Robust server and all looks good so far. ref: http://opensimulator.org/wiki/Chat_log_from_the_meeting_on_2019-12-10 On Tue, Dec 10, 2019 at 12:35 PM Drang Po <drangp...@gmail.com> wrote: > @ Teravus Ovares tera...@gmail.com > " 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" > > what's the command? or a webpage that gives it etc... thanks in advance > > On Sun, Dec 8, 2019 at 1:14 AM Teravus Ovares <tera...@gmail.com> wrote: > > > 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 <dahliatrim...@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 <rcel...@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@opensimulator.org > > > > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > > > > > > > _______________________________________________ > > > Opensim-users mailing list > > > Opensim-users@opensimulator.org > > > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > > > > > _______________________________________________ > > Opensim-users mailing list > > Opensim-users@opensimulator.org > > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > > > > > -- > Kalasiddhi Grid Co-Coordinator > > HG: kalasiddhigrid.com:8002 > Web: http://www.kalasiddhigrid.com > Buddhism in Virtual Reality > > Drang Po > _______________________________________________ > Opensim-users mailing list > Opensim-users@opensimulator.org > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > _______________________________________________ Opensim-users mailing list Opensim-users@opensimulator.org http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users