CODEWITHSUNDEEP
mysqlsqlyog
Vatsal Patel
Vatsal Patel

Reputation: 317

Mysql Server Connect Issue in SQLYOG

is there any way to connect to a remote database by using SQLyog? I have the ip address, user name and password of the database. However, I have 'Error 2003 - Can't connect to MySQL server on '[myIpAddress]' (10035) whenever I test connection in SQLyog.

Upvotes: 1

Views: 1808

Answers (2)

Fahim Ahmed
Fahim Ahmed

Reputation: 71

You need to add % wild card in your cpanel to enable mysql remote connection, if you cannot do this, you can use SSH tunnel to connect to database, Please check the following screenshot

enter image description here

enter image description here

Upvotes: 0

Vatsal Patel
Vatsal Patel

Reputation: 317

Need to use both ssh connection and mysql server connection for establishment of successful connection.

Upvotes: 1

Related Questions