Connect .net app to mysql database

hql

• January 21, 2017 11:08

Im trying to connect my .net application to the mysql database remotely, ive added the respective IP addresses to allow connections from, ive opened port 3306 in CSF, what do I enter for hostname, am I correct in assuming that the servers IP address should be the hostname, followed by database name, user and password? Sorry im a bit new to all of this so am lost I keep getting this error: "The underlying provider failed on ConnectionString"

• 

  cPanelMichael

  • January 23, 2017 19:01

  ive added the respective IP addresses to allow connections from

  
  Hello, Could you confirm the remote IP address was added via the

  0
• 

  hql

  • January 24, 2017 05:42

  Yes they have been, port 3306 has also been in opened up in csf, is there a way to test connectivity other than our app?

  0
• 

  cPanelMichael

  • January 24, 2017 14:07

  Hello, You could try connecting to a database on the cPanel server from another remote server or your own local workstation with another application to verify if it works properly. If it works with another application, then the issue is likely related to the individual application you are using. Thank you.

  0
• 

  hql

  • January 26, 2017 17:11

  What's the best application to use in mac OS X to verify this or windows?

  0
• 

  cPanelMichael

  • January 27, 2017 21:36

  What's the best application to use in mac OS X to verify this or windows?

  
  You can find some examples of MySQL client applications to try at a third-party URL such as:

  0

Please sign in to leave a comment.