Win MySQL Shared database setting up problem
#1
I'm trying to setup a MySQL database following this guide http://lifehacker.com/5634515/how-to-syn...-the-house

It's probably complicated by the fact that I already have Mediaportal installed on this PC using MySQL but it shouldn't be too hard to workaround.

According to the guide, doing CREATE USER 'xbmc' IDENTIFIED BY 'xbmc'; creates the login/password pair xbmc/xbmc so the password "MediaPortal" I have to use when opening MySQL commandline must be a master password that's not important for what I'm trying to do here.

Anyway, I've created an advancedsettings.xml like so:

Code:
<advancedsettings>
   <videodatabase>
        <type>mysql</type>
        <host>127.0.0.1</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>xbmc_video</name>
   </videodatabase>
   <musicdatabase>
       <type>mysql</type>
       <host>127.0.0.1</host>
       <port>3306</port>
       <user>xbmc</user>
       <pass>xbmc</pass>
       <name>xbmc_music</name>
       </musicdatabase>
</advancedsettings>

and I also had to add bind=0.0.0.0 to my.ini as mysql wasn't showing as listening in Comodo firewall before.

However, both before and after changing the bind=,
SELECT host,user from mysql.user;
and
SHOW DATABASES;

returns

Code:
+-----------+------+
| host | user |
+-----------+------+
| % | root |
| % | xbmc |
| 127.0.0.1 | root |
| localhost | |
| localhost | root |
+-----------+------+
5 rows in set (0.01 sec)

+--------------------+
| Database |
+--------------------+
| information_schema |
| argustv |
| mptvdb |
| mysql |
| test |
| xbmc_music |
| xbmc_video |
+--------------------+
7 rows in set (0.02 sec)

so it looks like only root (the Mediaportal user) has access on 127.0.0.1 and localhost, whilst xbmc is only listed against % (whatever that signifies). Sure enough, I'm unable to scan content to the Library in XBMC with the advancedsettings.xml (without it, the normal XBMC database works fine).
Reply


Messages In This Thread
MySQL Shared database setting up problem - by doveman2 - 2013-02-26, 19:28


Logout Mark Read Team Forum Stats Members Help
MySQL Shared database setting up problem0
This forum uses Lukasz Tkacz MyBB addons.