473,397 Members | 2,028 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Port 3306 - can't get started

I have tried to install MySQL 4.0.14 on my Pentium 1.7Ghz running WindowsXP
Professional.

the installation ran through without any problems.

However, every command gives an error:
C:\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>mysql --install
mysql: ERROR: unknown option '--install'

C:\mysql\bin>mysqladmin -u root shutdown
....failed - and it suggested I telnet localhost 3306

C:\mysql\bin>telnet localhost 3306
Connecting to localhost...Could not open connection to the host, on port
3306: Connect failed

C:\mysql\bin>mysqladmin test
mysqladmin: connect to server at 'localhost' failed..

Anyone got any suggestions? Obviously I have to do something about port
3306.

Thanks
Steve
Jul 19 '05 #1
4 20542
Do you have the XP Firewall turned on?

"Steve Carson-Rowland" <st**********@yahoo.com> wrote in message
news:3f***********************@news.optusnet.com.a u...
I have tried to install MySQL 4.0.14 on my Pentium 1.7Ghz running WindowsXP Professional.

the installation ran through without any problems.

However, every command gives an error:
C:\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>mysql --install
mysql: ERROR: unknown option '--install'

C:\mysql\bin>mysqladmin -u root shutdown
...failed - and it suggested I telnet localhost 3306

C:\mysql\bin>telnet localhost 3306
Connecting to localhost...Could not open connection to the host, on port
3306: Connect failed

C:\mysql\bin>mysqladmin test
mysqladmin: connect to server at 'localhost' failed..

Anyone got any suggestions? Obviously I have to do something about port
3306.

Thanks
Steve

Jul 19 '05 #2
I went through Control Panel to Local Area Connection Properties and clicked
on the advanced tab and the check box for Firewall is OFF.

"Brandon" <br******@tennisshop.com> wrote in message
news:HJ******************@fe1.columbus.rr.com...
Do you have the XP Firewall turned on?

"Steve Carson-Rowland" <st**********@yahoo.com> wrote in message
news:3f***********************@news.optusnet.com.a u...
I have tried to install MySQL 4.0.14 on my Pentium 1.7Ghz running

WindowsXP
Professional.

the installation ran through without any problems.

However, every command gives an error:
C:\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>mysql --install
mysql: ERROR: unknown option '--install'

C:\mysql\bin>mysqladmin -u root shutdown
...failed - and it suggested I telnet localhost 3306

C:\mysql\bin>telnet localhost 3306
Connecting to localhost...Could not open connection to the host, on port
3306: Connect failed

C:\mysql\bin>mysqladmin test
mysqladmin: connect to server at 'localhost' failed..

Anyone got any suggestions? Obviously I have to do something about port
3306.

Thanks
Steve


Jul 19 '05 #3
I went through Control Panel to Local Area Connection Properties and clicked
on the advanced tab and the check box for Firewall is OFF.

"Brandon" <br******@tennisshop.com> wrote in message
news:HJ******************@fe1.columbus.rr.com...
Do you have the XP Firewall turned on?

"Steve Carson-Rowland" <st**********@yahoo.com> wrote in message
news:3f***********************@news.optusnet.com.a u...
I have tried to install MySQL 4.0.14 on my Pentium 1.7Ghz running

WindowsXP
Professional.

the installation ran through without any problems.

However, every command gives an error:
C:\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>mysql --install
mysql: ERROR: unknown option '--install'

C:\mysql\bin>mysqladmin -u root shutdown
...failed - and it suggested I telnet localhost 3306

C:\mysql\bin>telnet localhost 3306
Connecting to localhost...Could not open connection to the host, on port
3306: Connect failed

C:\mysql\bin>mysqladmin test
mysqladmin: connect to server at 'localhost' failed..

Anyone got any suggestions? Obviously I have to do something about port
3306.

Thanks
Steve


Jul 19 '05 #4
I went through Control Panel to Local Area Connection Properties and clicked
on the advanced tab and the check box for Firewall is OFF.

"Brandon" <br******@tennisshop.com> wrote in message
news:HJ******************@fe1.columbus.rr.com...
Do you have the XP Firewall turned on?

"Steve Carson-Rowland" <st**********@yahoo.com> wrote in message
news:3f***********************@news.optusnet.com.a u...
I have tried to install MySQL 4.0.14 on my Pentium 1.7Ghz running

WindowsXP
Professional.

the installation ran through without any problems.

However, every command gives an error:
C:\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>mysql --install
mysql: ERROR: unknown option '--install'

C:\mysql\bin>mysqladmin -u root shutdown
...failed - and it suggested I telnet localhost 3306

C:\mysql\bin>telnet localhost 3306
Connecting to localhost...Could not open connection to the host, on port
3306: Connect failed

C:\mysql\bin>mysqladmin test
mysqladmin: connect to server at 'localhost' failed..

Anyone got any suggestions? Obviously I have to do something about port
3306.

Thanks
Steve


Jul 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Figmo | last post by:
I am trying to connect to MySQL running on a port other than 3306. Port 8123 in my case. I have tried this: MYSQL_CONNECT("server.domain.com:8123","user","password") And also tried adding...
0
by: Steve Carson-Rowland | last post by:
I have tried to install MySQL 4.0.14 on my Pentium 1.7Ghz running WindowsXP Professional. the installation ran through without any problems. However, every command gives an error:...
4
by: erik | last post by:
Hi I'm just started with MySQL and I'm having MySQL_CC running When I want to connect to my web-hotel database-server what port-number most i write - default seems to be 3306 but is that correct...
1
by: Reply-Via-Newsgroup Thanks | last post by:
Folks, I have a server at an ISP - I've got port 3306 open in the firewall so that I can work from remote however its got me thinking if its safe? I know Microsoft got hit with slammer (or...
3
by: Barth?l?my von Haller | last post by:
Hi ! I installed mysql on windows xp. The first time I started mysld, there is no problem. But, now, each time I start mysqld, I must change the port in my.xxx else I got the following error :...
0
by: ryanmhuc | last post by:
I have root access to this server which has been preconfigured. I can connect using the mysql command tool. But I cannot connect using any mysql GUI software (I am currently tunneling the 3306 port...
4
by: Paul | last post by:
I want to run MySQL on server but it only be accessible to programs on localhost. I see that port 3306 is open on server so I need to close it. How do I do that while keeping it available to...
6
by: Mitesh | last post by:
How can I programattically retrieve MySQL server's port value through PHP?
1
by: Nabarun | last post by:
I have discovered a new thing as a solution for MySql error 10061 (error 2003) where if port 3306 is busy then service cannot run message comes The solution I found is go to mysql/bin type...
3
by: Suresh P | last post by:
Hi All, I tried to access the mysql database in ODBC using ip address and username/password. It returns, "cannot connect to MySQL server on IP ADDRESS(10060)". This could be related to Firewall...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.