GNU Info

(mysql.info)Resetting permissions

---

Next: Full disk Prev: Crashing Up: Administration Issues

---

Enter node , (file) or (file)node

How to Reset a Forgotten Password
---------------------------------

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

  1. 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.

  2. Restart `mysqld' with the `--skip-grant-tables' option.

  3. Connect to the `mysqld' server with `mysql -h hostname mysql' and
     change the password with a `GRANT' command. Note: `GRANT'.
     You can also do this with `mysqladmin -h hostname -u user password
     'new password''

  4. 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'.