Creating Databases For Opensimulator is a guide to develop databases for Opensimulator. It is part of an extensive guide into Opensimulator.
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;
Related Articles – Creating Databases For Opensimulator
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.
- Extensible & Maintainable Opensimulator Config
- Setup Ubuntu 20.04 for Opensimulator
- Buying Server Hosting For Opensimulator
- Installing Windows Server Guide
- Installing Ubuntu Server Guide
- Email Calendar & File Sharing
- Buying Remote Storage From Backblaze
- Mounting SSH Folders In Ubuntu
- Mounting SSH Folders In Windows
- Buying A Domain Name & DNS