Shulou(Shulou.com)05/31 Report--

This article mainly explains the "introduction of the method of cracking the root password of the MySQL database". The content of the explanation in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought slowly and deeply, and study and learn "the introduction of the method of cracking the root password of the MySQL database".

Several ways to crack the mysql root password:

Method one

It's easiest to use myadmin. Modify the user table of the mysql library, but don't forget to use the PASSWORD function.

Method two

Using mysqladmin, this is a special case of the previous declaration.

Mysqladmin-u root-p password mypasswd

After entering this command, you need to enter the original password of root, and then the password of root will be changed to mypasswd.

Change the root in the command to your user name, and you can change your own password.

Of course, if your mysqladmin can't connect to mysql server, or if you can't execute mysqladmin, then this method doesn't work, and mysqladmin can't clear the password.

The following methods are used at the mysql prompt and must have root permission for mysql:

Method three

Mysql > Insert INTO mysql.user (Host,User,Password)

VALUES ('%', 'jeffrey',PASSWORD (' biscuit'))

Mysql > FLUSH PRIVILEGES

To be exact, this is adding a user with the user name jeffrey and the password biscuit.

This example is found in the mysql Chinese reference Manual:

Note that you use the PASSWORD function, and then you use FLUSH PRIVILEGES.

Method 4

Same as method 3, except that the REPLACE statement is used

Mysql > REPLACE INTO mysql.user (Host,User,Password)

VALUES ('%', 'jeffrey',PASSWORD (' biscuit'))

Mysql > FLUSH PRIVILEGES

Method five

Use the SET PASSWORD statement

Mysql > SET PASSWORD FOR "= PASSWORD ('biscuit')

Simulations must also use the PASSWORD () function, but not FLUSH PRIVILEGES.

Method 6

Use GRANT... IDENTIFIED BY statement

Mysql > GRANT USAGE ON *. * TO "IDENTIFIED BY 'biscuit'

The PASSWORD () function is unnecessary here, and you don't need to use FLUSH PRIVILEGES.

Note: PASSWORD () [not] performs password encryption in the same way that Unix passwords are encrypted.

The solution of MySQL forgetting password

If MySQL is running, kill it first: killall-TERM mysqld.

Start MySQL: bin/safe_mysqld-- skip-grant-tables &

You can enter MySQL without a password.

And then there is.

> use mysql

> update user set password=password ("new_pass") where user= "root"

> flush privileges

Kill MySQL again and start MySQL in the normal way.

Clear the mysql password

Windows:

1. Log in to the system with a system administrator.

two。 Stop the service of MySQL.

3. Enter the command window, and then enter the MySQL installation directory. For example, my installation directory is c:mysql, and enter C:mysqlin.

4. Skip permission check to start MySQL

C:mysqlin > mysqld-nt-- skip-grant-tables

5. Reopen a window, enter the c:mysqlin directory, and set the new password for root

C:mysqlin > mysqladmin-u root flush-privileges password "newpassword"

C:mysqlin > mysqladmin-u root-p shutdown

Replace newpassword with the password of the root you want to use, and the second command prompts you to enter the new password, repeating the password entered by the first command.

6. Stop MySQL Server and start Mysql in normal mode

7. You can link to Mysql with your new password.

Unix&:

1. Log in to the system with root or a user running mysqld

two。 Use the kill command to end the process of mysqld

3. Start MySQL Server with the-- skip-grant-tables parameter

Shell > mysqld_safe-- skip-grant-tables &

4. To set a new password

Shell > mysqladmin-u root flush-privileges password "newpassword"

5. Restart MySQL Server

Mysql change password

Mysql modification can be performed on the mysql command line as follows:

Mysql-u root mysql

Mysql > Update user SET password=PASSWORD ("new password") Where user='name'

Mysql > FLUSH PRIVILEGES

Mysql > QUIT

Teach you how to recover the password of MySQL database

Because the MySQL password is stored in the user table in the database mysql, I just need to copy and overwrite the user table in my MySQL under 2003.

There are three user table related files user.frm, user.MYD, user.MYI in the c:mysqldatamysql (linux is usually / var/lib/mysql/mysql/) directory.

User.frm / / user table style file

User.MYD / / user table data file

User.MYI / / user table index file

To be on the safe side, copy all three, but in fact, if the table structure has not been changed on the MySQL to be restored, just copy the user.MYD

And then

#. / etc/rc.d/init.d/mysql stop

#. / etc/rc.d/init.d/mysql start

# mysql-u root-p XXXXXX

All right, you can log in with the mysql password under windows 2003.

Mysql > use mysql

Mysql > update user set Password=PASSWORD ('xxxxxx') where User='root'

An error will occur at this time, indicating that the user table only has read permissions.

I analyzed the reason, only like this, because the permission assignment of user.* file is under windows 2003, under windows 2003 I ls-l the permission is 666,

When I look under linux, the permission becomes 600 (in fact, under normal circumstances, 600 is fine, but the file owner here is not mysql, but after being copied, the owner becomes root, so there will be insufficient permissions. At this time, if you change the permission to 666, of course, this is not good, there is no essence to solve the problem), take a look at ls-l under / var/lib/mysql/mysql/

# chown-R mysql:mysql user.*

# chmod 600 user.*

/ / OK,DONE

Restart MYSQL

Reconnect

Mysql > use mysql

Mysql > update user set Password=PASSWORD ('xxxxxx') where User='root'

Mysql > FLUSH PRIVILEGES

One thing is worth noting: if you have mysql under windows, if it is the default configuration, you should also implement it.

Mysql > delete from user where User=''

Mysql > delete from user where Host='%'

Mysql > FLUSH PRIVILEGES

All right, this is where the password recovery process is complete.

This method is a little limited, you must also have another user table file

There are several other ways

Other method 1 (this is a method widely spread on the Internet, in the mysql Chinese reference manual)

1. Send a kill command to mysqld server to turn off mysqld server (not kill-9), and the file where the process ID is stored is usually in the same directory as MYSQL.

Killall-TERM d

You must be a root user of UNIX or an equivalent user on the SERVER you are running to perform this operation.

two。 Use the `--skip-grant-tables' parameter to start mysqld. Under LINUX:

/ usr/bin/safe_mysqld-- skip-grant-tables, c:mysqlinmysqld-- skip-grant-tables under windows

3. Then log in to mysqld server without a password

> use mysql

> update user set password=password ("new_pass") where user= "root"

> flush privileges

You can also do this:

Mysqladmin-h hostname-u user password' new password''

4. Load the permissions table:

Mysqladmin-h hostname flush-privileges'

Or use the SQL command

FLUSH PRIVILEGES'

5.killall-TERM mysqld

6. Log in with a new password

Other methods two

Edit user.MYD files directly with a hexadecimal editor

However, I would like to make one point in this. I found a problem when editing here. Some of the encrypted password strings are stored continuously, some of the last two bits are cut, and the last two bits are stored elsewhere. I haven't figured this out yet. It is also important to note that you are editing encrypted password strings, which means you still need to have additional user table files. The difference between this method and the one I described above is that by editing the user file under linux directly, there is no need to change the file owner and permissions.

Fix it: my actual operation under Windows is as follows

1. Close the running MySQL.

two。 Open the DOS window and change to the mysqlin directory.

3. Input

Mysqld-nt-skip-grant-tables

Enter. If there is no prompt, that's right.

4. Open another DOS window (because the DOS window just now cannot be moved), and change to the mysqlin directory.

5. Enter mysql to enter, and if successful, the MySQL prompt will appear >

6. Connect to the permissions database

> use mysql

(> is an existing prompt, don't forget the last semicolon)

6. Change the password:

> update user set password=password ("123456") where user= "root"; (don't forget the last semicolon)

7. Refresh permissions (required)

> flush privileges

8. Quit

> Q

9. Log out of the system, re-enter, open MySQL, and log in with the user name root and the new password 123456 you just set.

Thank you for your reading, the above is the "introduction to the method of cracking the root password of the MySQL database". After the study of this article, I believe you have a deeper understanding of the method of cracking the root password of the MySQL database, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.