How to allow all hosts to access mysql

1. Change the Host field value of a record in the user table in the MySQL database to %. The strange thing is that you must use the following statement to set the password

2. update user set Password=PASSWORD("123456") WHERE Host="%";

3. Execute the flush privileges command to make it take effect immediately

The above method of allowing all hosts to access mysql is all I have to share with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.

You may also be interested in:

How to quickly modify the host attribute of a MySQL user
Does the % in the newly created MySQL user include localhost?
Perfect solution to the problem that MySQL cannot connect to the database through localhost
Solution to the problem that MySQL can connect using localhost but cannot connect using IP
A brief discussion on the matching rules of host and user when Mysql connects to the database

Tutorial on deploying springboot package in linux environment using docker

Blog

How to allow all hosts to access mysql

uni-app WeChat applet authorization login implementation steps

25 advanced uses of JS array reduce that you must know

A brief discussion on several advantages of Vue3

Web Theory: Don't make me think Reading Notes

Tutorial on deploying springboot package in linux environment using docker

Vue implements a small weather forecast application

MySQL 5.7.23 installation and configuration graphic tutorial

Solution to multiple 302 responses in nginx proxy (nginx Follow 302)

50 Super Handy Tools for Web Designers

Detailed explanation of the use of Vue card-style click-to-switch image component

Recommend

Comprehensive analysis of MySql master-slave replication mechanism

WeChat applet implements search box function

SVG+CSS3 to achieve a dynamic wave effect

How to rename the table in MySQL and what to pay attention to

DockerToolBox file mounting implementation code

The difference and usage of single-line and double-line layout in Flex mobile layout

Detailed tutorial on using the tomcat8-maven-plugin plugin in Maven

Summary of learning HTML tags and basic elements

Solution to the problem that the text is on the lower left and cannot be resized when the textarea is laid out

MySQL 5.7.21 decompression version installation and configuration method graphic tutorial

Detailed explanation of JavaScript Proxy object

Detailed graphic tutorial on downloading and installing VirtualBox software and installing and deploying it in Linux environment

How to use echarts to visualize components in Vue

The solution record of Vue failing to obtain the element for the first time

How does MySQL implement ACID transactions?