473,397 Members | 1,972 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.

No connect - error 111

I have MySQL 4 running on a Win2K3 Server. I can connect to it from
MySQL Control Center running on a client PC on our network. But I
cannot connect to it from the outside world. Get the "can't connect
(111)" error.

The permissions table has a user "user@%" in there and this user has
global access to everything.

If I Telnet to the MySQL port from the outside world I do get a
connection and the MySQL version echoed back to me so the port appears
to be open (not a firewall issue).

But trying to connect with the following command will not work:

mysql -h server.name.com -p 8123 -u user

It prompts for password - then gives the "can't connect (111)" error.

Neither can I connect to it from the outside world through code in PHP
(same error returned)

This error number seems to be a catch all - meaning "can't
connect"....period

Is there some way I can get more meaningful information as to WHY it
can't connect? Bad password?? Bad user name?? No permissions??

It would really help me track this problem down if I knew more about
why it is unable to connect.

-tia
-figmo
Jul 19 '05 #1
0 5296

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

Similar topics

33
by: Savas Ates | last post by:
in asp page im getting this error how can i solve it.. yesterday the codes work but i setup visual studio 6.0 now it doesnt works..
22
by: James Kupernik | last post by:
Hello everyone! I'm hoping someone can shed some light on my ever daunting mysql/php problem. I'm currently trying to get a new server up and running using apache/php/mysql. Everything runs...
0
by: Figmo | last post by:
I have MySQL 4 running on a Win2K3 Server. I can connect to it from MySQL Control Center running on a client PC on our network. But I cannot connect to it from the outside world. Get the "can't...
3
by: Pugi! | last post by:
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin): : #2002 Can't connect to local MySQL...
4
by: Steve Smith | last post by:
I have just installed db2 connect v8.1 (personal edition) on my PC - and reinstalled DB2 Application development client (again v8.1 FP4). When trying to use this to connect via CLI to an AS/400...
14
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...
4
by: d3vkit | last post by:
Okay so I am at a loss here. I have a website that I've previously had no trouble connecting to the mysql DB on. I have an include to a connect file with the relevant connection info, and it was...
0
by: fahrvergnuugen | last post by:
Here's the situation: I'm trying to get DB2 Connect, running on a linux web server, to connect to a backend DB2 database, running on an iSeries AS400. I am 100% green when it comes to AS400s...
2
by: mmr315 | last post by:
this is the code i had written in php to connect to mysql ======================================== <? php class Database { var $database_name; var $database_user; var...
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
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,...

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.