Hello. >Worst case, do I just uninstall and reinstall mysql?
Don't panic :) My opinion: this situation looks similar to the example described at: http://dev.mysql.com/doc/mysql/en/Connection_access.html May be you have several entries at user table. Can you login using your old password? If no, run mysqld_safe with --skip-grant-tables command line option (with this option everybody can connect to your server so be careful). What output does the following statement produce: use mysql; select user,host from user where user='root'; You can restore your root password using such statement: set password for user 'root'@'your_host'=password('great password'); Than restart server as usual (without --skip-grant-tables). >I am trying to change my root password for mysql 4.1.7 running on Linux (as >I forgot it) using the docs found at: >HYPERLINK >"http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html"http://dev.mys >ql.com/doc/mysql/en/Resetting_permissions.html >When I get to the step: >shell> mysqladmin -u root flush-privileges password "newpwd" > I get the error: >mysqladmin: unable to change password; error: 'Can't find any matching row >in the user table' >think my user table is screwed up but how can I get in to fix it??? >Worst case, do I just uninstall and reinstall mysql? >Thanks, >Don >"Don" <[EMAIL PROTECTED]> wrote: -- 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]
