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:
|
<<: Example of how to adapt the Vue project to the large screen
>>: Examples of using Docker and Docker-Compose
Table of contents text 1. Prepare the machine 2. ...
Preface Sometimes you come across business tables...
Table of contents Preface Install the graphics dr...
This article example shares the specific code of ...
I've been using redis recently and I find it ...
public function json_product_list($where, $order)...
MySql Download 1. Open the official website and f...
According to Chinese custom, we are still celebra...
1. Create a configuration file directory cd /home...
Preface The apt-get command is a package manageme...
There are three ways to create an image: creating...
For example, he enters: XML/HTML Code div#page>...
Here is a brief introduction to indexes: The purp...
Main library configuration 1. Configure mysql vim...
1. Download the required kernel version 2. Upload...