Custom Search

Ubuntu mysql reset root password

Perhaps you provided the wrong password? Don't worry, you can reset Ubuntu mysql root password, here's how to do it:

If mysql is running, then you have to stop it first. If you not sure, we can check Ubuntu running services with ps command to check mysql service is there or not.

luzar@ubuntu:~$ ps aux | grep mysqld
root 4078 0.0 0.1 1772 524 ? S 05:19 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 4120 0.0 3.1 127088 16312 ? Sl 05:19 0:02 /usr/sbin/mysqld --basedir
root 4122 0.0 0.1 1700 556 ? S 05:19 0:00 logger -p daemon.err -t
luzar 4885 0.0 0.1 3004 752 pts/0 R+ 09:50 0:00 grep mysqld

If you see mysql service like in the example above, then you need to stop it. All you need from the ps command above is the process id. Look closely at mysql service, and write down that number. Then you can issue the command below:

luzar@ubuntu:~$ sudo kill 4120
luzar@ubuntu:~$ ps aux | grep mysqld
luzar 4891 0.0 0.1 3004 752 pts/0 R+ 09:50 0:00 grep mysqld

We can use the same ps command as before to check that mysql really died. So there is no more mysql service.

There are two ways to reset mysql root password. The first way is by putting a script of mysql command to reset root password in a file. Then run mysqld_safe command with the file.

The second way is by running mysql directly from the shell.

Here is a step by step example of resetting mysql root password with a file:

1) Create a text file in your home directory named mysql-passwd with the content below:

UPDATE mysql.user SET Password=PASSWORD('Password') WHERE User='root';

2) Now you can start mysql with the mysql password file to reset Ubuntu mysql root password. Follow the syntax below but change the password name to yours.

luzar@ubuntu:~$ mysqld_safe --init-file=/home/me/mysql-passwd &

3)After the mysql server successfully started, delete the root password file you in your home directory.

4)You can now login mysql using your new password.

No comments:

Post a Comment

Please keep comment relevant and strictly no spam will be tolerated. Thank you.