42
edits
Changes
From Amahi Wiki
Added mysql usage with xbmc
mv /boot/initramfs-$(uname -r).img /boot/initramfs-$(uname -r)-nouveau.img
dracut /boot/initramfs-$(uname -r).img $(uname -r)
=== Setup XBMC to use MySQL ===
'''Note''' Before using this create an export of the all the media you have imported/scanned/etc. We'll be importing it when we're done.
First we need to create a user and 2 databases which will hold the indexed media (video and music):
Log into the MySQL core using the root account (it will ask you for the password)
{{Code|mysql -uroot -p}}
Create the user "xbmc"
{{Code|CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';}}
Create the databases "xbmc_video" and "xbmc_music"
{{Code|CREATE database xbmc_video;
CREATE database xbmc_music;}}
Grant the user "xbmc" access to these databases
{{Code|GRANT ALL ON xbmc_music.* TO 'xbmc'@'localhost' identified by 'xbmc';
GRANT ALL ON xbmc_video.* TO 'xbmc'@'localhost' identified by 'xbmc';}}
Make sure the MySQL knows the changes made
{{Code|flush privileges;}}
Now to have XMBC make use of the MySQL databases:
{{Code|cat > /home/xbmcuser/.xbmc/userdata/advancedsettings.xml << 'EOF'
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>
EOF}}
Done! Restart XBMC to enable the new settings.
Import the media export you have made before implementing this.
=== Setup autologin for the xbmcuser ===
