Here's the problem: When I try to connect to MYSQL from server 1 with the statement mysql -uuser1 -p -hserver it works but when I run the same statement on my server2, nothing happens. I can also do --> ping server from both the servers. user table: host -- user % -- user1 I dunno where to check, google aint turning up fruitful results too
1) if you have root access to mysql, go to mysql console, connect to mysql db and check table 'host' (it contains ip of host from which connection is allowed for specific users and dbs) 2) if you have access only to your db, then i can suggest asking owner of mysql server or looking at your hosting panel. My cpanel has feature "Remote Database Access Hosts".