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/mysql?unsub=1
--
---
Valentin Nils
Internet Technology
E-Mail: nils@stripped
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
