hi all, i need to reset the root password. i have done 2 things. but not worked.
i read http://dev.mysql.com/doc/mysql/en/resetting-permissions.html and do .. a). i changed my.ini, add a line like "skip-grant-tables" and started mysql. then issue command .. mysqladmin -u root flush-privileges password "mypass" but error : mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' b). i choose alternative way. "update user set password=PASSWORD('mypass') where user='root'; flush privileges;" then restart mysql. the password is changed. but i cannot login when issue "mysql -u root -p". and type mypass SPEC : win 2003 + mysql 4.1.5. on spec : WINxp sp 2 + mysql 4.1.9 it works fine. note : i want to reset password on mysql 4.1.5. any idea for this ? thanks. __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]