MySQL reported an error about ERROR 1290 (HY000)
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.
