Changes

From Amahi Wiki
Jump to: navigation, search
42 bytes removed ,  02:27, 1 February 2019
Log into the MySQL core using the root account (it will ask you for the password, which is "hda" in Amahi 7)
{{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|<pre>cat > /home/xbmcuser/.xbmc/userdata/advancedsettings.xml << 'EOF'
<advancedsettings>
<videodatabase>
</musicdatabase>
</advancedsettings>
EOF}}</pre>
Done! Restart XBMC to enable the new settings.
1. SSH into the server or via Terminal and create a MySQL user and database (this will be the user for the XBMC installations)
{{Code| hda-create-user-and-db xbmc}}
<!--1. SSH into the server or via Terminal and access the MySQL environment in order to create a user (this will be the user for the XBMC installations)
2.1 Open the OpenELEC SMB Share "Userdata" and in it create a file called "advancedsettings.xml" (or edit it if it's already created; DO NOT delete the content already written in it, just add the following code). The following needs to be entered (replace 'x.x.x.x' with the IP of the HDA):
{{Code|<pre>
Code = <advancedsettings>
<videodatabase>
</musicdatabase>
</advancedsettings>
}}</pre>
2.2 Save the file.
12,424

edits