XBMC and MYSQL help

[getafix33]

Howdy -

I have posted this on the xbmc.org site as well.

Running Gotham 13.1 with the latest MYSQL

created user xbmc with password xbmc and granted permissions to that user.

followed the wiki to the tee as far as I understand

Checking my logs I am getting access permission errors.

Attached is the debug log

https://www.dropbox.com/s/6y9jeuxa8w3gt5d/xbmc.log

 

[patrick123]

you will most probably have to grant privileges to xbmc'@'HOMESERVER in MYSQL.
In theory the % is meant to allow this but the way MYSQL works is that if there are multiple xbmc entries with a non blank HOST the % entry is basically ignored.

 

[AVSupply]

Howdy -

I have posted this on the xbmc.org site as well.

Running Gotham 13.1 with the latest MYSQL

created user xbmc with password xbmc and granted permissions to that user.

followed the wiki to the tee as far as I understand

Checking my logs I am getting access permission errors.

Attached is the debug log

https://www.dropbox.com/s/6y9jeuxa8w3gt5d/xbmc.log

Run the following mysql command

grant all on *.* to 'xbmc'@'%' identified by 'xbmc';

 

[getafix33]

Run the following mysql command

grant all on *.* to 'xbmc'@'%' identified by 'xbmc';

Got a query OK, 0 rows affected (0.00sec)

Is that right?

 

[AVSupply]

Got a query OK, 0 rows affected (0.00sec)

Is that right?

Yes, now start XBMC and see if it creates the database tables

 

[getafix33]

Yes, now start XBMC and see if it creates the database tables

Shot man - seems to have sorted the problem

 

[AVSupply]

Shot man - seems to have sorted the problem

Awesome, glad I could help