MySQL Remote Connection Issues

Question

Hi All

 

I have created a load of code that connects to a MySQL server on my network. When I was developing the code, I kept MySQL on the local development machine and it worked.

 

I can open a connection to the server and get the server version using my connection string, but when I try to connect to the database it says it cannot find any of the MySQL hosts. One of my tests says that it is connecting to the database and I can see the connection in the client list of mysql. But I cannot do any queries on the tables/database...

 

I have added the priveleges and flushed them.

I can use port 3306.

I have tested it locally and it works.

I have bound the IP addresses.

 

I have  really tried everything online and cannot get it to work, with the exception of ini file, where I have only bound the address. I have struggled with this for a couple of weeks now and would really appreciate any help or advise.