List:General Discussion« Previous MessageNext Message »
From:Chandru Date:December 12 2008 8:09am
Subject:Re: MYSQL startup problem
View as plain text  
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<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<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<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<Email%3APooja.Bajaj@stripped>
>
> <mailto:Email%3APooja.Bajaj@stripped<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<Email%3APooja.Bajaj@stripped>
>
> <mailto:Email%3APooja.Bajaj@stripped<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