How to solve the ERROR 1290 (HY000): The MySQL server is running with problem

This article mainly introduces "how to solve ERROR 1290 (HY000): The MySQL server is running with problem". In daily operation, I believe many people have doubts about how to solve the problem of ERROR 1290 (HY000): The MySQL server is running with. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts of "how to solve ERROR 1290 (HY000): The MySQL server is running with problem"! Next, please follow the editor to study!

1.mysqld-- defaults-file=my.cnf-- skip-grant-tables & 2.mysql-uroot-S mysql.sockmysql > alter user root@'192.168.0.%' identified by '111111 error error 1290 (HY000): The MySQL server is running with the-- skip-grant-tables option so it cannot execute this statementmysql > flush privileges; # error Query OK without flush privileges, 0 rows affected (0.16 sec) mysql > alter user root@'192.168.0.%' identified by' 111111 Query OK, 0 rows affected (0.03 sec) 3. Restart mysql at this point, on "how to solve ERROR 1290 (HY000): The MySQL server is running with problem" study is over, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!