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.