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