n00b cannot start MySQL

I am an extreme n00b here in PHP. just started learning PHP. Can't start
MySQL. The command-prompt says:
/Can't connect to MySQL server on 'localhost./
'telnet localhost 10061' gives:
/Connecting to localhost...Could not open connection to the host, on
port 10061: Connect failed./
But 'services.msc' shows MySQL is running.
I am a WinXP user. Running Apche 2.2/PHP5.2/MySQL4.1
Help much appreciated.
regards and thanks
Abhisek

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: n00b cannot start MySQL

Abhisek,

On the MySQL Server, open Task Manager -> Processes tab -> View -> Select Columns and enable PID. Find the Process ID for your mysqld-nt.exe (that is how it's named on my server).

On the command prompt, do:
netstat -abo

Copy the netstat results into Notepad, and search for your mysqld-nt.exe or its PID. Is it running on the port you expected? What happens if you telnet to the listed port?

Regards,
Carlton Whitehead

----- Original Message -----
From: "Abhisek Dutta"
To: php-windows@lists.php.net
Sent: Friday, July 27, 2007 10:54:23 AM (GMT-0500) America/New_York
Subject: [PHP-WIN] n00b cannot start MySQL

I am an extreme n00b here in PHP. just started learning PHP. Can't start
MySQL. The command-prompt says:
/Can't connect to MySQL server on 'localhost./
'telnet localhost 10061' gives:
/Connecting to localhost...Could not open connection to the host, on
port 10061: Connect failed./
But 'services.msc' shows MySQL is running.
I am a WinXP user. Running Apche 2.2/PHP5.2/MySQL4.1
Help much appreciated.
regards and thanks
Abhisek

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: n00b cannot start MySQL

Try telnet'ing on port 3306, which is the default port that MySQL runs on.

Abhisek Dutta wrote:
> I am an extreme n00b here in PHP. just started learning PHP. Can't
> start MySQL. The command-prompt says:
> /Can't connect to MySQL server on 'localhost./
> 'telnet localhost 10061' gives:
> /Connecting to localhost...Could not open connection to the host, on
> port 10061: Connect failed./
> But 'services.msc' shows MySQL is running.
> I am a WinXP user. Running Apche 2.2/PHP5.2/MySQL4.1
> Help much appreciated.
> regards and thanks
> Abhisek
>

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: n00b cannot start MySQL

mysqld-nt.exe is running.
'netstat -an' gives:

/ Proto Local Address Foreign Address State
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:3306 0.0.0.0:0 LISTENING
TCP 0.0.0.0:10852 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1025 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1025 127.0.0.1:1035 ESTABLISHED
TCP 127.0.0.1:1026 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1026 127.0.0.1:1034 ESTABLISHED
TCP 127.0.0.1:1034 127.0.0.1:1026 ESTABLISHED
TCP 127.0.0.1:1035 127.0.0.1:1025 ESTABLISHED
TCP 127.0.0.1:1037 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1064 127.0.0.1:1065 ESTABLISHED
TCP 127.0.0.1:1065 127.0.0.1:1064 ESTABLISHED
TCP 127.0.0.1:1068 127.0.0.1:1069 ESTABLISHED
TCP 127.0.0.1:1069 127.0.0.1:1068 ESTABLISHED
TCP 127.0.0.1:1076 127.0.0.1:1078 ESTABLISHED
TCP 127.0.0.1:1078 127.0.0.1:1076 ESTABLISHED
TCP 192.168.1.7:139 0.0.0.0:0 LISTENING
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1027 *:*
UDP 0.0.0.0:1029 *:*
UDP 0.0.0.0:1113 *:*
UDP 0.0.0.0:2035 *:*
UDP 0.0.0.0:2036 *:*
UDP 0.0.0.0:2058 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:10852 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1028 *:*
UDP 127.0.0.1:1900 *:*
UDP 127.0.0.1:2022 *:*
UDP 127.0.0.1:2055 *:*
UDP 192.168.1.7:123 *:*
UDP 192.168.1.7:137 *:*
UDP 192.168.1.7:138 *:*
UDP 192.168.1.7:1900 *:*
/
nowhere is 10061.
'telnet 3306' gives:
/Connecting To 3306...Could not open connection to the host, on port 23:
Connect
failed
/What to do?
Sorry to ask you all about mysql here.
Regards and thanks
abhisek


Luis Moreira (ESI-GSQP) wrote:
> This is a PHP list, your question is about MySql.
>
> Anyway, see if you have the product correcting installed, and if it
> listening on that port (10061)
> Maybe you installed it using another port.
> Check the MySql config and also look for active ports on the PC with NETSTAT
>
> An example, where the machine is listening on port 21 (ftp) and 80 (www) :
>
> C:\Documents and Settings\luis>netstat -an
>
> Active Connections
>
> Proto Local Address Foreign Address State
> TCP 0.0.0.0:21 0.0.0.0:0 LISTENING
> TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
>
>
> Luis
>
>
>
>

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: n00b cannot start MySQL

Thanks do much for all your help and support. Seems like my zonealarm
was blocking the port. after i uninstalled the program mysql is running
smoothly.
~regards and thanks
Abhisek

James Crow wrote:
> try:
> telnet localhost 3306
> or
> telnet 127.0.0.1 3306
>
> "telnet 3306" tells windows to telnet to a host named 3306 on port 23.
>
> Thanks,
> James
>
>
> On Sat, 2007-07-28 at 13:57 +0530, Abhisek Dutta wrote:
>
>> mysqld-nt.exe is running.
>> 'netstat -an' gives:
>>
>>
>
>
>> /
>> nowhere is 10061.
>> 'telnet 3306' gives:
>> /Connecting To 3306...Could not open connection to the host, on port 23:
>> Connect
>> failed
>> /What to do?
>> Sorry to ask you all about mysql here.
>> Regards and thanks
>> abhisek
>>
>>
>>
>>
>
>
>

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: n00b cannot start MySQL

Start Mysql from command prompt go to start > run >
C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php