Try 'mysqlaccess root localhost' and see if there is a password set in the output.
Try man mysqladmin and set the password there. If you've hosed your perms then stop the damon and restart it with --skip-grant-tables and start again. Remember to do mysqladmin reload or flush privileges from the mysql client. When In doubt try man mysql... Also, once you've got the password working you can save it in /root/.my.cnf so you don't have to type it all the time. Read the man pages carefully since setting the password from the command prompt & mysql client syntax varies. Regards, Justin -----Original Message----- From: castopia [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 2:11 PM To: [EMAIL PROTECTED] Subject: new to mysql, what did I type wrong? 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 --------------------------------------------------------------------- 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
