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 > > > > > > >
