ge is:
>ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72'
>(111)
>
>#
>mysql> select host, user, password from user;
>+-+--+
hi all:
I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
client in 192.168.23.73.
I use this way:
mysql -h 192.168.27.72 -u root -p
the ERROR message is:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.
Reindl Harald wrote:
> Please "netstat --numeric-hosts --notrim --programs -u -t -l"
> In my first answer i forgot the -l
i will check according to your suggstions
If i find still in troubles, i will let you know
thank you
---p
--
MySQL General Mailing List
For list archives: http://lists.
Please "netstat --numeric-hosts --notrim --programs -u -t -l"
In my first answer i forgot the -l
Without we get active connections, but we want the listening
tcp-services where somewhere must by mysqld
the easiest test is however
> [harry@srv-rhsoft:~]$ telnet 127.0.0.1 3306
> Trying 127.0.0.1..
Reindl Harald wrote:
> please do not only post outputs, read them and try to understand
> before press send - "not all processes could be identified, non-owned
> process info will not be shown, you would have to be root to see it all."
> in the ouptput says that all afterwards is useless
>
> "net
please do not only post outputs, read them and try to understand
before press send - "not all processes could be identified, non-owned process
info will not be shown, you would have to be root to see it all." in
the ouptput says that all afterwards is useless
"netstat --numeric-hosts --notrim --pr
Reindl Harald wrote:
> Did you make any change in the my.cnf?
> What does "netstat --numeric-hosts --notrim --programs -u -t" say?
> What is the content of your my.cnf?
>
Here incluede
thank you
p
--
(xpol) % netstat --numeric-hosts --notrim --programs -u -t
Andrew Moore wrote:
> I think you'll need to give us a bit more to go on. I presume this is a
> web based app?
yes
>
> What have you changed? Has the MySQL daemon stopped? What have you
> changed?
from 'ps' i get
3545 0.0 0.1 194816 3292 ?Sl 13:58 0:08 /usr/sbin/mysqld --
defau
gt; browser,
> pointing to http://localhost:9000/
>
> Probably my fault, since i have been tinkering a little with my settings.
> As
> i try to connect, i get
> Can't connect to MySQL server on '127.0.0.1' (111)
>
> Any ideas, what to check?
>
> I am using li
//localhost:9000/
>
> Probably my fault, since i have been tinkering a little with my settings. As
> i try to connect, i get
> Can't connect to MySQL server on '127.0.0.1' (111)
>
> Any ideas, what to check?
>
> I am using linux/opensuse 11.4
signature.asc
Description: OpenPGP digital signature
I have been using my local dictionary for years, accessing from web browser,
pointing to http://localhost:9000/
Probably my fault, since i have been tinkering a little with my settings. As
i try to connect, i get
Can't connect to MySQL server on '127.0.0.1' (111)
Any ideas
Regardless of who has implemented the network and the status of
provided monitoring tools, this has all the look and feel of
intermittent network issues. I would run an independant network scan
(maybe nmap?) from one of the affected clients to the affected host
and I bet you will find that the sa
HI Pieter
I have a suggestion.this might not be very helpful
Try to reconfigure the connections between the client and Mysql
server where the problem exists.and then try to notice the
uptime and logs of the server.
CHAVA
On Mon, Aug 18, 2008 at 12:00 PM, Piet
Greetings to all,
I am having a weird issue with MySQL that I can't solve. We are getting
intermittent client connection errors code 2003 to the database server for
10mins seemingly at random, and after 20+ days of uptime. Unfortunately, I
have not been able to correlate these connection problems
Nils Meyer wrote:
Hi Faygal,
Fagyal Csongor wrote:
for (1..5) {
$dbh = DBI->connect($dsn, $user, $password, {'RaiseError' => 1} );
my $sth = $dbh->prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insigh
Hi Faygal,
Fagyal Csongor wrote:
for (1..5) {
$dbh = DBI->connect($dsn, $user, $password, {'RaiseError' => 1} );
my $sth = $dbh->prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insight on that topic:
ht
;,...) failed: Can't
connect to MySQL server on '192.168.0.200' (99) at con.pl line 14
perror 99 gives me:
OS error code 99: Cannot assign requested address
This doesn't make sense to me. I wrote a test script that looks like this:
for (1..5) {
$dbh = DBI->connect
战芳 wrote:
>Hi! gerald_clark,
>But when I call mysql_pconnect("localhost:3306","root","root_password"),it
>return the same error. How can I get the permission to open
>/var/mysql/lib/mysql.sock?
> Fang
>
>
>
what do you get when you do
ls -l /var/mysql/lib/m
Hi! gerald_clark,
But when I call mysql_pconnect("localhost:3306","root","root_password"),it
return the same error. How can I get the permission to open
/var/mysql/lib/mysql.sock?
Fang
>fool.ben wrote:
>
>>Hi everybody!
>>I've install a mysql server on m
fool.ben wrote:
>Hi everybody!
>I've install a mysql server on my computer. The operating system is Redhat
>fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect
>to the server using the following statement:
>$db_connection=mysql_pconnect("localhost","root","");
>The serv
Hi everybody!
I've install a mysql server on my computer. The operating system is Redhat
fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect
to the server using the following statement:
$db_connection=mysql_pconnect("localhost","root","");
The server returned the error 2
On 5/12/2005 11:56 a.m., Mike Smith wrote:
Hi,
Hi,
I've already check my /etc/my.cnf file for a "binding"
line. Its not
there. I also found an item online that indicated
adding:
Look for the option "skip-networking". This disables TCP/IP so the
server only accepts local connections v
qldump on mythconverg and install
Mandrivia 2006 on
server gandalf. I restored the mythconverg; Now, I
get:
[EMAIL PROTECTED] mysql -u mythtv -pmythtv -h gandalf
mythconverg
ERROR 2003 (HY000): Can't connect to MySQL server on
'gandalf' (111)
I then tried granting privledges to
>it sounds like you need to look at, and potentially cleanup (or make
>your mysql access entries match) what's in the inverse-map record for
>the IPnumbers of your machines.
>when you connect mysql takes the IPnumber on the inbound connection,
>looks it up in DNS and then checks the result against
>Note that if you set the password by directly editing (UPDATE) the
>mysql.user table like this, you will have to run
FLUSH PRIVILEGES;
Thank you. That solved the problem connecting from the mysql client.
It changed the problem connecting via the 'Test' button from the ODBC
Administrator, t
[EMAIL PROTECTED] wrote:
Gerald Williams <[EMAIL PROTECTED]> wrote on 09/20/2005 10:49:22 AM:
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for
connecting from a mysql client on a windows machine to a mysql
server running on another windows ma
Gerald Williams <[EMAIL PROTECTED]> wrote on 09/20/2005 10:49:22 AM:
> MySQL 5.0.12, P2P Microsoft network
>
> I cannot get the manual's instructions (24.1.9.6) to work for
> connecting from a mysql client on a windows machine to a mysql
> server running on another windows machine (xp and w2kpr
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for connecting from a
mysql client on a windows machine to a mysql server running on another windows
machine (xp and w2kpro repsectively)
The client machine can ping the server machine by name or IP ad
1 Slave I/O thread: error connecting to master
'replication # MU@ # MUST BE SET:3306': Error: 'Can't connect to
MySQL server on ' # MUST BE SET' (111)' errno: 2003
retry-time: 60 retries: 86400
Google hasnt turned up anything useful. Any ideas anyone? What
ow
>
> 041221 1:12:41 Slave I/O thread: error connecting to master
> 'replication # MU@ # MUST BE SET:3306': Error: 'Can't connect to
> MySQL server on ' # MUST BE SET' (111)' errno: 2003
> retry-time: 60 retries: 86400
>
> Google h
Hi,
I am trying to setup replication on MySQL.
Version 4.1.0alpha
Using:
./bin/mysql -h -u replication -p
I can connect successfully, but my error logs show
041221 1:12:41 Slave I/O thread: error connecting to master
'replication # MU@ # MUST BE SET:3306': Error: 'Can'
Hi,
I'm noticing this error in various script of ours that run on the cron:
DBI connect('general:10.1.1.80:3306;mysql_connect_timeout=3','root',...)
failed: Can't connect to MySQL server on '10.1.1.80' (115) at
/usr/local/apache/cgi-bin/Shared/DBStuff.pm l
At 17:58 -0800 2/24/04, Danny Pudianto wrote:
Hello,
I am from Indonesia and newbie in Mysql.
Why if I execute command MySql in dos prompt,
appear in screen " ERROR 2003 : Can't connect to MySql Server on
'localhost' (10061)
Did you start the server (mysqld) first?
-
Hello,
I am from Indonesia and newbie in Mysql.
Why if I execute command MySql in dos prompt,
appear in screen " ERROR 2003 : Can't connect to MySql Server on 'localhost' (10061)
Thanks
Dani
-
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
7;ll let you know if connecting from the laptop works.
chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 6:40 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Can't connect to MySQL server on 'loc
) and mysql_real_connect(). after the execution of
mysql_real_connect(), i met the error message as;
*Can't connect to MySQL server on 'localhost' (10061)*
I have searched in various discussion forums, the points obtained never able to solve
my problem.
I have tested with mysqladmin as
I assume that you know the the server's ip and then try:
from DOS:
mysql -h ipaddressofserver -u user1 -ppassword1
--type this as is with your server's ip
Also you need to be running 4.1.1 client on your laptop.
N. Chris Frost wrote:
With several others, I too have this problem.
MySQL 4.1.1 ins
ednesday, January 28, 2004 4:15 PM
To: N. Chris Frost
Cc: [EMAIL PROTECTED]
Subject: Re: Can't connect to MySQL server on 'localhost' (10061)
I assume that you know the the server's ip and then try:
from DOS:
mysql -h ipaddressofserver -u user1 -ppassword1
--type this as is with
I assume that you know the the server's ip and then try:
from DOS:
mysql -h ipaddressofserver -u user1 -ppassword1
--type this as is with your server's ip
Also you need to be running 4.1.1 client on your laptop.
N. Chris Frost wrote:
With several others, I too have this problem.
MySQL 4.1.1 ins
With several others, I too have this problem.
MySQL 4.1.1 installed without a problem. The sqlAdmin is running. I can
run the control center and/or mysql to do sql things.
This, though, is all from the server (a PC running Win ME). I want to
connect from my laptop.
What do I have to do? Executi
\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
My my.ini file
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a
Roger and Johannes,
The default did have the "skip-networking" on. I commented that out as
you advised, and it worked like a Charm!! I'm pretty excited to be
able to have that working now. I really really appreciate the prompt
reply and the consideration that you both took in your replies.
server is running on
xxx.168.xxx.xxx, phpmyadmin is installed on it. You are connecting to the
web server with your browser.
> but I can't connect if I put in the IP address (locally or remotely)
> > mysql -h xxx.168.xxx.xxx -p
> password:
> ERROR 2003: Can't connect to MyS
* Aaron Gerber <[EMAIL PROTECTED]> [2004-01-10 21:33 +0100]:
> Locally, I can connect to the MySQL server [...]
> but I can't connect if I put in the IP address (locally or remotely)
Maybe mysqld is configured to listen on its unix domain socket only?
This is the default for Debian.
Remove the li
min (remotely or locally).
http://xxx.168.xxx.xxx/phpmyadmin/
but I can't connect if I put in the IP address (locally or remotely)
> mysql -h xxx.168.xxx.xxx -p
password:
ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (22) ---
locally
ERROR 2003: Can't co
connect remotely
> using MySQL Control Center or SQLyog (from Windows) I get the same error
> (near enough) from both:
>
> SQLyog:
>
>---
>SQLyog
> -----------
>
the same error
(near enough) from both:
SQLyog:
---
SQLyog
---
Error No. 2003
Can't connect to MySQL server on '[server]' (10061)
---
MySQL Control Center:
Hi All:
I am trying to run mysql in a Windows XP environment. I downloaded the
binary and installation went smoothly. What I am expecting is that if I
have winmysqladmin in my startup it should launch and I should be able to
connect using the mysql control centre as my client. So far no joy.
t that
> the mySQL server could resolve the IP to the host name? Thanx!
>
> -Original Message-
> From: O'K Web Design [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 05, 2003 8:06 AM
> To: Francisco Castellon
> Subject: Re: ERROR 2003: Can't connect to MySQL ser
es, if you are resolving an address, then it would try
to
connect using the 'not' local method.
Mike
- Original Message -
From: "Francisco Castellon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: June 5, 2003 2:40 AM
Subject: ERROR 2003: Can't conn
mySQL server using the [EMAIL PROTECTED]
account?
Also I was trying to access the mySQL server using the root@
HOST.MYDOMAIN.COM account by using the command below:
Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
Enter Password: ***
And this is what I get: ERROR 2003: Can't connect
OTECTED]
account?
Also I was trying to access the mySQL server using the root@
HOST.MYDOMAIN.COM account by using the command below:
Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
Enter Password: ***
And this is what I get: ERROR 2003: Can't connect to MySQL server on
'ZEUS.
] account?
Also I was trying to access the mySQL server using the root@ HOST.MYDOMAIN.COM account
by using the command below:
Shell> mysql –u root –h ZEUS.OLYMPUS.LOCAL –p
Enter Password: ***
And this is what I get: ERROR 2003: Can't connect to MySQL server on
'ZEUS.OLYMPUS.LOCA
OTECTED]
account?
Also I was trying to access the mySQL server using the root@
HOST.MYDOMAIN.COM account by using the command below:
Shell> mysql -u root -h ZEUS.OLYMPUS.LOCAL -p
Enter Password: ***
And this is what I get: ERROR 2003: Can't connect to MySQL server on
'ZEUS.
s sets a password for user 'root'.
> shell>mysqladmin -u root -h hostname password 'new-password'
> mysqladmin: connect to server at 'hostname' failed
> error: 'Can't connect to MySQL server on 'hostname' (110)'
> Check that mysqld is runn
PROTECTED]
http://www.GodsOfMusic.com
> ...
> shell>mysqladmin -u root password 'new-password'
> shell>mysqladmin -u root -h hostname password 'new-password'
> mysqladmin: connect to server at 'hostname' failed
> error: 'Can't connect to MySQL ser
S 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
...
shell>mysqladmin -u root password 'new-password'
shell>mysqladmin -u root -h hostname password 'new-password'
mysqladmin: connect to server at 'hostname' failed
error: 'Can't conne
Sorry should have made clear that is what phpMyAdmin gives me in the
browser.
WinMySQLadmin seems to be fine.
-Original Message-
From: Martin Wright [mailto:[EMAIL PROTECTED]]
Sent: 26 November 2002 11:19
To: '[EMAIL PROTECTED]'
Subject: Newbie Help! Can't connect to
XP Pro SP1.
Now I've reinstalled every thing and get the error msg below.
Can't connect to MySQL server on 'localhost' (10061)
I've been to the MySQL site and searched but a) I don't entirely follow
some of the stuff and b) what I've tried doesn't se
following reason: ERROR 2003: Can't connect to MySQL server on
'localhost' (10061)
After this, I deinstalled both MySQL programs and then installed MySQL
3.23.52 alone. Again, everytime I wanted to start mysql, I got the
message "ERROR 2003: Can't connect to MySQL server on
when i try to run phpMyAdmin on an apache server on Windows 2000 I always
get the following message:
Can't connect to MySQL server on 'localhost' (10061)
could anyone please tell me how to configure MySQL to run via tcp/ip on
localhost?
than
Hello,
I work with Suse 7.1 and mysql 3.23.30 gamma. I have killed the mysql
settings and so I remove the mysql-RPMs and install mysql 3.23.41 with
yast1.
Perhaps a mistake, I didn´t reboot the system after removing the RPMs.
Then I have same Problems, like:
I> Funny I still have the same exact
> Sent: Tuesday, March 05, 2002 11:00 AM
I> Subject: Error 2002 can't connect to MySQL server through socket /var/lib...
>> dlyles,
>> Tuesday, March 05, 2002, 4:54:30 AM, you wrote:
>>
>> d> This is the message I am getting. I am currently running MySQL (or
I>
sage -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 11:00 AM
Subject: Error 2002 can't connect to MySQL server through socket /var/lib...
> dlyles,
> Tuesday, March 05, 2002, 4:54:30 AM, you wrote:
>
>
dlyles,
Tuesday, March 05, 2002, 4:54:30 AM, you wrote:
d> This is the message I am getting. I am currently running MySQL (or trying
d> to) on a Cobalt Raq3.
Is your MySQL server running?
d> I recently uninstalled and reinstalled, but am unable
d> to remove this message. I can't start mysql o
This is the message I am getting. I am currently running MySQL (or trying
to) on a Cobalt Raq3. I recently uninstalled and reinstalled, but am unable
to remove this message. I can't start mysql or do anything. That's the
message I keep getting. Any ideas?
---
Hi,
I've been trying to connect remotely to a MySQL server all night on a Linux
machine, to no avail. I'm on a Linux client trying to access MySQL on both an
NT Server and a Linux server. So far I've been able to connect to the NT
server database without a hitch, however every time I tr
Hi
My sys config
OS = NT4 (installed mysql here)
database = MYSQL4.23
language = Visual Basic
I have written an application on visual basic.
If i work from the localhost is working fine.
If I install my application on any other machine,
I get an error
"can't connect to mysql
Hello,
I am running version 3.23.41 on windows '98. When I run winipcfg I show
that my hostname is siren.goldengate.net and
my ip address is 10.0.0.1. When I type c:\mysql\bin mysql I get an error
message:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I tr
Hi,
Does anyone know how to fix the following error?
"ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)"
I get this by typing "mysql" at the shell prompt (ie C:\mysql\ mysql
[return])
MySQL is installed in the default C:\mysql. I'm runni
PROTECTED]>
Sent: Saturday, June 16, 2001 10:20 AM
Subject: mysql and php - Can't Connect To MySQL Server warning
> > I have installed mysql-3.23.38-hp-hpux10.20-hppa1.1 on an hpux10.20 Unix
> > machine. I also have PHP 4.0.5 installed. When I run mysql through PHP
> > on
> I have installed mysql-3.23.38-hp-hpux10.20-hppa1.1 on an hpux10.20 Unix
> machine. I also have PHP 4.0.5 installed. When I run mysql through PHP
> on my web server, I get a "Can't connect to MySQL server" warning error
> once every ten times I try to access a data
>When I type mysql from the command prompt ... an error occured :
> ERROR 2003: Can't connect to MYSQL server on 'localhost' (10061)
>What is the problem?
>Hanan
Don't send me a copy of your message.. I'll get mine from the list..
Did you follow all in
Hi Friends ...
When I type mysql from the command prompt ... an error occured :
ERROR 2003: Can't connect to MYSQL server on 'localhost' (10061)
What is the problem?
Hanan
_
Get Your Private, Free E-mail f
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
e a rather unusual use
pattern.
[...]
> > > > Description:
> > > > I am connecting from Visual Basic 6 to Mysql via
> > > > ODBC DSN. When i made 94 sleeped connection after 94 can't connect to
> a
> > > > server. It says : [TCX][MYODBC]Can'
- Original Message -
From: Yusuf Incekara <[EMAIL PROTECTED]>
To: Benjamin Pflugmann <[EMAIL PROTECTED]>
Cc: Mysql Mailing list <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 1:54 AM
Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql
list <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 2:52 AM
Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server
on 192.9.200.2 (10055))
> Hi.
>
> On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote:
> > Would you please offer m
Hi.
On Thu, Feb 01, 2001 at 08:18:45PM +0200, [EMAIL PROTECTED] wrote:
> Would you please offer me something please ?
>
> > From: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED]
> > Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2
> (10055))
&g
Would you please offer me something please ?
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2
(10055))
>
>
> Description:
> I am connecting from Visual Basic 6 to Mysql via
> ODBC DSN. When
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Description:
I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
server. It says : [TCX][MY
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Description:
I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a
server. It says : [TCX][MY
82 matches
Mail list logo
