[rescue] MySQL question

[Paul Nguyen]

Here is the excerpt from mysql manual

A.4.2 How to Reset a Forgotten Password

If you have forgotten the root user password for MySQL, you can restore it with the following procedure: 

Take down the mysqld server by sending a kill (not kill -9) to the mysqld server. The pid is stored in a .pid file, which is normally in the MySQL database directory: 
kill `cat /mysql-data-directory/hostname.pid`

You must be either the Unix root user or the same user the server runs as to do this. 
Restart mysqld with the --skip-grant-tables option. 
Connect to the mysqld server with mysql -h hostname mysql and change the password with a GRANT command. See section 4.3.1 GRANT and REVOKE Syntax. You can also do this with mysqladmin -h hostname -u user password 'new password' 
Load the privilege tables with: mysqladmin -h hostname flush-privileges or with the SQL command FLUSH PRIVILEGES. 
Note that after you started mysqld with --skip-grant-tables, any usage of GRANT commands will give you an Unknown command error until you have executed FLUSH PRIVILEGES. 


Bill Bradford <mrbill at mrbill.net> wrote:

>Anybody know how to reset the root user's password in MySQL?
>
>Bill
>
>-- 
>Bill Bradford
>mrbill at mrbill.net
>Austin, TX
>_______________________________________________
>rescue maillist  -  rescue at sunhelp.org
>http://www.sunhelp.org/mailman/listinfo/rescue
>


__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop at Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/