Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote on 12/17/2005 02:12:38 PM:
> I'm trying to access a database over my local network. > > On the server, I had applied the following commands: > > shell > mysql -u root -p > mysql> GRANT ALL on mydb.* To 'snotface'@'otherhost.mydomain' IDENTIFIED BY > 'novice'; > > From the otherhost.mydomain, I try a: > > shell> mysql -h [EMAIL PROTECTED] -u snotface -p > Password: novice > ERROR 1045 (28000): Access denied for user > 'snotface'@'otherhost.mydomain' (using password: YES) > > I'm running MySQL version 4.1.8 on the server. and > Ver 14.7 Distrib 4.1.11, for redhat-linux-gnu (i386) on the client. > > Why? > > -- > Jørn Dahl-Stamnes > homepage: http://www.dahl-stamnes.net/dahls/ > I think the most likely culprit will be an unexpected reverse DNS result. Here are the other likely reasons to get an access denied error: http://dev.mysql.com/doc/refman/4.1/en/access-denied.html To the server, does the machine you are trying to login from reverse DNS to 'otherhost.mydomain' or some other address? Was the server started with --skip-name-resolve option? If it was, during your login attempt the server will be trying to validate your IP address (what it sees) against your DNS name (what's in the permissions tables). Shawn Green Database Administrator Unimin Corporation - Spruce Pine
