[Robinast]

Did a clean install of MySQL and fresh Working advancedsettings.xml and that did the trick!
______________________________________________________________________________


Hi, I´v been googleing for hours trying to get help from threads already created, but haven´t found a solution to my issue!
I´m trying to setup a MySQL server on my media server pc (running windows 8.1 24/7 with all my media and whatnot), and I think I´v gotten MySQL running as it should, creating user 'xbmc' and grant all on *-* 'xbmc* etc etc.
I´m running XBMC v13.2 Gotham on the "server pc" (I´v rescand my media on xbmc server pc), v13.2 Gotham as well on a boxee box, and a macbook.
After modifying advancedsettings.xml i´m getting the "Movies" folder and "TV-Shows" folder on startup on xbmc, but it´s unable to connect to the remote server for some reason, which I´m to newb to figure out, so I´m hoping one of you pro´s can help me! I´ll add advancedsettings.xml to code aswell as what i can get from MySQL command line to help you help me!

Advancedsettings.xml :

Code:

<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.2.16</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </videodatabase>
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.2.16</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
<pathsubstitution>
  <substitute>
    <from>special://profile/Thumbnails/</from>
    <to>SMB:\\MEDIA\Users\Robin\AppData\Roaming\XBMC\userdata\Thumbnails/</to>
  </substitute>
</pathsubstitution>
</advancedsettings>

MySQL Command line :

Code:

mysql> select user,host from mysql.user;
+------+-----------+
| user | host      |
+------+-----------+
| xbmc | %         |
| root | 127.0.0.1 |
| root | ::1       |
| root | localhost |
+------+-----------+
4 rows in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mymusic46          |
| mysql              |
| myvideos78         |
| performance_schema |
| sakila             |
| world              |
+--------------------+
7 rows in set (0.00 sec)

+--------------------------------------------------------------------------------------------------------------+
| Grants for xbmc@%                                                                                            |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Connection id:    322
Current database: myvideos78

mysql> Show tables;
+------------------------+
| Tables_in_myvideos78   |
+------------------------+
| actorlinkepisode       |
| actorlinkmovie         |
| actorlinktvshow        |
| actors                 |
| art                    |
| artistlinkmusicvideo   |
| bookmark               |
| country                |
| countrylinkmovie       |
| directorlinkepisode    |
| directorlinkmovie      |
| directorlinkmusicvideo |
| directorlinktvshow     |
| episode                |
| files                  |
| genre                  |
| genrelinkmovie         |
| genrelinkmusicvideo    |
| genrelinktvshow        |
| movie                  |
| movielinktvshow        |
| musicvideo             |
| path                   |
| seasons                |
| sets                   |
| settings               |
| stacktimes             |
| streamdetails          |
| studio                 |
| studiolinkmovie        |
| studiolinkmusicvideo   |
| studiolinktvshow       |
| tag                    |
| taglinks               |
| tvshow                 |
| tvshowlinkpath         |
| version                |
| writerlinkepisode      |
| writerlinkmovie        |
+------------------------+
39 rows in set (0.00 sec)

mysql> show processlist;
+-----+------+-----------------------+------------+---------+------+-------+------------------+
| Id  | User | Host                  | db         | Command | Time | State | Info             |
+-----+------+-----------------------+------------+---------+------+-------+------------------+
| 284 | xbmc | 192.168.2.5:43315     | myvideos78 | Sleep   | 1439 |       | NULL             |
| 323 | xbmc | MACBOOKPRO-DF76:49457 | myvideos78 | Sleep   |   65 |       | NULL             |
| 329 | root | localhost:50026       | NULL       | Query   |    0 | init  | show processlist |
+-----+------+-----------------------+------------+---------+------+-------+------------------+
3 rows in set (0.00 sec)

To add, I´v never used MySQL before, newbie on unix etc, and a swede, so please don´t be to hard on me! If you want more info I´ll be happy to answer any question!