Mysql: Unable to connect to any of the specified MySQL hosts solution

Solution:

1. Enable the firewall and allow remote connection

2. Connection string problems

Because mysql versions or drivers have different connection strings,

 

<Add key = "ConnectionString" value = "server = Remote database IP address; database = database name; PORT = PORT; uid = user; pwd = password; charset = gb2312"/>

<Add key = "ConnectionString" value = "data source = Remote database IP address; database = database name; uid = user; pwd = password;"/>

 

Note that even the local 'IP Address of the remote database' must be expressed as an IP address. The. Dot symbol cannot be used to represent the local IP address.