[Opensim-users] MySQL problems

[Butch Arnold]

Hi Paul,

You no longer need to use the mysql_connection.ini file.
The opensim.ini file contains areas for you to define your connection 
string for mysql and the UGAIM servers also have their own mysql config 
strings.
To learn more about the mysql syntax for adding a user... here's a few 
examples.....

http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

-Butch


Paul Fishwick wrote:
> 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
>
>   
>