2013-02-26, 19:28
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:
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
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).
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).