MySQL Error 1290 (HY000) Solution

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

Recommend

Docker builds CMS on-demand system with player function

Table of contents text 1. Prepare the machine 2. ...

How to convert a column of comma-separated values ​​into columns in MySQL

Preface Sometimes you come across business tables...

Implementation of installing and uninstalling CUDA and CUDNN in Ubuntu

Table of contents Preface Install the graphics dr...

Vue implements small form validation function

This article example shares the specific code of ...

Comparison between Redis and Memcache and how to choose

I've been using redis recently and I find it ...

getdata table table data join mysql method

public function json_product_list($where, $order)...

MySQL 5.7.18 download and installation process detailed instructions

MySql Download 1. Open the official website and f...

Ubuntu Basic Tutorial: apt-get Command

Preface The apt-get command is a package manageme...

How to create, save, and load Docker images

There are three ways to create an image: creating...

Zen coding for editplus example code description

For example, he enters: XML/HTML Code div#page>...

How to add indexes to MySQL

Here is a brief introduction to indexes: The purp...

MySQL master-slave replication configuration process

Main library configuration 1. Configure mysql vim...

How to compile the Linux kernel

1. Download the required kernel version 2. Upload...