Member Avatar for ds2r

Hi guys. Here's my problem.

I have a Windows Form application which connects to a mysql database by using ODBC Driver. It works fine on localhost. Now what I intend to do is to connect this application to a mysql database that is in a hosting provider's mysql server. I am using 000webhost.com which is a really good free hosting site for testing.

I have this connection string in my application:

@"Driver={MySQL ODBC 5.1 Driver};Server=xxx.000webhost.com;Database=xxx_scm;User=xxx_root;Password=xxx_root;";

The data that I entered here were given by 000webhost.com. But when I try to run my application using that connection string, it doesn't work. Any help? :)

  • 3 Contributors
  • 3 Replies
  • 202 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ds2r
Member Avatar for rch1231

Hello,

You also need to add a user (or have a user added by the hosting company) to the MySQL users table that connects from the remote IP. (i.e. dbuser@192.168.1.2 ) to tell MySQL it is OK to accept connections from that host as that user to the specified database.

Member Avatar for karol33

you must input values where you have "xxx"

Member Avatar for ds2r

Hello,

You also need to add a user (or have a user added by the hosting company) to the MySQL users table that connects from the remote IP. (i.e. dbuser@192.168.1.2 ) to tell MySQL it is OK to accept connections from that host as that user to the specified database.

Is the IP part needed? I have already made users for the database but i don't think it has the option to allow connection from remote ip but i will try. Thanks! :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.