This is how I installed mysql5 on MBWE to create a centralized library on XBMC. (If you don't know what I mean check the xbmc wiki: HOW-TO:Share_libraries_using_MySQL
First you need to install (if you haven't already) the optware manager as seen in the "optware-software packages" section of this site.
The instructions for white light are in a blue bordered box. Go straight were it says: "Alternatively, run following commands one by one:"
Enter the 8 commands one by one and then enter the following (with putty):
- export PATH=$PATH:/opt/bin:/opt/sbin
- ipkg update
Then you need to install all the ncurses libraries like so:
- ipkg install ncurses-dev
- ipkg install ncursesw
- ipkg install ncursesw-dev
Install mysql5 like so:
- ipkg install mysql5
Start mysql server by entering:
- mysqld_safe —user=root &
(the cursor may seem stuck. If it does just press enter and carry on)
Set a password for mysql (change the words 'your password' - leave the ' marks) like so:
- /opt/bin/mysqladmin -u root password 'your password'
- mysql -u root -p
enter your password
Then enter the following:
- CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
- GRANT ALL ON *.* TO 'xbmc';
- exit
That's all with putty
Now open notepad and copy paste the following:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>*.*.*.*</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>*.*.*.*</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
</advancedsettings>
save this file as: advancedsettings.xml
place this file (advancedsettings.xml) in C:\Users\***\AppData\Roaming\XBMC\userdata\advancedsettings.xml (windows7)
You will need to paste this file in all your xbmc machines (HTPC, atv2, android boxes etc) in the relevant folders
You are pretty much done
Now I would suggest before doing all this to delete xbmc databases from all your xbmc machines. Then after you are done with all of the above, start xbmc and scan your media in the library. Mark your watched stuff.
If everything went well you should have the same library on all your machines!
Some final notes:
This works with XBMC frodo 12.2 and all your machines should run this version
My MBWE (white) firmware is 01.02.14
Current mysql5 version as of this writing: mysql5 - 5.0.88-1
My linux knowledge is very limited if not zero and all the information written here derives from countless hours of googling and trial and error. I don't know if I will be able to answer questions or to troubleshoot, but I am willing to try
Best of luck
