centos6.5 under the source installation MySQL password modification

Centos under source installation MySQL password cracking method:

Method One : First stop the MySQL service:

/etc/init.d/mysqldstop stop MySQL

ps-ef |grep MySQL see 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 go to MySQL

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

To modify the MySQL password:

Use MySQL database, and then execute the following command:

Change the root user password to 123

Update user Setpassword=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

Method Two :/usr/local/mysql/bin/mysqladmin-uroot-p password 123456

centos6.5 under the source installation MySQL password modification