[Opensim-users] MySQL problems

[Paul Fishwick]

Matt asked about how I set up MySQL and the version.
I seem to be using: 5.0.67-community-nt according to my
implementation using the Administrator log in via Windows
XP.

As to the instructions on:

http://opensimulator.org/wiki/Mysql-config

They are confusing because of the caveats, warnings, and "notes"
in boldface.

Can someone confirm what exactly is required to create the appropriate
MySQL database?  There are some steps at the top of the web page
I  just referenced:

1. Create a database for OpenSim to user.

    how? Is "mysql -u root -p" and then "create database opensim" 
sufficient?

2. Import the table structure (which according to the boldface comment, is
    no longer required).

3. Edit bin/mysql_connection.ini.   There is no file by that name, but 
there is one
    called bin/mssql_connectionexample.ini. Should I rename that one?
    The instructions say "put in connection information". What does this 
mean?

4. Edit bin/Opensim.ini and setup the mysql-connector. The example is a dump
    of the file, but what exactly needs to change or be added to "set up the
    mysql-connector" ?

5. I tried the GRANT ALL PRIVILEGES command and it was bad syntax,
    apparently. Is this a necessary command?

Sorry for all of the questions - I am just finding this web page to be 
confusing.

p

 
Web: http://www.cise.ufl.edu/~fishwick