Hi, Pls. find response below: C:\wamp\mysql\bin>netstat -an Active Connections Proto Local Address Foreign Address State TCP 0.0.0.0:25 0.0.0.0:0 LISTENING TCP 0.0.0.0:80 0.0.0.0:0 LISTENING TCP 0.0.0.0:135 0.0.0.0:0 LISTENING TCP 0.0.0.0:445 0.0.0.0:0 LISTENING TCP 0.0.0.0:2701 0.0.0.0:0 LISTENING TCP 0.0.0.0:2702 0.0.0.0:0 LISTENING TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING TCP 0.0.0.0:8081 0.0.0.0:0 LISTENING TCP 0.0.0.0:13468 0.0.0.0:0 LISTENING TCP 127.0.0.1:1074 0.0.0.0:0 LISTENING TCP 172.21.138.200:139 0.0.0.0:0 LISTENING TCP 172.21.138.200:1074 172.21.136.21:139 TIME_WAIT TCP 172.21.138.200:3389 172.21.138.11:2590 ESTABLISHED TCP 172.21.138.200:4534 172.21.136.21:135 TIME_WAIT TCP 172.21.138.200:4535 172.21.136.21:1026 TIME_WAIT TCP 172.21.138.200:4537 172.21.136.21:135 TIME_WAIT TCP 172.21.138.200:4538 172.21.136.21:389 TIME_WAIT TCP 172.21.138.200:4575 172.21.13.139:445 SYN_SENT TCP 172.21.138.200:4576 172.21.13.140:445 SYN_SENT TCP 172.21.138.200:4577 172.21.13.141:445 SYN_SENT TCP 172.21.138.200:4578 172.21.13.142:445 SYN_SENT TCP 172.21.138.200:4579 172.21.13.143:445 SYN_SENT TCP 172.21.138.200:4580 172.21.13.144:445 SYN_SENT TCP 172.21.138.200:4581 172.21.13.145:445 SYN_SENT TCP 172.21.138.200:4582 172.21.13.146:445 SYN_SENT TCP 172.21.138.200:4583 172.21.13.147:445 SYN_SENT TCP 172.21.138.200:4584 172.21.13.148:445 SYN_SENT UDP 0.0.0.0:69 *:* UDP 0.0.0.0:445 *:* UDP 0.0.0.0:500 *:* UDP 0.0.0.0:1025 *:* UDP 0.0.0.0:1026 *:* UDP 0.0.0.0:1221 *:* UDP 0.0.0.0:4500 *:* UDP 0.0.0.0:8081 *:* UDP 0.0.0.0:8082 *:* UDP 127.0.0.1:123 *:* UDP 127.0.0.1:1900 *:* UDP 127.0.0.1:4542 *:* UDP 172.21.138.200:123 *:* UDP 172.21.138.200:137 *:* UDP 172.21.138.200:138 *:* UDP 172.21.138.200:1900 *:* C:\wamp\mysql\bin>mysql -u root -p Enter password: ***** ERROR 2003: Can't connect to MySQL server on 'localhost' (10055) C:\wamp\mysql\bin>mysql -u root -p Enter password: ERROR 2003: Can't connect to MySQL server on 'localhost' (10055) -- Thanks & Regards Pooja Bajaj Alcatel-Lucent, India Email:pooja.ba...@alcatel-lucent.com Phone:+124-413-3078 | Onnet: 2721-3078
________________________________ From: Chandru [mailto:chandru....@gmail.com] Sent: 12 December 2008 13:40 To: BAJAJ POOJA Cc: chaim.rie...@gmail.com; mysql@lists.mysql.com Subject: Re: MYSQL startup problem Hi, I think you may have to get me the output of netstat -an (this only tells the ports that are all listening). sorry for the confusion. can you connect using "mysql -u root -p" and also using "mysql -u root -p -h 127.0.0.1" one thing that i find here is that you have missed the "-p" option which prompts for password. Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 1:39 PM, BAJAJ POOJA <pooja.ba...@alcatel-lucent.com> wrote: Hi, Pls. Find response below: C:\wamp\mysql\bin>Mysql -h localhost -u root ERROR 2003: Can't connect to MySQL server on 'localhost' (10055) -- Thanks & Regards Pooja Bajaj Alcatel-Lucent, India Email:pooja.ba...@alcatel-lucent.com <mailto:email%3apooja.ba...@alcatel-lucent.com> Phone:+124-413-3078 | Onnet: 2721-3078 -----Original Message----- From: chaim.rie...@gmail.com [mailto:chaim.rie...@gmail.com] Sent: 12 December 2008 13:13 To: BAJAJ POOJA; Chandru Cc: mysql@lists.mysql.com Subject: Re: MYSQL startup problem When you do the following Mysql -h localhost -u root. What do you get ? Sent via BlackBerry from T-Mobile -----Original Message----- From: "BAJAJ POOJA" <pooja.ba...@alcatel-lucent.com> Date: Fri, 12 Dec 2008 08:43:45 To: <chaim.rie...@gmail.com>; Chandru<chandru....@gmail.com> Cc: <mysql@lists.mysql.com> Subject: RE: MYSQL startup problem Hi, It doesn't allows me to telnet port 3306. If I ping that port I receive Request timed out. -- Thanks & Regards Pooja Bajaj Alcatel-Lucent, India Email:pooja.ba...@alcatel-lucent.com <mailto:email%3apooja.ba...@alcatel-lucent.com> Phone:+124-413-3078 | Onnet: 2721-3078 -----Original Message----- From: chaim.rie...@gmail.com [mailto:chaim.rie...@gmail.com] Sent: 12 December 2008 13:02 To: BAJAJ POOJA; Chandru Cc: mysql@lists.mysql.com Subject: Re: MYSQL startup problem It says that is started mysql Can you telnet to port 3306 ? Sent via BlackBerry from T-Mobile -----Original Message----- From: "BAJAJ POOJA" <pooja.ba...@alcatel-lucent.com> Date: Fri, 12 Dec 2008 08:27:02 To: Chandru<chandru....@gmail.com> Cc: <mysql@lists.mysql.com> Subject: RE: MYSQL startup problem Hi, Pls find logs attached below in mail: 080605 15:28:08 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080606 9:32:18 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 080606 9:32:18 InnoDB: Starting shutdown... 080606 9:32:21 InnoDB: Shutdown completed 080606 9:32:21 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 080606 9:30:58 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080606 11:43:53 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 080606 11:43:53 InnoDB: Starting shutdown... 080606 11:43:54 InnoDB: Shutdown completed 080606 11:43:54 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 080606 11:43:55 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080609 9:29:04 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080609 10:14:40 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 080609 10:14:40 InnoDB: Starting shutdown... 080609 10:14:41 InnoDB: Shutdown completed 080609 10:14:41 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 080609 10:26:27 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080609 16:45:52 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 080609 16:45:52 InnoDB: Starting shutdown... 080609 16:45:54 InnoDB: Shutdown completed 080609 16:45:54 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 080609 17:01:50 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080610 11:05:35 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 080610 11:05:35 InnoDB: Starting shutdown... 080610 11:05:36 InnoDB: Shutdown completed 080610 11:05:36 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 080610 11:11:23 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080613 17:28:21 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 080613 17:28:21 InnoDB: Starting shutdown... 080613 17:28:24 InnoDB: Shutdown completed 080613 17:28:24 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 080616 11:28:22 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080701 11:10:31 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 080701 11:10:31 InnoDB: Starting shutdown... 080701 11:10:33 InnoDB: Shutdown completed 080701 11:10:33 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 080701 11:12:34 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080701 11:15:12 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 080701 11:15:12 InnoDB: Starting shutdown... 080701 11:15:13 InnoDB: Shutdown completed 080701 11:15:13 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 080701 11:16:01 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 080818 16:40:28 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081211 13:10:16 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081211 13:10:16 InnoDB: Starting shutdown... 081211 13:10:17 InnoDB: Shutdown completed 081211 13:10:17 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081211 13:10:18 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081111 13:13:43 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081111 13:13:43 InnoDB: Starting shutdown... 081111 13:13:44 InnoDB: Shutdown completed 081111 13:13:44 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081111 13:13:59 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081111 13:14:35 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081111 13:14:35 InnoDB: Starting shutdown... 081111 13:14:36 InnoDB: Shutdown completed 081111 13:14:36 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081111 13:14:36 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081111 13:16:50 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081111 13:16:50 InnoDB: Starting shutdown... 081111 13:16:52 InnoDB: Shutdown completed 081111 13:16:52 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081111 13:17:30 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081111 13:18:04 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081111 13:18:04 InnoDB: Starting shutdown... 081111 13:18:04 InnoDB: Shutdown completed 081111 13:18:04 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081111 13:19:09 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081111 13:26:53 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081111 13:26:53 InnoDB: Starting shutdown... 081111 13:26:55 InnoDB: Shutdown completed 081111 13:26:55 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081111 13:26:55 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081111 13:28:18 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081111 13:28:18 InnoDB: Starting shutdown... 081111 13:28:20 InnoDB: Shutdown completed 081111 13:28:20 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081111 13:28:20 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081111 13:43:46 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081111 13:43:46 InnoDB: Starting shutdown... 081111 13:43:49 InnoDB: Shutdown completed 081111 13:43:49 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081111 13:44:55 InnoDB: Started MySql: ready for connections. Version: '4.0.18-nt' socket: '' port: 3306 081212 10:13:28 MySql: Normal shutdown 081212 10:13:28 InnoDB: Starting shutdown... 081212 10:13:29 InnoDB: Shutdown completed 081212 10:13:29 MySql: Shutdown Complete 081212 10:13:46 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081212 10:14:45 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081212 10:14:45 InnoDB: Starting shutdown... 081212 10:14:47 InnoDB: Shutdown completed 081212 10:14:47 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081212 10:14:47 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081212 10:31:10 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081212 10:31:10 InnoDB: Starting shutdown... 081212 10:31:11 InnoDB: Shutdown completed 081212 10:31:11 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081212 10:31:45 InnoDB: Started c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections. Version: '4.0.18-nt-log' socket: '' port: 3306 081212 11:14:06 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown 081212 11:14:06 InnoDB: Starting shutdown... 081212 11:14:08 InnoDB: Shutdown completed 081212 11:14:08 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown Complete 081212 11:15:12 InnoDB: Started MySql: ready for connections. Version: '4.0.18-nt' socket: '' port: 3306 081212 11:16:17 MySql: Normal shutdown 081212 11:16:17 InnoDB: Starting shutdown... 081212 11:16:19 InnoDB: Shutdown completed 081212 11:16:19 MySql: Shutdown Complete 081212 11:16:48 InnoDB: Started MySql: ready for connections. Version: '4.0.18-nt' socket: '' port: 3306 080612 11:20:47 MySql: Normal shutdown 080612 11:20:47 InnoDB: Starting shutdown... 080612 11:20:49 InnoDB: Shutdown completed 080612 11:20:49 MySql: Shutdown Complete 080612 11:21:19 InnoDB: Started MySql: ready for connections. Version: '4.0.18-nt' socket: '' port: 3306 081212 11:43:44 InnoDB: Started MySql: ready for connections. Version: '4.0.18-nt' socket: '' port: 3306 -- Thanks & Regards Pooja Bajaj Alcatel-Lucent, India Email:pooja.ba...@alcatel-lucent.com <mailto:email%3apooja.ba...@alcatel-lucent.com> Phone:+124-413-3078 | Onnet: 2721-3078 ________________________________ From: Chandru [mailto:chandru....@gmail.com] Sent: 12 December 2008 12:50 To: BAJAJ POOJA Cc: mysql@lists.mysql.com Subject: Re: MYSQL startup problem Hi, By default you can find them in the datadirectory ( the place where you have all your databases stored) Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 12:42 PM, BAJAJ POOJA <pooja.ba...@alcatel-lucent.com> wrote: Hi Chandru, Can you pls. help where can i search for logs. -- Thanks & Regards Pooja Bajaj Alcatel-Lucent, India Email:pooja.ba...@alcatel-lucent.com <mailto:email%3apooja.ba...@alcatel-lucent.com> <mailto:email%3apooja.ba...@alcatel-lucent.com <mailto:email%253apooja.ba...@alcatel-lucent.com> > Phone:+124-413-3078 | Onnet: 2721-3078 ________________________________ From: Chandru [mailto:chandru....@gmail.com] Sent: 12 December 2008 11:58 To: BAJAJ POOJA Cc: mysql@lists.mysql.com Subject: Re: MYSQL startup problem Hi, can you please look at the mysql error logs? if you are not able to figure out the reason, please paste the error log. Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 11:52 AM, BAJAJ POOJA <pooja.ba...@alcatel-lucent.com> wrote: Hi, I am using wamp server version 1.1. When I try to start wamp server, It starts apache only, and does not starts mysql service. I tried to start mysql service independently, even that is not possible. Pls. let me know if any solution available. -- Thanks & Regards Pooja Bajaj Alcatel-Lucent, India Email:pooja.ba...@alcatel-lucent.com <mailto:email%3apooja.ba...@alcatel-lucent.com> <mailto:email%3apooja.ba...@alcatel-lucent.com <mailto:email%253apooja.ba...@alcatel-lucent.com> > Phone:+124-413-3078 | Onnet: 2721-3078