Hi, I try to change the root password after the first time connecting to mysql server. I followed the tutorial at http://www.mysql.com/articles/mysql_intro.html.
Somehow, I got the error mesage, what did I type wrong? Please help. Thank you. ~ # mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.49 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypass'); ERROR 1133: Can't find any matching row in the user table mysql> set password for 'root'@'localhost' = password('mypass'); ERROR 133 : Can't find any matching row in the user table mysql> --------------------------------------------------------------------- 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