(2012-03-08 07:52)thrak76 Wrote: I'm getting the error "firewall exception rule not applied" or something like that, when i get done with the initial configuration of MySQL.
I've forwarded the port 3306 in my router, and added an exception for the installer and the TCP/UDP ports in windows firewall.
I go through the user creation in the server and create the databases.
When running the command: SELECT host,user from mysql.user;
I get a return with the ip 127.0.0.1, instead of the machine ip. I'm lost. Should i be pointing the AS.xml to that ip address, or my machine's local ip, as set with the router?
Thats the host where the user is allowed to connect from, in your case, the user will only be allowed to connect from the machine that MySQL is installed on (which kinda defeats the purpose of doing this)
127.0.0.1 = localhost = your network loopback interface
You need to let the user be able to connect from all the machines that will be running XBMC. And each advancedsettings.xml file should have the ip of the server running MySQL. If you are running an instance of XBMC on the same machine as you are running MySQL, on that machine only, you can use either the full ip or the loopback and both will work, provided the MySQL user has been granted permission to connect that way
This can be accomplished by either creating individual host records for the user in MySQL, an IP based wildcard record for the user depending on your local network config (as an example, "192.168.0.%" will allow you to connect from any ip within the 192.168.0 range)
or just set host to "%" which will allow it to connect from any host/ip combo.. simplest way to accomplish this:
GRANT ALL ON *.* TO 'USER'@'%';
Be advised though, the command above gives all rights from all hosts to USER, but unless you have any ecommerce websites running on that same MySQL DB you should be fine