MySQL database hack password

MySQL database password cracking big secret

RPM packages are installed

Recovery of the database administrator password

First stop the MySQL service,

Service MySQL Stop

Service MySQL start--skip-grant-table then start with skip permission mode background

MySQL executes MySQL enter MySQL and then modifies the password

Mysql>

Use the MySQL database, and then execute the following command:

Change the root user password to 999

Update Mysql.user Set Password=password ("999") where user= "root" and host= "localhost";

mysql> flush Privileges;

Mysql>quit

# service MySQL Stop

# service MySQL Start

Log in again with the new password to enter the MySQL database to verify the successful password modification

#mysql-hlocalhost-uroot-p999

Mysql>

------------------------------------------------------------------

Resetting the database administrator password (operating system administration has permissions)

# mysqladmin-hlocalhost-uroot-p Password "Tarena"

Enter Password: old password

Source package installed database crack password

First stop the MySQL service:

/etc/init.d/mysqldstop stop MySQL

Ps-ef |grep mysql Check if MySQL is off

And then start the background with skip permission mode.

/usr/local/mysql/bin/mysqld_safe--skip-grant-tables--user=mysql &

/usr/local/mysql/bin/mysql into MySQL

or perform a MySQL enter to enter MySQL, and then change the password.

To modify the MySQL password:

Use the MySQL database, and then execute the following command:

Change the root user password to 123

Update user set Password=password (' 123 ') where user= ' root ';

When you're done, stop MySQL and start again in the normal way

/etc/init.d/mysqldstop stop MySQL

/etc/init.d/mysqldstart start MySQL

Log in again with the new password to enter the MySQL database to verify the successful password modification

/usr/local/mysql/bin/mysql-uroot–p123

MySQL database hack password