[SOLVED] Setting up MySQL

[Djawid Hnian]

Hi folks,

So I recently bought the Pi 2 and I love it so far. After months of using OpenELEC on my previous old Pi B, I decided to give Xbian a shot now my Linux knowledge is a bit improved. I also want to setup a MySQL databse on the Pi 2 so all my devices with Kodi are in sync with their watch status and resuming a paused video from one location to another.

I used the following command to install MySQL:

Code:

sudo apt-get install mysql-server

After that I did the following steps to set it up:

Code:

sudo nano /etc/mysql/my.cnf

Changed bind-address = 127.0.0.1 to bind-address = 0.0.0.0

Restarted the server with

Code:

sudo /etc/init.d/mysql restart

The following commands after restart:

Code:

mysql -u root -p

Code:

CREATE USER 'kodi' IDENTIFIED BY 'kodi';

Code:

GRANT ALL ON *.* TO 'kodi';

Code:

\q

Then I made the advancedsettings.xml. Here it is: http://pastebin.com/JSsM4pm7
I imported some movies and tvshows using NFS and the standard scrapers (The TVDB and The Movie Databse)

I put the advancedsettings file in the right folder on my laptop running Windows 8.1. This is the log file I get: http://pastebin.com/3G27bFv6
Despite I don't see any errors in the log file, Kodi doesn't show my library which is on Xbian.

I'm really lost. When I did the following on my Desktop running Linux Mint 17, it worked. So there must be a problem with Xbian. What's also is strange is that when I add the advancedsettings.xml on the right .kodi folder in Xbian and I scrape my Videos, then nothing happens. Kodi doesn't scrape anything. When I remove advancedsettings.xml from Xbian, I get my library back.

I hope someone can help me to fix this. I would really appreciate it!