MySQL ODBC Connector - reset lost root password

Author

reset lost root password

Dustin Krysak

2005-11-25, 8:23 pm

IS there a way to reset a lost mysql root password?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

SGreen@unimin.com

2005-11-25, 8:23 pm

--=_alternative 007F9C81852570C4_=
Content-Type: text/plain; charset="US-ASCII"

Dustin Krysak < mailinglists@backbon
etechnology.com> wrote on 11/25/2005
05:28:12 PM:

> IS there a way to reset a lost mysql root password?
>
>

You obvously didn't research the issue very well. Next time search the
archives and the manual (it also has a search function):
http://dev.mysql.com/doc/refman/4.1...ermissions.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 007F9C81852570C4_=--

inferno

2005-11-26, 7:23 am

-------------- 07080403000101010002
0300
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Here is a tutorial:

=====>
/*1. Kill the mysqld that may be running (not with -9):

kill `cat /var/lib/mysql/hostname.pid`

2. Restart MySQL in safe mode:

/usr/bin/safe_mysqld --skip-grant-tables&

3. Connect to MySQL:

/usr/bin/mysql

4. Use the mysql database:

use mysql;

5. Run the update command putting your new password where the ....'s
are. Yes this is all one command:

update user set password = password('.......') where user = 'root' and
host='localhost';

6. Flush the privileges so everything will take:

flush privileges;

7. Then quit mysql:

quit

8. Stop mysql from command line with:

/etc/init.d/mysql stop

9. Restart mysql from command line with:

/etc/init.d/mysql start */
<=====

Best regards and have a nice week-end,
Cristi
Dustin Krysak wrote:

> IS there a way to reset a lost mysql root password?
>
>
>
>
>

-------------- 07080403000101010002
0300--

Sponsored Links