Re: Common simple settings wiki should include storage_plugin and storage_connection_string setting in OpenSim.ini

$ mysql -u root -p
Enter password: *******
mysql> use osim;
mysql> show tables;
+----------------------------+
| Tables_in_osim             |
+----------------------------+
| Avatars                    |
| Friends                    |
| GridUser                   |
| UserAccounts               |
| assets                     |
| auth                       |
| estate_groups              |
| estate_managers            |
| estate_map                 |
| estate_settings            |
| estate_users               |
| estateban                  |
| inventoryfolders           |
| inventoryitems             |
| land                       |
| landaccesslist             |
| migrations                 |
| primitems                  |
| prims                      |
| primshapes                 |
| regionban                  |
| regions                    |
| regionsettings             |
| regionwindlight            |
| terrain                    |
| tokens                     |
+----------------------------+

    ; ##
    ; ## PRIM STORAGE
    ; ##    ; *** Prim Storage - only leave one storage_plugin uncommented ***
    ; --- Null stores nothing - effectively disabling persistence:
    ;storage_plugin = "OpenSim.Data.Null.dll"    ; --- To use sqlite as region storage:
    ;
    ; PLEASE NOTE: Unfortunately, the current SQLite database plugin (necessary to use SQLite with Mono on Linux) is
    ; not compatible with the sqlite3 library installed on Mac OSX.  If you're using Mono 2.4 you can still use the old sqlite
    ; library by uncommenting the SQLiteLegacy.dll storage plugin (and commenting out SQLite.dll).  Unfortunately, the older library
    ; will not work with Mono 2.6 on Mac OSX so you will either need to replace the OSX sqlite3 system library or use MySQL instead
    ;
    ; You will also need to do the same thing in config-include/StandaloneCommon.ini if you are running in standalone mode
    ;storage_plugin = "OpenSim.Data.SQLite.dll"
    ;storage_plugin = "OpenSim.Data.SQLiteLegacy.dll"
    ;storage_connection_string="URI=file:OpenSim.db,version=3";

    ; --- To use MySQL storage, supply your own connection string (this is only an example):
    ;     note that the supplied account needs create privilegies if you want it to auto-create needed tables.
    ;
    ; -->>> There are multiple connection strings defined in several places. Check it carefully!
    ;
    storage_plugin="OpenSim.Data.MySQL.dll"
    storage_connection_string="Data Source=localhost;Database=osim;User ID=your_db_id;Password=your_db_password;"
    ; If you want to use a different database/server for estate data, then
    ; uncomment and change this connect string. Defaults to the above if not set
    ; estate_connection_string="Data Source=localhost;Database=opensim;User ID=opensim;Password=*****;";

[DatabaseService]
    ;
    ; ### Choose the DB
    ;

    ; SQLite
    ;Include-Storage = "config-include/storage/SQLiteStandalone.ini";

    ; Unfortunately the current SQLite database plugin is not compatible with Mac OSX.  You can still use the older
    ; legacy sqlite library if you are using Mono 2.4.  Please see the notes in OpenSim.ini (search for sqlite)
    ; for more details
    ;Include-Storage = "config-include/storage/SQLiteLegacyStandalone.ini";

    ; MySql
    ; Uncomment these lines if you want to use mysql storage
    ; Change the connection string to your db details
    StorageProvider = "OpenSim.Data.MySQL.dll"
    ConnectionString = "Data Source=localhost;Database=osim;User ID=your_db_id;Password=your_db_password;"
..................
..................
[GridService]
    ;; For in-memory region storage (default)
    ;  StorageProvider = "OpenSim.Data.Null.dll:NullRegionData"
    ;;--- For MySql region storage (alternative)
    StorageProvider = "OpenSim.Data.MySQL.dll:MySqlRegionData"
..................