alexis101 Posted March 5, 2006 Share Posted March 5, 2006 Hello everyone,My problem is: I have a remote mysql server and i cant connect to it . I granted all privilege to root from my ip address (i have a static one) and still when i try to conect to my server i still have the message ERROR 2003 (HY000): Can't connect to MySQL server on (XXX.XXX.XXX.XXX)Here is what i did :[code]mysql>GRANT ALL PRIVILEGES ON *.* TO [email protected] IDENTIFIED BY "**********";[/code]and on my local machine[code]localhost ~ # mysql --host=XXX.XXX.XXX.XXX --passEnter password:ERROR 2003 (HY000): Can't connect to MySQL server on 'XXX.XXX.XXX.XXX' (111)[/code]Anyone can point me where i did my error?Thank you! Link to comment https://forums.phpfreaks.com/topic/4161-connecting-to-a-remote-mysql-server/ Share on other sites More sharing options...
wickning1 Posted March 5, 2006 Share Posted March 5, 2006 Is it firewalled? Link to comment https://forums.phpfreaks.com/topic/4161-connecting-to-a-remote-mysql-server/#findComment-14466 Share on other sites More sharing options...
alexis101 Posted March 6, 2006 Author Share Posted March 6, 2006 no Link to comment https://forums.phpfreaks.com/topic/4161-connecting-to-a-remote-mysql-server/#findComment-14735 Share on other sites More sharing options...
wickning1 Posted March 6, 2006 Share Posted March 6, 2006 There's nothing wrong from a MySQL standpoint, it has to be some kind of networking error. My best guess is that the server is not listening to the default port (3306 I believe), or there is a firewall somewhere in between. Link to comment https://forums.phpfreaks.com/topic/4161-connecting-to-a-remote-mysql-server/#findComment-14743 Share on other sites More sharing options...
alexis101 Posted March 6, 2006 Author Share Posted March 6, 2006 well i did a ngrep on the port 3306 and here is what i got :[code]ngrep -W byline 3306interface: eth0 (XXX.XXX.XXX.XXX/XXX.XXX.XXX.XXX)match: 3306###############################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################exit98549 received, 0 droppedlocalhost ~ #[/code]Anyway i dont understand my server is not behind any firewall or any router ... Link to comment https://forums.phpfreaks.com/topic/4161-connecting-to-a-remote-mysql-server/#findComment-14766 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.