[Subject Prev][Subject Next][Thread Prev][Thread Next][Subject Index][Thread Index]

Re: [LI] MySQL root password recovery.



in case anyone else faces the same problem here is what to do.

shell>killall -v mysqld
shell>mysqld --skip-grant &
shell>mysql

mysql>use mysql;
mysql> update user set password=('....') where user = root;

then restart the mysql server.

Uday Kumar Khatua wrote:

> Hi all.
> I have forgotten my MySQL root password. Could someone guide me to
> recover it?? singleuser does not help.
> regards
> Uk
>
> --------------------------------------------------------------------
> The Linux India Mailing List Archives are now available.  Please search
> the archive at http://lists.linux-india.org/ before posting your question
> to avoid repetition and save bandwidth.

--------------------------------------------------------------------
The Linux India Mailing List Archives are now available.  Please search
the archive at http://lists.linux-india.org/ before posting your question
to avoid repetition and save bandwidth.