Restore the MySQL administrator password in Linux

Source: Internet
Author: User
Restore the MySQL administrator password in Linux. 1. Send the kill command to mysqldserver to disable mysqldserver (not kill-9). The files that store the process ID are usually stored in MYSQL.

Restore the MySQL administrator password in Linux. 1. Send the kill command to mysqld server to turn off mysqld server (not kill-9). The files that store process IDs are usually stored in MYSQL.

Restore the MySQL administrator password in Linux

1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). files storing process IDs are usually stored in the directory/var/lib/MYSQL of the mysql database.

# Killall-TERM mysqld

2. Use the -- skip-grant-tables parameter to start mysqld.

#/Usr/bin/safe_mysqld -- skip-grant-tables

Paths may not be the same. You can use locate to find them.
3. Then, you can log on to the mysqld server without a password. At this time, the Mysql password is the same as that at the time of installation and is empty. Now we can use mysqladmin to change the mysql password.

# Mysqladmin-u root-p password newpassword

4. Load the permission table and use the following command

# Mysqladmin flush-privileges

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.