mySQL woes

Help and Support
3

Thank you for the reply.

on server side, or client side?

this command gives me this:

Enter password:
ERROR 1045 (28000): Access denied for user ‘osmc’@‘localhost’ (using password: YES)

this works though:

mysql -u root -p

…

mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| MyVideos99 |
| mysql |
| performance_schema |
±-------------------+
4 rows in set (0.00 sec)

Should I clean my library and configure my advancedsettings.xml file even on the server side like it says here:
http://youresuchageek.blogspot.fr/2012/09/howto-xbmc-share-and-sync-your-media.html

On that website it says:

If you want to re-create it from scratch (my advice), do:

  • In XBMC, Go to Video and delete each source you have previously set, say Yes when XBMC asks if you want to purge these media from your Library
  • Go to Parameters > Video and Clean your Library
  • Configure your mysql settings by editing your advancedsettings.xml (~/.xbmc/userdata/advancedsettings.xml) and adding:

Adapt “xxx.xxx.xxx.xxx” with your main IP Address:

<videodatabase>
    <type>mysql</type>
    <host>xxx.xxx.xxx.xxx</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
</videodatabase> 

<musicdatabase>
    <type>mysql</type>
    <host>xxx.xxx.xxx.xxx</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
</musicdatabase>
  • Restart XBMC
  • Go in Video and re-set your Media Sources using Samba/NFS shares instead of Local paths

This is very important, right now any source you want to add in your Media Library must be done using Samba shares, files paths must use UNC patchs to be able to be shared.

It is getting a bit confusing, but I like challenges. :slight_smile:

Thank you in advance