Hi,
I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting
mycompA$mysql -h mycompB -u mysql -p
on host A, I can connect and to the mysql-server on host B. However when I
start
mycompB$mysql -h mycompA -u mysql -p
on host B, I get the error message:
ERROR 2003: Can't connect
I assume you have already verified that the mysql server is actually running
on server A. Have you verified that server A is accepting tcp connections?
Try running
mysql -h mycompA -u mysql -p
from server A. If it lets you in, try
SELECT CURRENT_USER();
just to make sure it says
Bingo!!
With the installation of the 5.0 (I assume) skip-networking was set by default
in /etc/mysql/my.cnf. That was it.
Thanks.
Mike
I assume you have already verified that the mysql server is actually
running on server A. Have you verified that server A is accepting tcp
connections? Try
Sasha Pachev writes:
Jigal van Hemert wrote:
It's a bug. I would recommend to patch libmysql.c for now until MySQL developers
fix it.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
Our client side uses select() but only when waiting for data, and not
on teh
Jigal van Hemert wrote:
The continuing saga:
Can't connect to MySQL server on '192.168.13.205' (4)
Our sysadmin has been searching in the sources of the MySQL client and came
up with this:
The errormessage (4) is probably (only place where this error could be
found) raised by this fragment in
Hi list,
We recently installed a new MySQL server (Redhat 8, MySQL 4.0.18, same as
old machine, but with more powerful hardware) and every now and then the
following error appears in the errorlog (the result of the mysql_error()
function of PHP):
Can't connect to MySQL server on
The continuing saga:
Can't connect to MySQL server on '192.168.13.205' (4)
Our sysadmin has been searching in the sources of the MySQL client and came
up with this:
The errormessage (4) is probably (only place where this error could be
found) raised by this fragment in libmysql.c:
if
On Fri, 16 Jan 2004, tait sanders wrote:
yep I've already done this.
everything I do comes back with the same error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
I even deleted the mysql.sock and used 'mysql_config --socket' to
recreate it.
this
Hi,
I'm a newbie to mysql.
I'm running an os10.3 server with mysql v. 4.0.16
When I try to start mysql with 'mysqld_safe ' I get a message that:
Starting mysqld daemon with databases from /var/mysql
040116 10:07:57 mysqld ended
then
nothing... the terminal is blank.
when I then do 'ps auwx | grep
Hi, Tait. It sounds like your server is never actually
starting properly. There could be any number of reasons for
this - it's best to work through the installation instructions
that came with the package.
To see what failed, chances are good there is an entry
in the error log (it will probably
well I found my hostname.err file.
It states this:
mysqld started
InnoDB: Operating system error number 13 in a file operation.
The error means that mysqld does not have the access rights to the
directory.
mysqld ended.
so okay - how do I give mysqld the rights to the directory??
I've got mysql
On Fri, Jan 16, 2004 at 12:04:38PM +1100, tait sanders wrote:
well I found my hostname.err file.
It states this:
mysqld started
InnoDB: Operating system error number 13 in a file operation.
The error means that mysqld does not have the access rights to the
directory.
mysqld ended.
so
On 16/01/2004, at 12:32 PM, Gregory Newby wrote:
From your description, it's not clear whether you already did this.
If you installed other than with a binary distribution from
mysql.com (or a mirror), it is possible that things are in somewhat
different locations than in the INSTALL-BINARY file.
Hi,
I'm a newbie with MySQL and get the following error:
bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
I get this whenever I attempt to connect to MySQL.
I am running Slackware 8.1, MySQL Max 3.23.54b.
I have set
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Jonh,
You're probably forget the -p param for mysqladmin ask you your root
password.
merlin
Escreveu John Wilkerson em Thursday 02 January 2003 04:11 am:
Hi,
I'm a newbie with MySQL and get the following error:
bin/mysqladmin:
; [EMAIL PROTECTED]
Subject: Re: Can't connect error 10061 - nothing but Mascon
works remotely.
Dear Daevid,
I don't have mySQL installed on the XP box, so I can't run
mysqladmin.
I knew your answer to this before I pressed the send button ;-)
Do install MySQL on your Win XP box
Subject: RE: Can't connect error 10061 - nothing but Mascon works
remotely.
[root@daevid]# mysqladmin ping -h daevid.com -uroot -p
Enter password:
mysqld is alive
[root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p
Enter password:
mysqld is alive
-Original Message-
From: Stefan
[root@daevid]# mysqladmin ping -h daevid.com -uroot -p
[root@daevid]#
mysqladmin ping -h 192.168.1.254 -uroot -p mysqld is alive
But as I see, you tried the ping from the local host (i.e.
you connected from the same machine where the MySQL server is
running). What happens if you try
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: 'Listen Hinz' [EMAIL PROTECTED]
Sent: Monday, December 09, 2002 9:09 PM
Subject: RE: Can't connect error 10061 - nothing but Mascon works remotely.
[root@daevid]# mysqladmin ping -h daevid.com -uroot -p
[root@daevid]#
mysqladmin ping -h 192.168.1.254
]]
Sent: Friday, December 06, 2002 8:55 PM
To: Daevid Vincent
Subject: RE: Can't connect error 10061 - nothing but Mascon
works remotely.
Can you send me some details like:
- The error msg. that SQLYog is reporting.
- Are you using SSH or SSL?
- Are you able to connect thru mysql.exe
: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Daevid Vincent [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: 'Karam Chand' [EMAIL PROTECTED]
Sent: Sunday, December 08, 2002 9:37 PM
Subject: RE: Can't connect error 10061 - nothing but Mascon works remotely.
Error No. 2003
: Sunday, December 08, 2002 1:53 PM
To: Daevid Vincent; [EMAIL PROTECTED]
Cc: 'Karam Chand'
Subject: Re: Can't connect error 10061 - nothing but Mascon
works remotely.
Can't connect to MySQL server on 'daevid.com'(10061)
Try mysqladmin ping -h mysql_host_name. This is the most
basic thing I
Subject: Re: Can't connect error 10061 - nothing but Mascon
works remotely.
Greetings...
Check out with your MySQL server administration. Are you able
to connect through the MySQL command line utility.
Probably your MySQL is not configured for remote connection.
Rgds
Insane
Sorry for jumping in late, but are you saying that you can't connect from a
remote machine?
Did you add a Host '%' to your username in the users table?
At 07:36 PM 12/8/2002 -0800, Daevid Vincent wrote:
*I* am the admin. I don't have a command line utility on my WinXP box.
The command line
it.
[root@daevid root]# uname -r
2.4.18-14
-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 08, 2002 8:26 PM
To: Daevid Vincent
Cc: [EMAIL PROTECTED]; 'Insanely Great'
Subject: RE: Can't connect error 10061 - nothing but Mascon
works remotely
I'm having a strange problem connecting via remote to mySQL. This is an
internal LAN, so there should be no firewall issues. I'm running RedHat
8.0, but I've installed the latest mySQL rpms which I thought were
statically linked to avoid the earlier problem of this same nature. The
peculiar thing
I had mysql running fine on linux (redhat 7.1 ).
Today I get this error: can't connect to local Mysql server through socket
'/tmp/mysql.sock.'
Thanks for any advice.
-
Before posting, please check:
Hello Daniel!
I had mysql running fine on linux (redhat 7.1 ).
Today I get this error: can't connect to local Mysql server through socket
'/tmp/mysql.sock.'
Shooting[trouble] tips:
Does 'cat /etc/my.cnf |grep socket' confirm the path to the sock for both
server and client? Should be yes if
i am getting error 10060 when i try to connect to a remote mysql server.
Any idea why this is happening
thanx in advance
kishor
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Hi,
I am not able to connect mysql server through other machine in a
network. I have already assign the user using the command of Grant all on
*.* to user@ipaddress identified by password. Then, try to connect using
mysql -u user@ipaddress -h firstserver -ppassword.But, I got
Hi,
I am not able to connect mysql server through other
machine in a
network. I have already assign the user using the command of
Grant all on
*.* to user@ipaddress identified by password. Then, try to connect using
mysql -u user@ipaddress -h firstserver -ppassword.But, I
What does this mean and how do I fix it, I just finished installing from
source tar.
[root@Precious /]# mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Dave
32 matches
Mail list logo