MySQL Error 1290 (HY000) Solution

I struggled with a problem for a long time and repeatedly confirmed the grammatical problem. But later I searched it online and suddenly I understood. Let me summarize this.

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 statement

mysql> 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:

Authorize remote login for the root user, and then find that ERROR 1290 (HY000) is reported

Then flush privileges.

Then execute authorization again and the problem is solved.

The above is a simple solution. Thank you for reading and supporting 123WORDPRESS.COM.

You may also be interested in:

4 solutions to mysql import csv errors
Problems and solutions of error 08001 when linking to MySQL in IDEA and no table display after successful connection
Problems and solutions for IDEA connecting to MySQL
Solution to the problem that synchronous replication errors cannot be skipped in MySQL5.6 GTID mode
Solution to ONLY_FULL_GROUP_BY error in Mysql5.7 and above
Detailed explanation of the solution to the error in creating a user and granting permissions in mysql8.0
Django restarts after reinstalling MySQL and reports an error: How to solve the problem of No module named 'MySQLdb'
Solution to the error message "java.sql.SQLException: Incorrect string value:'\xF0\x9F\x92\xA9\x0D\x0A...'" when storing emoticons in MySQL
Description and solution of MySQLdb error when installing Python
How to solve the error when connecting to MySQL in Linux: Access denied for user 'root'@'localhost'(using password: YES)
Teach you how to solve the error when storing Chinese characters in MySQL database

<<: Example of how to adapt the Vue project to the large screen

>>: Examples of using Docker and Docker-Compose