no 3306 but mysqld running
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/300:00:00 /bin/sh ./mysqld_safe --user=mysql mysql31535 31515 0 15:30 pts/300: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/000: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/tcpopen ssh 25/tcpopen smtp 80/tcpopen http 443/tcp open https 1/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***
Re: no 3306 but mysqld running
Digvijoy Chatterjee wrote: 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.. by default in PLD the 'skip-networking' option is turned on in mysqld.conf, maybe you have the same option in your mysql config. regards, Irek Sonina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: no 3306 but mysqld running
Have you tried to telnet into that port? Are you sure that it's open in your firewall? J.R. 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.. smime.p7s Description: S/MIME cryptographic signature
Re: no 3306 but mysqld running
You hit the nail on the head Irek,thanks the problem was skip networking was on. Regards Digz On Tue, 2005-06-07 at 17:34, Irek Słonina wrote: Digvijoy Chatterjee wrote: 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.. by default in PLD the 'skip-networking' option is turned on in mysqld.conf, maybe you have the same option in your mysql config. regards, Irek Słonina Aut disce Aut Discede Aut Vincere Aut Mori Either learn or leave Either conquer or die [EMAIL PROTECTED] #4043 *** 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*** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]