Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Feb 062010
 

Reset MySQL root password

Answer:

If you have forgotten the MySQL root password, follow the steps below to reset the root password (for Ubuntu/Debian).

1. Shutdown MySQL

# /etc/init.d/mysql stop

2. Startup MySQL using command without grant tables, take the process to run in background

# /usr/bin/mysqld_safe --skip-grant-tables &

3. Login into the MySQL database

# mysql --user=root mysql

4. Reset password


mysql>update user set Password=PASSWORD('newpassword') WHERE User='root';
Query OK, 2 rows affected (0.03 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql>flush privileges;
Query OK, 0 rows affected (0.02 sec)

5. Shutdown MySQL

Bring the MySQL server process to foreground now and kill it by Ctrl-C

# fg
[Ctrl-C]

6. Start MySQL using normal way

# /etc/init.d/mysql start

That's all.

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>