Creating Databases For Opensimulator

Creating Databases For Opensimulator is a guide to develop databases for Opensimulator. It is part of an extensive guide into Opensimulator.

Full Guide

Pre-Requisites

This article assumes that a server is already set up and has installed one of the following three database engines.

  • MySQL
  • MariaDB
  • PostgreSQL

Additionally, it assumes that the user and authentication for Opensimulator are present and correct. Finally, links to articles describing how to set up the database engines are available at the bottom of the page. Like previous articles in this series, each section has two examples. One is a generic version where values inside double asterisks need substituting. The second is a specific example that uses hypothetical substitute values.

MySQL – Creating Databases For Opensimulator

Access MySQL

Linux Users

sudo mysql

Windows Users / Linux users without sudo access to MySql

mysql -u root -p

Next, use repeating variations of the example below for each database.

CREATE DATABASE **DatabaseName**;
GRANT ALL PRIVILEGES ON DatabaseName.* TO 'DatabaseUser'@'localhost' WITH GRANT OPTION;
CREATE DATABASE Simulator00;
GRANT ALL PRIVILEGES ON Simulator00.* TO 'simulator'@'localhost' WITH GRANT OPTION;

After creating all the databases and granting permission to the user, flush the privileges and quit.

FLUSH PRIVILEGES;
quit

MariaDB – Creating Databases For Opensimulator

Access MariaDB using.

Linux Users

sudo mariadb

Windows Users

mariadb.exe -u root -p

Next, create the databases by repeating the following differentiating the database name each time.

CREATE DATABASE **DatabaseName**;
GRANT ALL PRIVILEGES ON DatabaseName.* TO 'DatabaseUser'@'localhost' WITH GRANT OPTION;
CREATE DATABASE Simulator00;
GRANT ALL PRIVILEGES ON Simulator00.* TO 'simulator'@'localhost' WITH GRANT OPTION;

Finally, flush the privileges and exit.

FLUSH PRIVILEGES;
exit

PostgreSQL – Creating Databases For Opensimulator

Access PostgreSQL with

Linux Users

sudo -u postgres psql

Subsequently, use repeating variations of the following

Windows

Coming soon

createdb **Database Name**;
GRANT ALL PRIVILEGES ON DATABASE "**Database Name**" to **Database User Name**;
createdb Simulator00;
GRANT ALL PRIVILEGES ON DATABASE "Simulator00" to opensim;

Thank you for reading; further reading is available below. This article is part of a whole series on setting up and maintaining Opensimulator. It is still being written so, please keep checking back for updates.

Related Post

Leave a Reply

Your email address will not be published. Required fields are marked *