I have just created a root password in MySQL without using the PASSWORD function. In the user table i put in a root password, like this..... mysql> UPDATE user SET Password='new_password' WHERE user='root'; mysql> FLUSH PRIVILEGES; Now i am denied access. How do start the mysql server now? The manual wasnt clear that the password() function should have been used when inserting the password into the table. Please help. Thank you very much. --------------------------------------------------------------------- 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
