What exactly are doing(actually typed in commands)?
What is the exact error message you got?
What interfaces is your mysql server configured to listen to(netstat -ntlp)?
I mean I still cannot connect to mysql on my remote server.
The commands I am using are as follows
I dont get any error message - just mysql cannot connect and appears to hang.
Seems that the mysqld listening to all interfaces. That one checked and fine.
---
Quote:
I dont get any error message - just mysql cannot connect and appears to hang.
That points to a possible firewall issue with the mysql server just dropping the packages of the mysql-connection attempt, the mysql server is being blocked completely or the mysql server is not reachable via ip(check with ping!).
---
Please check if the mysql-port is open from the machine from which you are trying to connect:
Check/Show your complete firewall rule set(iptables -L -v -n):
Check/Show your complete firewall rule set(iptables -L -v n):
That one is still open.
And for the record, the answer in the first place, which gets us most information about your situation and error to be able to best help you would have been this:
What I have executed is this: mysql -h 1.2.3.4
What I got is this: ERROR 2003 (HY000): Can't connect to MySQL server on '1.2.3.4' (101 "Network is unreachable")
And for the record, the answer in the first place, which gets us most information about your situation and error to be able to best help you would have been this:
What I have executed is this: mysql -h 1.2.3.4
What I got is this: ERROR 2003 (HY000): Can't connect to MySQL server on '1.2.3.4' (101 "Network is unreachable")
Apologies - here is the result of that command
when I run mysql -h 1.2.3.4 - it just hangs and cannot connect
---------- Post updated at 06:32 AM ---------- Previous update was at 06:20 AM ----------
The server is hosted by Rackspace.
Is there a chance the connection may be getting blocked by some firewall functionality in the admin console?
Hello all friends
I am using ulogd with iptables to import iptables log into mysql but it is not working , Is there any way to log iptables log into mysql , i am using centos 6
Thanks (0 Replies)
After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the:
mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
I am tring to install mysql 5.0 on redhat linux3.
In this server mysql 3 is already installed and hence while I install mysql 5 it gives the following error.
How I can install mysql 5 with out affect previous installation?
bash-2.05b# rpm -i MySQL-server-community-5.0.41-0.rhel3.i386.rpm... (2 Replies)
I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql:
#... (2 Replies)
MySQL on my server is down....
I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock
Any suggestions?
Here's what I can't do:
can't be root
don't have physical access (do stuff via SSH)
reinstall MySQL (need to keep the current MySQL... (8 Replies)