Mysql how to create password error

How to create a wrong password for mysql: first open the terminal, enter the code [mysql> flush privileges; refresh privileges]; then re-enter the set password.

Mysql creates a password error method:

In the settings

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

An error occurred:

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

Solution:

mysql> flush privileges; Refresh privileges

Re-enter the setting password.

More related free learning recommendations: mysql tutorial (video)

The above is the detailed content of how mysql creates password errors. For more information, please pay attention to 1024programmer. com Other related articles!