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?
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".
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.
