I can’t connect MySQL to my VB.net project

Asked By Develper2012 20 points N/A Posted on - 03/19/2013

Hello all, am working in application using vb.net and I have database using MySQL, I run the application after i connect it to the database in my PC which am working at and everything was just great, after i moved the application to a server to run it from there i got a problem.

"Unable to connect to any of the specified MySQL hosts."

I put 'localhost' in the connection string and I still get this error

Any help please?

 

 

• Status: Open
• Question Views: 725
• Answer Count: 2
• Vote Up 2 Vote Down

• Answer Accepted: Yes
• Question Category: Database

Best Answer by Martin Crase

Go To Solution

Answered By Jose D Dunn 10 points N/A #177649

I can’t connect MySQL to my VB.net project

Hi There,

Unable to connect to any of the specified MySQL hosts. It is when the database is set up to not allow remote connections, you may recreate the database and adjust the settings. If the problem still persists you may need to reinstall the MySQL Server Instance Configuration Wizard and the checkbox "Enable root access from remote machine".

About Jose D Dunn

Questions
11

Answers
102

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 03/20/2013
• Question Category: Database

Best Answer

Best Answer

Answered By Martin Crase 0 points N/A #177650

I can’t connect MySQL to my VB.net project

Hi,

I have encountered this same problem before. When you moved the application to the server did you move the database as well? Using localhost means that the database is expected to be on the same machine as the application. If the database is on another location then you have to change the connection string and check that the remote access permissions are enabled.

About Martin Crase

Questions
2

Answers
4

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 04/26/2013
• Question Category: Database