MySQL 8 Configuration

Edit the MySql configuration file:

Ubuntu

/etc/mysql/mysql.conf.d/mysqld.cnf

Windows

Coming Soon

Add

#Changes for OpensimSim
default-authentication-plugin=mysql_native_password

Save the file

Restart the MySql Service

Create A User for OpenSimulator

Even though MySql is now set to use Native Password by default, it is still necessary to set up a MySQL user that identifies using native passwords.

Open the MySQL command line application.

Ubuntu - Default

sudo mysql

Windows and non root Ubuntu configurations

mysql -u root -p

Create a user

CREATE USER 'DatabaseUserName'@'localhost'IDENTIFIED WITH mysql_native_password BY 'DatabaseUserPassword';

Replace the bold italic text with your details.

Create A database that uses the new user

CREATE DATABASE DatabaseName; GRANT ALL PRIVILEGES ON DatabaseName TO 'DatabaseUser'@'localhost';

DatabaseName and Database user should be substituted for the values created above. Replace the bold italic text with your details.