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
