have two machine PC#1 with db mysql and appache and PC#2 with a c# form try to connect to this db
here is my connection string used in PC#2:
SERVER=My_public_ip;PORT=3306;DATABASE = my_test; UID = root; PASSWORD = xxxx;"
when i try to connect locally from PC#1 it work good:
SERVER=localhost;DATABASE = my_test; UID = root; PASSWORD = xxxx;"
i did make my root user remote enabled like that:
`GRANT ALL ON *.* to '%'@'%' WITH GRANT OPTION;`
and all i get is an Event viewer: unable to connect to any of the specified MySQL host
now i think it has nothing to do with firewall aftr turn them off on both pc and i still get the same error message, but i can't figure it out