Yes, it is one of the security feature of MySQL that cause problem. Instead of using IP address, MySQL always perform a reverse DNS lookup and use host name instead.
One of my past painful experience is I add a user with host for 192.168.0.33. However, no matter how hard I tried, I can't connect to MySQL from 192.168.0.33. Finally, I add an entry in the reverse DNS that allow 192.168.0.33 to lookup a host name and the problem solved. Best regards, > one more thing i would like to ask u gurus.... when i have given my host > with an IP address... why is it giving the message " > username@localhost " wherein it should give me as " > username@IPaddress " > > Thanks > Ganesh Rajan > ----- Original Message ----- > From: "Ganesh Rajan" <[EMAIL PROTECTED]> > To: "Diana Soares" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Wednesday, February 19, 2003 10:26 AM > Subject: Re: problem in connecting to DB > > > Thanks for the response.... but as the document states to "RUN mysqladmin > > flush-privileges and mysqladmin reload" .... i tried bothways... but in > vain > > ... i still get the same error message "Error 1045: Access Denied for > > user:(username@localhost) (user password :YES)" > > > > Ganesh Rajan > > ----- Original Message ----- > > From: "Diana Soares" <[EMAIL PROTECTED]> > > To: "Ganesh Rajan" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Tuesday, February 18, 2003 8:59 PM > > Subject: Re: problem in connecting to DB > > > > > > > Everytime you use UPDATE, INSERT, DELETE to update user privileges you > > > must do a FLUSH PRIVILEGES for changes to take effect. > > > Check the manual: > > > http://www.mysql.com/doc/en/Privilege_changes.html > > > > > > > > > On Tue, 2003-02-18 at 11:57, Ganesh Rajan wrote: > > > > hello all, > > > > > > > > i would like to put a problem as what iam facing... i created a new > > database > > > > & new user, but i didn't give the password... > > > > > > > > then i logged in to mysql > > > > ie > > > > c:\mysql\bin> mysql > > > > then > > > > mysql> use mysql > > > > then > > > > mysql>update user set password=password('pswd') where user= > 'username'; > > > > then i got the result as 1row updated. > > > > > > > > then i quit from mysql using mysql>\q.... > > > > now when i want to connect > > > > i.e. > > > > c:\mysql\bin> mysql -u username -ppswd dbname; > > > > > > > > iam getting error stating "Error 1405:Access denied for user: > > > > 'username@localhost ' (user password :YES)' > > > > > > > > IAM WORKING ON COMMANDLINE @ MYSQL SERVER ITSELF > > > > > > > > can someone throw light onthis... it will be of grate help > > > > > > > > Thanks in advance > > > > Ganesh Rajan > > > > > > > > > > > > --------------------------------------------------------------------- > > > > Before posting, please check: > > > > http://www.mysql.com/manual.php (the manual) > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > -- > > > Diana Soares > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <mysql-unsubscribe- [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
