Mysql sets up other machines to access

By default, the Mysql service only allows access from the local machine through the client. We need to change the user table of the mysql database to grant access to other machines. Change the host field of the user table. It is originally localhost and changed to %, which indicates that any machine is allowed to access 192.168.1. %, indicating that only the IP address segment can be accessed .?

By default, the Mysql service only allows access from the local machine through the client. We need to change the user table of the mysql database to grant access to other machines. Change the host field of the user table, which is originally localhost and changed to %, which indicates that any machine is allowed to access 192.168.1. %, indicating that only the IP address segment can be accessed. ?

Set other machines for access in Mysql

By default, the mysql service only allows access from the local machine through the client. We need to change the user table of the mysql database to grant access to other machines.

Change the host field of the user table, which is originally localhost and changed to %, to allow access by any machine.

192.168.1. %, indicating that only the IP address segment can be accessed.

?

In addition, an error is reported during data import.

MySql Error Code: 2006-MySQL Server offline Error

Modify the my. ini file and add max_allowed_packet = m to it.