Hi, I've just created a mysql user on one machine accessable by a particular subnet. I am now trying to access this db from that subnet but it is telling me Can't connect to MySQL server. Is tehre anything I have to specify before it can be accessed remotely? Thanks Bubble
what's the complete error message?
how did you create that user account?
ERROR 2003: Can't connect to MySQL server on '...' (111)
(... is the IP address) Created the account directly by inserting into the user table and then flushing privileges. Thanks Bubble
which host the user has in users table?
do you have a my.cnf with "skip-networking" (normally /etc/mysql/my.cnf) ? this should be commented out
The firewall was only allowing outgoing connections. Got my boss to let it through and all seems to be working fine now. Thanks
