IP should work just fine. However, if the source webserver is behind a firewall or otherwise NAT'd, your mysql server may see them coming from an in between IP instead of the actual webserver. The quickest way to figure it out is to have the webserver host try to connect and send you the error message. Typically it will read something like: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES).
That host in the error message should match with your settings in the database. Brian Stanton DBA, Belo 214-977-4087 -----Original Message----- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 2:34 PM To: mysql@lists.mysql.com Subject: Host denied errors Little confused, can not seem to locate the docs on this. Trying to set up mysql to allow a remote webserver to talk to it, using a user/pass/host setting with host set to allow anything, of course works. If the IP I am connecting from has a valid PTR, I can use the hostname as well, and that works. In this one case, I do not have the ability to get the client to get a PTR set up on the IP I want to connect from. I tried putting in the IP address, and it still blocks it, can someone tell me how mysql authenticates this data? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
