How to create wrong password in mysql

Mysql method to create a wrong password: First open the terminal and enter the code [mysql> flush privileges; refresh privileges]; then re-enter the set password.

Mysql method to create wrong password:

An error occurred when setting

mysql> set password for root@localhost = password('admin');

:

The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

Solution:

mysql> flush privileges; 刷新权限

Re-enter the setting password.

More related free learning recommendations: mysql tutorial(video)

The above is the detailed content of How to create wrong password in mysql. For more information, please follow other related articles on the PHP Chinese website!