Re: error on restting password - with some addition

2005-02-11 Thread fredrich
yeah, after long time, thanks for answering. at least i can reset password. 1. i continue what i did but set password to ''(it doestn work if you set to other password). and restart server normally(not with skip-grant-tables). i can login to server. and set root password. thanks fred. --- Gl

Re: error on restting password - with some addition

2005-02-11 Thread Gleb Paharenko
Hello. >mysql stop automatically, and in process tab on task > manager there is no any process name mysqld*. You may find errors in the error log. See: http://dev.mysql.com/doc/mysql/en/error-log.html > my next question is can we address this problem by > installing 4.1.9. and/or del

Re: error on restting password

2005-02-11 Thread Gleb Paharenko
Hello. The entity of the user in MySQL consists of two parts: the user name and the host from which user connects to MySQL server (can be a '%" - it means any host). Look like your user table doesn't have an entry for user 'root'@'host_from_you_are_connecting'. You should manually add the