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.