Password

  • : Function ereg() is deprecated in /home/sparxsys_linux/www.linuxindya.com/includes/file.inc on line 647.
  • : Function ereg() is deprecated in /home/sparxsys_linux/www.linuxindya.com/includes/file.inc on line 647.
  • : Function ereg() is deprecated in /home/sparxsys_linux/www.linuxindya.com/includes/file.inc on line 647.
  • : Function ereg() is deprecated in /home/sparxsys_linux/www.linuxindya.com/includes/file.inc on line 647.
  • : Function ereg() is deprecated in /home/sparxsys_linux/www.linuxindya.com/includes/file.inc on line 647.
  • : Function ereg() is deprecated in /home/sparxsys_linux/www.linuxindya.com/includes/file.inc on line 647.
  • warning: Creating default object from empty value in /home/sparxsys_linux/www.linuxindya.com/modules/taxonomy/taxonomy.module on line 1388.
  • : preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sparxsys_linux/www.linuxindya.com/includes/unicode.inc on line 311.
  • : preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sparxsys_linux/www.linuxindya.com/includes/unicode.inc on line 311.
  • : preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sparxsys_linux/www.linuxindya.com/includes/unicode.inc on line 311.
  • : preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/sparxsys_linux/www.linuxindya.com/includes/unicode.inc on line 311.

How to Recover Root Password

As Linux geeks, we have a responsibility to set a good example and avoid easy passwords. However, if you have to change your password frequently, there's a chance that you'll forget it.

Reset forgotten MySQL root password

If you have forgotten your MySQL root password then don't worry. You can reset your lost password. Here is the procedure.

1. Login as root.

2. Kill running MySQL process and stop the MySQL service.

[[email protected] root]# killall mysqld
[[email protected] root]# /usr/libexec/mysqld -Sg --user=root &

3. Restart MySQL server with these parameters

[[email protected] root]# mysqld --skip-grant-tables --user=root

4. Manually set root password in the table "user" of "mysql" database.

[[email protected] root]# mysql

Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 3.23.41
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> USE mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

mysql> UPDATE user
-> SET password=password("newpassword")
-> WHERE user="root";

Query OK, 2 rows affected (0.04 sec)
Rows matched: 2 Changed: 2 Warnings: 0

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

mysql> exit;

[[email protected] root]# killall mysqld

5. Restart MySQL again

[[email protected] root]# /etc/init.d/mysqld start

Now your root password is set and you can now login as root using the password you have just created.

[[email protected] root]# mysql -u root -p
Enter Password: "newpassword"

If you again forget your root password don't worry just check this link again :)

Syndicate content