Hi, I find that mysql is running fine :)
TCP * 0.0.0.0:3306 * 0.0.0.0:0 LISTENING . you are connecting wrongly please connect using mysql -u root -p -h 127.0.0.1 I find that you tried the same option both times :) Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 1:53 PM, BAJAJ POOJA <pooja.ba...@alcatel-lucent.com > wrote: > 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<email%3apooja.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<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<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<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<email%3apooja.ba...@alcatel-lucent.com> >> <mailto:email%3apooja.ba...@alcatel-lucent.com<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<email%3apooja.ba...@alcatel-lucent.com> >> <mailto:email%3apooja.ba...@alcatel-lucent.com<email%253apooja.ba...@alcatel-lucent.com> >> > >> Phone:+124-413-3078 | Onnet: 2721-3078 >> >> >> >> >> >> >> >
