2012-04-04, 20:55
Aside from firewall, MySQL user also needs permission to connect FROM the host XBMC is running on. If the user only has permission to connect from PC1, you cant use the same settings to connect from PC2
select user, host from mysql.user
will confirm for you if the user has permission to connect from a specific host
In my setup notice the "%" in the host column, which means that the user xbmc is allowed to connect from any host. If I wanted xbmc only to be able to connect from my internal network, the host value would show '192.168.0.%' which would mean any ip address that begins with 192.168.0
+------+-----------+
| user | host |
+------+-----------+
| xbmc | % |
select user, host from mysql.user
will confirm for you if the user has permission to connect from a specific host
In my setup notice the "%" in the host column, which means that the user xbmc is allowed to connect from any host. If I wanted xbmc only to be able to connect from my internal network, the host value would show '192.168.0.%' which would mean any ip address that begins with 192.168.0
+------+-----------+
| user | host |
+------+-----------+
| xbmc | % |