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 record for user root and your host. See: http://dev.mysql.com/doc/mysql/en/access-denied.html http://dev.mysql.com/doc/mysql/en/privileges.html fredrich <[EMAIL PROTECTED]> wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]