Tutorial: Spinning up Opensim - Installing MySQL (part 3)

<<Previous Section Tutorial Start Next Section>>

In part 3 of this tutorial, we will be installing and configuring MySQL and creating the database to house our Opensim virtual world. At this point, you no longer need to be connected to the Internet.

Step 1 - Install MySQL

Go to the location you downloaded MySQL and run the installer. In my case, mysql-essentials-5.0.51b-win32. Accept all the defaults and the installation will begin. Of course, inform Vista again that it is ok in fact to install something.

Leave the “Configure the MySQL Server now” checked and click “Finished”

Step 2 - Configure MySQL

For me, the MySQL configuration wizard never started, I’m not sure why. To configure MySQL, go to My Programs->MySQL->MySQL Server 5.0->My SQL Server Instance Configuration Wizard. Accept all defaults and make sure to remember the password you pick for root access to MySQL.

Step 3 - Install MySQL GUI Tools

Once MySQL is installed and up and running you can install the GUI tools which we will use to create our Opensim database. Go to the place on your harddrive where you saved the GUI tools download and run the installer. For me this was mysql-gui-tools-5.0.r12-win32.

Step 4 - Login to MySQL Administrator

The next step is to login to the MySQL Administrator so you can create a user and database that the Opensim server will use to store all its data. Go to All Programs->MySQL->MySQL Administrator.

At the login screen type the following:

• Stored Connection: <leave blank>
• Server Host: localhost
• Username: root
• Password: <the password you entered in Step 2>

Step 5 - Create a User

On the left hand nav, select “User Administration”. In the lower right, click “Add new user” button. This will be the user that is used to access the database, not an Opensim user. I used “opensimdbuser”, but you can call it whatever you like (I suggest no spaces or odd chars though). Then pick a password. Click “Apply Changes”.

Step 6 - Create a Database

Back on the left hand nav, select “Catalogs”. Now the mystical part, to create a new database, you have to right click in a blank area below Catalogs in the section labeled “Schemata” and select “Create New Schema”. I called mine “opensimdb”.

Step 7 - Grant the User Access to the Database

The final step is to grant the user full access to the new database (schema). To do this, navigate back to “User Administration” and select the user you created in the lower left hand panel. The user properties will appear to the right. Select the “Schema Privileges” tab. On this tab are all the schemas. Select the “opensimdb”. You will see assigned privileges and available privileges. By clicking the double arrow button “<<” you can quickly assign all privileges to the user.

Make sure to hit “Apply Changes”. It should look something like this:

At this point, the database is ready to use, we just need to configure Opensim to use it.

<<Previous Section Tutorial Start Next Section>>