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