How to install mysql password in Centos source code

How to install mysql password in Centos source code

Method 1: First stop the mysql service ,:

/Etc/init. d/mysqldstop stop mysql

Ps-ef | grep mysql check whether mysql is disabled

Then, start the system in the background by skipping the permission.

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

/Usr/local/mysql/bin/mysql

Or run mysql press enter to enter mysql, and then change the password.

Modify the Mysql password:

Use mysql database, and then execute the following command:

Change the root user password to 123

Update user setpassword = password ('20140901') where user = 'root ';

After modification, stop Mysql and start it in normal mode.

/Etc/init. d/mysqldstop stop mysql

/Etc/init. d/mysqldstart start mysql

Log on to the Mysql database with the new password again to verify that the password is successfully modified.

/Usr/local/mysql/bin/mysql-uroot-p123

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