Mysqlroot user password modification and elimination _ MySQL

Modify and remove the password of mysqlroot

1. password modification: Use the mysqladmin command

1. for example, if your root user does not have a password and you want to change the password to abc, the command is mysqladmin-u root password abc.

2. if your root account has a password, the command to change the password to abc is mysqladmin-u root-p password youyou.
Note: after you press enter, you will be asked about the old password. after you enter the old password, the command is completed and the password is modified successfully.
II. password elimination

1. log on as root: mysql-u root-p

2. mysql> use mysql;

3. mysql> update user set password = ''Where user = 'root ';
Restart the mysql service.

BitsCN.com