MySQL about ERROR 1290 (HY000) error reporting solution

A problem is entangled for a long time, repeatedly confirming grammar problems. But then I searched online and had an epiphany. To sum it up.

mysql> grant select,insert,update,delete on *.* to 'root'@'%';ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statementmysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> mysql> mysql> mysql> grant select,insert,update,delete on *.* to 'root'@'%';Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> grant all on *.* to 'root'@'%';Query OK, 0 rows affected (0.00 sec)

Explanation:

Perform an authorized remote login to root and find ERROR 1290 (HY000)

Then flush privileges.

Then the authorization is executed again and the problem is solved.

The above is a simple solution, thank you for reading and support.