MySQL Remote connectivity issues

If an error occurs cannot connect service on ' IP ' (110)

Can be considered from the following aspects:

1, the connection command has no write error y (especially-P 3306 "p is uppercase")

2, the password is not written wrong

3, the remote database machine has no firewall installed

All right, just change it. "Format: mysql-h 192.168.0.0-p 3306-u root-p"

For 3, you can have the following methods: 1, directly switch off Firewall 2, add the trust IP in the remote database, add the method as follows:

Connect to the database first,

then use MySQL;

Grant all on * * to [email protected] ' need to add convenient IP ' identified by ' MySQL password '

Then execute flush Privileges

MySQL Remote connectivity issues