Look up skip grants in the manual and in future I recommend the GRANT
command.
----- Original Message -----
From: "harvin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 03, 2001 13:56
Subject: forget password in user table and no other user has access
privilege to mysql database
hi,
i updated the password field using update statement in the command line for
the root user. other users in the table don't have any privilege to access
the mysql database.
when i tried to connect the database i can't able to connect with the new
password. the passord i gave was "kannan1".
what is the problem.
---------------------------------------------------------------------
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