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
-9) to the
mysqld server. The pid is stored in a
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.
mysqld with the
Connect to the mysqld server with
mysql -h hostname mysql and change
the password with a
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