Home >Database >Mysql Tutorial >How to change password in MySQL using cmd command
When you first create MySQL, you generally need to change the password; moreover, I have encountered operating on several servers and forgotten the root password of one of them (remember the user password, root has not been used for a long time), so Find the following method online and record it.
1. Initialize password setting
/etc/init.d/mysql stop cd /usr/local/mysql mysqld_safe –user=mysql –skip-grant-tables –skip-networking & mysql -u root mysql mysql > UPPATE user SET password=PASSWORD(‘newpassword’) where USER=’root’; mysql > FLUSH PRIVILEGES; mysql > quit ; /etc/init.d/mysql restart mysql -u root -p
Method 1: Use SET PASSWORD command
mysql -u root mysql> SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpass’);
Method 2: Use mysqladmin
mysqladmin -u root password “newpass” 如果root已经设置过密码,采用如下方法 mysqladmin -u root password oldpass “newpass”
Method 3: Use UPDATE directly Edit the user table
mysql -u root mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD(‘newpass’) WHERE user = ‘root’; mysql> FLUSH PRIVILEGES;
2. Set the root password when you lose the root password
Method 1:
mysqld_safe –skip-grant-tables& mysql -u root mysql mysql> UPDATE user SET password=PASSWORD(“new password”) WHERE user=’root’; mysql> FLUSH PRIVILEGES;
Method 2:
1. Modify mysql Configuration file (default is /etc/my.cnf), add a line skip-grant-tables under [mysqld]
2. After saving the configuration file, restart the mysql service service mysqld restart
3. Mysql -u root -p log in to mysql, then press Enter without entering the password, and then change the password according to the above process
4. After the password is changed, delete the configuration file according to process 1. That line, then restart the mysql service
The above is the detailed content of How to change password in MySQL using cmd command. For more information, please follow other related articles on the PHP Chinese website!