Newbie question. I keep receiving various forms of the message:
'frodo.norian.net' is not allowed to connect to this MySQL server
frodo.norian.net (192.168.2.10) is my development machine on my internal net
(192.168.2.x). MySQL resides on gollum.norian.net (192.168.2.11). I can
telnet to 192.168.2.11:3306 but I receive the message "IHost
'frodo.norian.net' is not allowed to connect to this MySQL server." I have
checked the permissions as best as I know how by reviewing the data in the
tables and running the mysqlaccess script -- everything appears to be in
working order.
What does the host column of your db table look like? This is the mysql
system table. This table lists hosts that are allowed to connect to a
given database as a given user. The default is localhost. If you insert
a row that is is identical to the row which allows access for "localhost"
but list the hostname of frodo.norian.net then it should work. The only
reason it shouldn't work is if nslookup can't resolve the name. If you
want a quick and dirty hack, just replace the localhost with %, but then
this allows any machine to try to authenticate... probably not what you
want but it can be useful for testing.
http://www.spinweb.net/hosting/developer_account.html
2 messages in com.mysql.lists.javaRe: "xxx is not allowed to connect to...