update user set Password = PASSWORD('mypassword') where User = 'myuserid';http://www.mysql.com/doc/P/a/Passwords.html C:ya -----Original Message----- From: Yuxia Li [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 4:54 PM To: [EMAIL PROTECTED] Subject: Change password Hi: The administor created a mysql database "library" for me at my home directry. He didn't set a password for me. I don't know how to set my password for my database. I tried using: ->mysql library mysql -> set PASSWORD=PASSWORD('mypassword'); in the command but it didn't work. I need a help!! Thank you. Helen --------------------------------------------------------------------- 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
