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 root@XXX.XXX.XXX.XXX 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! Quote 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? Quote 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 Quote 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. Quote 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 ... Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.