JJZolx;592763 Wrote: > It's just four lines in server.prefs. > > Here are the default settings in 7.6 for SQLite: > > > Code: -------------------- > > > dbpassword: '' > dbsource: dbi:SQLite:dbname=%s > dbtype: SQLite > dbusername: slimserver > -------------------- > > > > Here is what it looks like when you switch to MysQL, using the SbS > instance of MySQL: > > > Code: -------------------- > > > dbpassword: '' > dbsource: dbi:mysql:hostname=127.0.0.1;port=9092;database=slimserver > dbtype: MySQL > dbusername: slimserver > -------------------- > > > > To change it to use your own instance of MySQL, shut down the server > and edit server.prefs to look something like this (assuming MySQL is > running on the same server and on the standard port 3306): > > > Code: -------------------- > > > dbpassword: mysqluserPassword > dbsource: dbi:mysql:hosname=127.0.0.1;port=3306;database=mydatabasename > dbtype: MySQL > dbusername: mysqluser > -------------------- > > > > You'll should have already created the MySQL user account and the > (empty) database in MySQL and granted the user account the necessary > permissions to read, write and alter the database. > > * The 'dbtype' entry is new to SbS 7.6.0. It's case sensitive. > > ** If you use the web UI to switch to SQLite and then switch back to > MySQL your server.prefs edits will be lost and SbS will be pointing > back again to the SbS instance of MySQL.
Thanks :) Now to figure the create MySQL user account and empty dB and grant the user account permissions stuff, hmm have to check in on my server MySQL to so if it's still up and running I might have turned it off a couple of years ago... -- Mnyb -------------------------------------------------------------------- Main hifi: Touch + CIA PS +MeridianG68J MeridianHD621 MeridianG98DH and assorted amps SiriuS, Classe' Primare and Dynadio speakers, Contour 4 Contour Center, and Contour 1.3SE rear ch. Rel Stadium 3 sub. Bedroom/Office: Boom Kitchen: SB3 + powered Fostex PM0.4 Misc use: Radio (with battery) PLEASE FIX BUG 112 http://bugs.slimdevices.com/show_bug.cgi?id=112 ------------------------------------------------------------------------ Mnyb's Profile: http://forums.slimdevices.com/member.php?userid=4143 View this thread: http://forums.slimdevices.com/showthread.php?t=83448 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
