can somebody explain the events below:
mysql is running but its not listening on 3306,...as a result clients on remote
machines are not able to connect..
The server name is spiti
confirm that mysqld is running:
[EMAIL PROTECTED] ~]$ ps -ef |grep [m]ysql
root 31515 1 0 15:30 pts/3 00:00:00 /bin/sh ./mysqld_safe
--user=mysql
mysql 31535 31515 0 15:30 pts/3 00:00:00 /usr/local/mysql/libexec/mysqld
--basedir=/usr/local/mysql --datadir=/usr/mysql --user=mysql
--pid-file=/usr/mysql/spiti.ad.infosys.com.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
root 31683 28153 0 15:49 pts/0 00:00:00 mysql -u root -p
running nmap to see open ports
[EMAIL PROTECTED] ~]$ nmap localhost
Starting nmap 3.70 ( http://www.insecure.org/nmap/ ) at 2005-06-07 15:55 EDT
Interesting ports on localhost.localdomain (127.0.0.1):
(The 1655 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
80/tcp open http
443/tcp open https
10000/tcp open snet-sensor-mgmt
Nmap run completed -- 1 IP address (1 host up) scanned in 0.179 seconds
trying telnet from the server:
[EMAIL PROTECTED] ~]$ telnet localhost 3306
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
telnet: Unable to connect to remote host: Connection refused
trying to connect from remote client:
[EMAIL PROTECTED] digz]$ mysql -h 172.25.243.145 -u root -p mysql
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '172.25.243.145' (111)
successfull connection from server:
[EMAIL PROTECTED] ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.1.9
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
TIA
digz
******************* CAUTION - Disclaimer ****************** This e-mail
contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of
the addressee(s). If you are not the intended recipient, please notify the
sender by e-mail and delete the original message. Further, you are not to copy,
disclose, or distribute this e-mail or its contents to any other person and any
such actions are unlawful. This e-mail may contain viruses. Infosys has taken
every reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You should
carry out your own virus checks before opening the e-mail or attachment.
Infosys reserves the right to monitor and review the content of all messages
sent to or from this e-mail address. Messages sent to or from this e-mail
address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
