Win MySQL Shared database setting up problem
I'm trying to setup a MySQL database following this guide

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= 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;


| host | user |
| % | root |
| % | xbmc |
| | 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 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).

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.