Port 3306 - can't get started

Steve Carson-Rowland

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

Subscribe Post Reply

20536

Brandon

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

Steve Carson-Rowland

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

Steve Carson-Rowland

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

Steve Carson-Rowland

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

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...

PHP

Port 3306 - can't get started

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:...

MySQL Database

port number ???

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...

MySQL Database

Is having internet port 3306 open safe?

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...

MySQL Database

I must change the port to start mysqld...

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 :...

MySQL Database

Can't Connect - MySQL Port = 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...

MySQL Database

how do you close MySQL port 3306 except to localhost?

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...

MySQL Database

Retrieving MySQL server's port value with PHP

by: Mitesh | last post by:

How can I programattically retrieve MySQL server's port value through PHP?

PHP

MySQL Error 10061, Service can not run if port 3306 is busy.

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...

MySQL Database

Is there anyway to access MySQL database using ODBC without opening port 3306?

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...

PHP

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

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...

Computer Hardware

Port 3306 - can't get started

Similar topics