Shulou(Shulou.com)06/02 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.