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 😦

[step1]

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

[step2]

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..
root@chimera:~#

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

Bye

root@chimera:~#

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

===================================================================================================================

Advertisements
  1. No trackbacks yet.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: