2012-04-05, 17:57
(2012-04-05, 16:39)thothom Wrote: Now I get this error:
Code:Host 'thomthom.my modem.my gateway' is not allowed to connect to this MySQL server.
In your my.cnf ensure you have
skip-name-resolve
On the mysql command line enter
grant all on *.* to 'xbmc'@'%';
Assuming the user is 'xbmc'
(2012-04-05, 16:14)thothom Wrote:Code:If the user only has permission to connect from PC1, you cant use the same settings to connect from PC2
Could you elaborate on that a little further?
MySQL has the ability to limit access based on hostname, ip address etc. Each record in the mysql.user table corresponds to what user can connect from what network address.
The MySQL wildcard character is "%"
If there is only one record in mysql.user that says the host is 192.168.0.10 (for example) that means connections are accepted from just that one ip address. If it says 127.0.0.1 that means only connections from the actual host MySQL is running on (localhost) are accepted. If the record says 192.168.0.% that means any ip beginning with 192.168.0 can connect. If the host is set just to "%" then it can connect from anywhere
You can check this by issuing the following at the mysql command prompt
select user, host from mysql.user;
Makes sense?