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