Hi there, Restart the mysql server with option "--skip-grant-tables". You can then login without password. And then you reset your password with the update command like this:
UPDATE user SET password='' WHERE user='root'; Restart the server again. Set a new password with mysqladmin like this: mysqladmin -u root password xxx mysqladmin -u root flush-privileges (xxx is your new password) That should be it. Mysql has a nice manual by the way where it is all described detailed, comes in very handy to have such a print close, just in case ;-) Best regards Nils Valentin Tokyo/Japan 2003年 7月 2日 水曜日 14:28、harsh さんは書きました: > You can set password again using root > and mysqladmin command.try mysqladmin --help. > > correct me if i m wrong > > regards > --------------------------------------------------------------------------- >--- harsh > http://www.cse.iitb.ac.in/~harsh > --------------------------------------------------------------------------- >--- > > On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: > > Dear all, > > > > I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL > > password, how can it be retrieved? > > > > Looking forward to hearing from you all. > > > > Regards, > > DT > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]