mysql r00t password reset


Here is a quick and a clean one on Debian installation mySQL version 5.0 sever I did this successfully without necessarily having to soil my hands

sorry no screen shots 😦


from the prompt enter:

root@chimera:~# dpkg-reconfigure mysql-server-5.0

If all goes well you should be prompted to give the new root password


re enter the root password and accept(usually by simply pressing <Enter> )

the mysqld demon will be stopped for and restarted once more and thats all there is 🙂

you should see something like this

root@chimera:~# dpkg-reconfigure mysql-server-5.0
Stopping MySQL database server: mysqld.
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..

finally logging to the database and have nice time:

root@chimera:~# mysql -u root -p
Enter password:*******************

(your password will not be displayed as you type)

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 36
Server version: 5.0.67-0ubuntu6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases ;
| Database           |
| information_schema |
| mysql              |
|                    |
6 rows in set (0.00 sec)

mysql> \q



NB:As you can see “your” tables will not changed at all

by the way if are bored of this local stuff  you may have a look at this


brought to you coutersy of ch!m3ra and JLUG


  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: