How to Connect to a Remote MySQL Server on a LAN?

Connecting to a Remote MySQL Server Over LAN

In a local area network (LAN) environment, accessing a MySQL database hosted on a different computer can pose certain challenges. This article addresses the specific issue of connecting to a MySQL server on a remote PC within the same network.

Initially, the user attempted to connect using the following command:

mysql -u user -h 192.168.1.28:3306 -p password

However, the connection failed with an error message indicating an unknown host. This suggests that the host specification was incorrect.

Solution:

To establish a successful connection, the user needs to modify the host parameter. Specifically, the port number (3306) should be omitted:

mysql -u user -h 192.168.1.28 -p password

Additional Problem and Resolution:

After addressing the host issue, the user encountered a new error regarding access denial. This is caused by a lack of appropriate privileges granted to the connecting user. To resolve this:

1. Access the MySQL server on the remote PC.
2. Execute the following SQL query to grant all privileges to the user from the IP of the connecting computer:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.28' IDENTIFIED BY 'root_password';

Replace '192.168.1.28' with the IP address of the connecting computer.

3. Flush the privileges to apply the changes:

FLUSH PRIVILEGES;

The above is the detailed content of How to Connect to a Remote MySQL Server on a LAN?. For more information, please follow other related articles on the PHP Chinese website!