Root password reset for 3.1-mysql

MySQL does not have a password by default

Mysql-uroot or MySQL to log in.

Set Password

Mysqladmin-uroot password ' hd792310 '

Login command

mysql-uroot-phd792310

If the password is forgotten, the password can be initialized

1.vim/etc/my.cnf

At the core configuration, insert a code

Skip-grant not authorized, can directly login

2. Restart MySQL /etc/init.d/mysqld Restart

You can log in directly to Mysql-uroot

3. After logging in, use a MySQL library

Use MySQL

4. Update a table, that is, change the root user password

Update user set Password=password (' hd792310 ') where user= ' root ';

5. In the configuration file, remove the skip-grant line of code.

Root password reset for 3.1-mysql