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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php