List:General Discussion« Previous MessageNext Message »
From:BAJAJ POOJA Date:December 12 2008 8:23am
Subject:RE: MYSQL startup problem
View as plain text  
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.Bajaj@stripped
Phone:+124-413-3078 | Onnet: 2721-3078
 

________________________________

From: Chandru [mailto:chandru.dba@stripped] 
Sent: 12 December 2008 13:40
To: BAJAJ POOJA
Cc: chaim.rieger@stripped; mysql@stripped
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.Bajaj@stripped> 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.Bajaj@stripped
<mailto:Email%3APooja.Bajaj@stripped> 
	Phone:+124-413-3078 | Onnet: 2721-3078
	
	-----Original Message-----
	From: chaim.rieger@stripped [mailto:chaim.rieger@stripped]
	
	Sent: 12 December 2008 13:13
	To: BAJAJ POOJA; Chandru
	Cc: mysql@stripped
	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.Bajaj@stripped>
	
	Date: Fri, 12 Dec 2008 08:43:45
	To: <chaim.rieger@stripped>; Chandru<chandru.dba@stripped>
	Cc: <mysql@stripped>
	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.Bajaj@stripped
<mailto:Email%3APooja.Bajaj@stripped> 
	Phone:+124-413-3078 | Onnet: 2721-3078
	
	-----Original Message-----
	From: chaim.rieger@stripped [mailto:chaim.rieger@stripped]
	Sent: 12 December 2008 13:02
	To: BAJAJ POOJA; Chandru
	Cc: mysql@stripped
	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.Bajaj@stripped>
	
	Date: Fri, 12 Dec 2008 08:27:02
	To: Chandru<chandru.dba@stripped>
	Cc: <mysql@stripped>
	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.Bajaj@stripped
<mailto:Email%3APooja.Bajaj@stripped> 
	Phone:+124-413-3078 | Onnet: 2721-3078
	
	
	________________________________
	
	From: Chandru [mailto:chandru.dba@stripped]
	Sent: 12 December 2008 12:50
	To: BAJAJ POOJA
	Cc: mysql@stripped
	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.Bajaj@stripped> wrote:
	
	
	       Hi Chandru,
	
	       Can you pls. help where can i search for logs.
	
	
	       --
	       Thanks & Regards
	       Pooja Bajaj
	       Alcatel-Lucent, India
	       Email:Pooja.Bajaj@stripped
<mailto:Email%3APooja.Bajaj@stripped> 
	<mailto:Email%3APooja.Bajaj@stripped
<mailto:Email%253APooja.Bajaj@stripped> >
	       Phone:+124-413-3078 | Onnet: 2721-3078
	
	
	________________________________
	
	       From: Chandru [mailto:chandru.dba@stripped]
	       Sent: 12 December 2008 11:58
	       To: BAJAJ POOJA
	       Cc: mysql@stripped
	       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.Bajaj@stripped> 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.Bajaj@stripped
<mailto:Email%3APooja.Bajaj@stripped> 
	<mailto:Email%3APooja.Bajaj@stripped
<mailto:Email%253APooja.Bajaj@stripped> >
	               Phone:+124-413-3078 | Onnet: 2721-3078
	
	
	
	
	
	
	



Thread
MYSQL startup problemBAJAJ POOJA12 Dec
  • Re: MYSQL startup problemChandru12 Dec
    • RE: MYSQL startup problemBAJAJ POOJA12 Dec
      • Re: MYSQL startup problemAnanda Kumar12 Dec
      • Re: MYSQL startup problemChandru12 Dec
        • RE: MYSQL startup problemDhandapani Shanmugam12 Dec
        • RE: MYSQL startup problemBAJAJ POOJA12 Dec
          • Re: MYSQL startup problemchaim.rieger12 Dec
          • Re: MYSQL startup problemClaudio Nanni13 Dec
RE: MYSQL startup problemBAJAJ POOJA12 Dec
  • Re: MYSQL startup problemchaim.rieger12 Dec
Re: MYSQL startup problemChandru12 Dec
  • Re: MYSQL startup problemChandru12 Dec
  • RE: MYSQL startup problemBAJAJ POOJA12 Dec
RE: MYSQL startup problemBAJAJ POOJA12 Dec
  • Re: MYSQL startup problemChandru12 Dec
    • RE: MYSQL startup problemBAJAJ POOJA12 Dec
      • Re: MYSQL startup problemChandru12 Dec
      • Re: MYSQL startup problemGrant Allen12 Dec