Re: Can't connect (error 2003) to mysql 5.0 on other server
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 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 @mycompA rather than @localhost. Alternatively, > try > >telnet mycompA 3306 > > from both machines to see if you get an answer. > > If it doesn't let you in, check to see if mysql was started with > --skip-networking on A, and look for anything which blocks mysql's port. > > Michael > > Mike Bosschaert wrote: > > 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 to MySQL server on 'mycompA' (111) > > > > On mycompA the user [EMAIL PROTECTED] has all privileges. > > > > This is what tcpdump reports: > > tcpdump: listening on eth1 port 3306 > > 13:50:32.732182 mycompB.33431 > mycompA.mysql: S 2312810184:2312810184(0) > > win 5840 (DF) > > 13:50:32.732570 mycompA.mysql > mycompBt.33431: R 0:0(0) ack 2312810185 > > win 0 (DF) > > > > Any suggestions? > > > > Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect (error 2003) to mysql 5.0 on other server
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 @mycompA rather than @localhost. Alternatively, try telnet mycompA 3306 from both machines to see if you get an answer. If it doesn't let you in, check to see if mysql was started with --skip-networking on A, and look for anything which blocks mysql's port. Michael Mike Bosschaert wrote: 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 to MySQL server on 'mycompA' (111) On mycompA the user [EMAIL PROTECTED] has all privileges. This is what tcpdump reports: tcpdump: listening on eth1 port 3306 13:50:32.732182 mycompB.33431 > mycompA.mysql: S 2312810184:2312810184(0) win 5840 (DF) 13:50:32.732570 mycompA.mysql > mycompBt.33431: R 0:0(0) ack 2312810185 win 0 (DF) Any suggestions? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't connect (error 2003) to mysql 5.0 on other server
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 to MySQL server on 'mycompA' (111) On mycompA the user [EMAIL PROTECTED] has all privileges. This is what tcpdump reports: tcpdump: listening on eth1 port 3306 13:50:32.732182 mycompB.33431 > mycompA.mysql: S 2312810184:2312810184(0) win 5840 (DF) 13:50:32.732570 mycompA.mysql > mycompBt.33431: R 0:0(0) ack 2312810185 win 0 (DF) Any suggestions? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysterious "can't connect" error message in our logs(2)
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 connections to the socket. -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator <___/ www.mysql.com Larnaca, Cyprus Meet the MySQL at User Conference ! (April 14-16, 2004) http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysterious "can't connect" error message in our logs(2)
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 libmysql.c:
if ((sock = (my_socket) socket(AF_INET,SOCK_STREAM,0)) == SOCKET_ERROR)
{
net->last_errno=CR_IPSOCK_ERROR;
sprintf(net->last_error,ER(net->last_errno),socket_errno);
goto error;
}
According to:
http://www-users.cs.umn.edu/~bentlema/unix/syscalls_and_ipc.html
this is what happens:
1) The MySQL client tries to create a new socket.
2) At that moment the thread is interupted by a signal. Control is passed to
the signal handler.
3) After the signal handler has done his work, control goes back to the
original thread. The socket() function notices that it was interupted and
returns the error-code.
If you look at the sample code in section 8.1 of the url above
for (;;) {
rmask = mask;
nfound = select(FD_SETSIZE, &rmask, (fd_set *)0, (fd_set *)0,
&timeout);
if (nfound < 0) {
if (errno == EINTR) {
printf("interrupted system call\n");
continue;
}
/* something is very wrong! */
perror("select");
exit(1);
}
(...)
The client should try again if the EINTR error was returned.
Did we do something wrong in the configuration of the server or is this a
tiny bug?
Regards, Jigal.
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/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysterious "can't connect" error message in our logs(2)
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 ((sock = (my_socket) socket(AF_INET,SOCK_STREAM,0)) == SOCKET_ERROR)
{
net->last_errno=CR_IPSOCK_ERROR;
sprintf(net->last_error,ER(net->last_errno),socket_errno);
goto error;
}
According to:
http://www-users.cs.umn.edu/~bentlema/unix/syscalls_and_ipc.html
this is what happens:
1) The MySQL client tries to create a new socket.
2) At that moment the thread is interupted by a signal. Control is passed to
the signal handler.
3) After the signal handler has done his work, control goes back to the
original thread. The socket() function notices that it was interupted and
returns the error-code.
If you look at the sample code in section 8.1 of the url above
for (;;) {
rmask = mask;
nfound = select(FD_SETSIZE, &rmask, (fd_set *)0, (fd_set *)0,
&timeout);
if (nfound < 0) {
if (errno == EINTR) {
printf("interrupted system call\n");
continue;
}
/* something is very wrong! */
perror("select");
exit(1);
}
(...)
The client should try again if the EINTR error was returned.
Did we do something wrong in the configuration of the server or is this a
tiny bug?
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysterious "can't connect" error message in our logs
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 '192.168.13.205' (4) The errorcode '4' on Linux is supposed to mean "interrupted system call". Yeah, like that's gonna help? Any ideas in what direction we might have to search to solve this challenge? Thanx in advance (also on behalve of our sysadmin) Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: newbie - connect error
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 produces a new mysql.sock but then trying to start mysql produces > the error of before. > > can i uninstall mysql rather than deleting it. I've tried the 'rpm' > utility but it's not on my os. > > thanks heaps for all your help. You can see if MySQL is actually running with ps. If it is running you can see what socket it's using with `netstat -a | grep mysql` You can try to connect through tcp/ip instead of the socket by using -h 127.0.0.1 at the commandline. If the server isn't up, the info should be in the error log why it doesn't like to start. cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: newbie - connect error
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. But get the file (it comes with the distributions you download) so you can see the steps. 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 produces a new mysql.sock but then trying to start mysql produces the error of before. can i uninstall mysql rather than deleting it. I've tried the 'rpm' utility but it's not on my os. thanks heaps for all your help. ta tait tait sanders computer technician sir robert webster bldg trc unsw
Re: newbie - connect error
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 okay - how do I give mysqld the rights to the directory?? Here are the steps from INSTALL-BINARY, a file you should already have with your MySQL software: shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell> ln -s full-path-to-mysql-VERSION-OS mysql shell> cd mysql *shell> scripts/mysql_install_db *shell> chown -R root . *shell> chown -R mysql data *shell> chgrp -R mysql . shell> bin/mysqld_safe --user=mysql & The starred items are the ones you need to pay attention to. You'll need to run them as root, of course. Make sure you have a user called mysql, and a group called mysql. >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. But get the file (it comes with the distributions you download) so you can see the steps. It sounds like you are almost there! -- Greg > I've got mysql installed in /usr/bin/mysql > and > the db's and logs in /var/mysql - this is where the mysql db itself is. > > ta > tait > > > On 16/01/2004, at 10:36 AM, Gregory Newby wrote: > > >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 be named "hostname.err" where > >"hostname" is your system's name) under your data directory > >(perhaps /usr/local/mysql/data, but you might have installed > >it in another location). View with something like this: > > tail /usr/local/mysql/data/hostname.err > > > >If you can't find the data directory or the err file, > >chances are that something fundamental is misconfigured > >(such as file permissions or directory locations). For this > >go to the instructions in INSTALL-BINARY or whatever's appropriate > >for your build, and make sure you've followed them all. > > > >I hope this helps! > > -- Greg > > > >On Fri, Jan 16, 2004 at 10:16:16AM +1100, tait sanders wrote: > >>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 mysql' I get that only the grep process > >>is running. > >> > >>then when I do 'mysql -u root' I get this error: > >>ERROR 2002: Can't connect to local MySQL server through socket > >>'/tmp/mysql.sock' (61) > >> > >>I checked in /tmp and mysql.sock is there. > >> > >>I'm think that there's something wrong with my /var/mysql database? > >>Also thinking that I'd be best off re-installing mysql - but how? > >>I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is > >>not available. > >> > >>any help appreciated. > >> > >>ta > >>tait > >> > >> > >> > >> > >> > >>tait sanders > >>computer technician > >>sir robert webster bldg > >>trc > >>unsw > > > >Dr. Gregory B. Newby, Research Faculty, Arctic Region Supercomputing > >Center > >University of Alaska Fairbanks. PO Box 756020, Fairbanks, AK 99775 > >e: newby AT arsc.edu v: 907-474-7160 f: 907-474-5494 w: > >www.arsc.edu/~newby > > > > > tait sanders > computer technician > sir robert webster bldg > trc > unsw > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: newbie - connect error
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 installed in /usr/bin/mysql and the db's and logs in /var/mysql - this is where the mysql db itself is. ta tait On 16/01/2004, at 10:36 AM, Gregory Newby wrote: 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 be named "hostname.err" where "hostname" is your system's name) under your data directory (perhaps /usr/local/mysql/data, but you might have installed it in another location). View with something like this: tail /usr/local/mysql/data/hostname.err If you can't find the data directory or the err file, chances are that something fundamental is misconfigured (such as file permissions or directory locations). For this go to the instructions in INSTALL-BINARY or whatever's appropriate for your build, and make sure you've followed them all. I hope this helps! -- Greg On Fri, Jan 16, 2004 at 10:16:16AM +1100, tait sanders wrote: 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 mysql' I get that only the grep process is running. then when I do 'mysql -u root' I get this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) I checked in /tmp and mysql.sock is there. I'm think that there's something wrong with my /var/mysql database? Also thinking that I'd be best off re-installing mysql - but how? I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is not available. any help appreciated. ta tait tait sanders computer technician sir robert webster bldg trc unsw Dr. Gregory B. Newby, Research Faculty, Arctic Region Supercomputing Center University of Alaska Fairbanks. PO Box 756020, Fairbanks, AK 99775 e: newby AT arsc.edu v: 907-474-7160 f: 907-474-5494 w: www.arsc.edu/~newby tait sanders computer technician sir robert webster bldg trc unsw
Re: newbie - connect error
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 be named "hostname.err" where "hostname" is your system's name) under your data directory (perhaps /usr/local/mysql/data, but you might have installed it in another location). View with something like this: tail /usr/local/mysql/data/hostname.err If you can't find the data directory or the err file, chances are that something fundamental is misconfigured (such as file permissions or directory locations). For this go to the instructions in INSTALL-BINARY or whatever's appropriate for your build, and make sure you've followed them all. I hope this helps! -- Greg On Fri, Jan 16, 2004 at 10:16:16AM +1100, tait sanders wrote: > 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 mysql' I get that only the grep process > is running. > > then when I do 'mysql -u root' I get this error: > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (61) > > I checked in /tmp and mysql.sock is there. > > I'm think that there's something wrong with my /var/mysql database? > Also thinking that I'd be best off re-installing mysql - but how? > I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is > not available. > > any help appreciated. > > ta > tait > > > > > > tait sanders > computer technician > sir robert webster bldg > trc > unsw Dr. Gregory B. Newby, Research Faculty, Arctic Region Supercomputing Center University of Alaska Fairbanks. PO Box 756020, Fairbanks, AK 99775 e: newby AT arsc.edu v: 907-474-7160 f: 907-474-5494 w: www.arsc.edu/~newby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
newbie - connect error
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 mysql' I get that only the grep process is running. then when I do 'mysql -u root' I get this error: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) I checked in /tmp and mysql.sock is there. I'm think that there's something wrong with my /var/mysql database? Also thinking that I'd be best off re-installing mysql - but how? I've tried 'rpm -qa \ grep MySQL' but aparently this 'rpm' command is not available. any help appreciated. ta tait tait sanders computer technician sir robert webster bldg trc unsw
Re: Connect Error
-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: 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 the MySQL root password. What am I missing? > > TIA, > > John > - -- Merlin, the Mage Que os vosso(s) Deus(es) vos abençoe(m) E a vida vos ame e proteja. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE+FIzgKOMrqDFTeBARApO8AKCszGgvPbe6PoeU1oXtCfRGSm+BcgCggPBw ZpvYwUf3XcsWJgPRflwoG5M= =klHF -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connect Error
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 the MySQL root password. What am I missing? TIA, John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't connect error 10061 - nothing but Mascon works remotely - SOLVED (sorta)
Well, I still don't know what was causing the problem exactly, but there was something in WindowsXP Pro that was killing my connection. I discovered this by borrowing a notebook computer and putting it on the same network (running WinXP Home) and sure enough, EVERYTHING worked (well, I had to use the IP address rather than the name for some reason -- I think that has to do with the router). So I just started uninstalling things on my main XPP box and rebooted. Lo and behold, it connects! Not to mention that a lot of other internet programs that I've been wanting to use work now too. I figured they just didn't work b/c I had a router and the internal LAN and stuff. ;-) I still have no idea why Mascon worked the whole time however. > -Original Message- > From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 1:38 PM > To: Daevid Vincent; [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. The installation > procedure will not > start the MySQL server, so there's nothing to worry about. If > you leave the > defaults as is, this will install MySQL in C:\mysql. > > Open a DOS box and cd to C:\mysql\bin. Here, you will find > all the *.exe > files. Try mysqladmin ping again. If this doesn't work with > host name and/or > ip address, there's probably some tricky network problem > involved (for which > Mascon might have an even trickier solution, e.g. some > registry entry). > > HTH! > -- > Stefan Hinz <[EMAIL PROTECTED]> > CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > > > - Original Message - > From: "Daevid Vincent" <[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 -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 this from the Win XP box? > > > > I don't have mySQL installed on the XP box, so I can't run > mysqladmin. > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. The installation procedure will not start the MySQL server, so there's nothing to worry about. If you leave the defaults as is, this will install MySQL in C:\mysql. Open a DOS box and cd to C:\mysql\bin. Here, you will find all the *.exe files. Try mysqladmin ping again. If this doesn't work with host name and/or ip address, there's probably some tricky network problem involved (for which Mascon might have an even trickier solution, e.g. some registry entry). HTH! -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Daevid Vincent" <[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 -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 this from the Win XP box? > > I don't have mySQL installed on the XP box, so I can't run mysqladmin. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 -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 this from the Win XP box? I don't have mySQL installed on the XP box, so I can't run mysqladmin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect error 10061 - nothing but Mascon works remotely.
Dear Daevid, > [root@daevid]# mysqladmin ping -h daevid.com -uroot -p > [root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p > mysqld is alive So this means a connection is possible, and it doesn't matter whether you issue a host name or an ip number. Now you have two programs that can access the MySQL server: Mascon and mysqladmin. 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 this from the Win XP box? Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Daevid Vincent" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]> Sent: Monday, December 09, 2002 12:18 AM 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 Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] > Sent: 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 can think of to connect to a MySQL server. It > should report "mysqld is alive". > > If even that doesn't work, try "mysqladmin ping -h > 192.168.1.1" (or whatever your server host ip is). If that > fails, too, mail your Mascon connection settings to the list, > so someone more savvy than me may find out what's happening. > > HTH! > -- > Stefan Hinz <[EMAIL PROTECTED]> > CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +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 > > Can't connect to MySQL server on 'daevid.com'(10061) > > > > This is the same error I get with all the other programs too... > > > > No SSH or SSL. > > > > I'm connecting from my WinXP box to my Linux server over my > local LAN. > > > > > -Original Message- > > > From: Karam Chand [mailto:[EMAIL PROTECTED]] > > > 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 ( console > > > client to mysql ) > > > > > > > > > > > > > > > --- Daevid Vincent <[EMAIL PROTECTED]> wrote: > > > > Yes. I've done this all before, and I am aware of > > > > the RH8 glibc issue, > > > > but I thought that the current RPMS on the mysql > > > > site fixed that. 'cept > > > > it doesn't. I don't understand why mascon works but > > > > other windows > > > > clients don't work when everything else is the same. > > > > > > > > > -Original Message- > > > > > From: Karam Chand [mailto:[EMAIL PROTECTED]] > > > > > > > > > Sent: Thursday, December 05, 2002 9:02 PM > > > > > To: Daevid Vincent > > > > > Subject: Re: Can't connect error 10061 - nothing > > > > but Mascon > > > > > works remotely. > > > > > > > > > > > > > > > Are you trying to access Linux MySQL from a > > > > Windows > > > > > machine? > > > > > > > > > > If yes, you can try SQLYog at > > > > http://www.webyog.com > > > > > > > > > > __
RE: Can't connect error 10061 - nothing but Mascon works remotely.
Yes. I can not connect remotely using ANY Microsoft Windows clients/tools EXCEPT "Mascon" -- which for some strange reason works just fine. Yet EVERY OTHER WINDOWS mySQL PROGRAM fails with the same error message (10061 Can't connect...) I'm 98% positive my 'permissions' are correct in the mysql database tables: mysql> select * from host; +-++-+-+-+-- ---+-+---++-+--- -++ | Host| Db | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-++-+-+-+-- ---+-+---++-+--- -++ | localhost | % | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | 192.168.0.% | % | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | %daevid%| % | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | | 192.168.1.% | % | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +-++-+-+-+-- ---+-+---++-+--- -++ Mysql> select * from user; +-+--+--+-+- +-+-+-+---+-+--- +--+---++-+- ---++ | Host| User | password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+--+--+-+- +-+-+-+---+-+--- +--+---++-+- ---++ | localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | | localhost | | | N | N | N | N | N | N | N | N | N| N | N | N | N | N | | 192.168.0.% | root | 6463872834e37889 | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | | 192.168.1.% | root | 6463872834e37889 | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | +-+--+--+-+- +-+-+-+---+-+--- +--+---++-+- ---++ Again, I suspect it has to do with RH8, as this all worked fine before the upgrade... [root@daevid root]# rpm -qa | grep "glib" -i glibc-2.2.93-5 glib2-2.0.6-2 glibc-kernheaders-2.4-7.20 glibc-utils-2.2.93-5 glib-devel-1.2.10-8 glib2-devel-2.0.6-2 glibc-common-2.2.93-5 glib-1.2.10-8 glibc-devel-2.2.93-5 [root@daevid root]# rpm -qa | grep "mysql" -i MySQL-client-3.23.53a-1 MySQL-python-0.9.1-4 libdbi-dbd-mysql-0.6.5-2 MySQL-bench-3.23.53a-1 MySQL-3.23.53a-1 mysql-server-3.23.52-3 MySQL-devel-3.23.53a-1 MySQL-Max-3.23.53a-1 perl-DBD-MySQL-2.1017-3 qt-MySQL-3.0.5-17 mod_auth_mysql-1.11-1 MySQL-shared-3.23.53a-1 php-mysql-4.1.2-7.3.4 I don't think the "mysql-server-3.23.52-3" is really there though b/c I can't "rpm -e" 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. > > > 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
RE: Can't connect error 10061 - nothing but Mascon works remotely.
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 util on Linux works just fine for itself (localhost, daevid.com, 192.168.1.254, etc) MySQL *is* configured properly otherwise "mascon" would not be able to connect either. I've done this for a while. The problem lies either with RedHat 8.0 and their whacked glibc (still) _OR_ the MySQL*.rpm files on the mysql.com site are not statically linked as they say they are. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't connect error 10061 - nothing but Mascon works remotely.
*I* am the admin. I don't have a command line utility on my WinXP box. The command line util on Linux works just fine for itself (localhost, daevid.com, 192.168.1.254, etc) MySQL *is* configured properly otherwise "mascon" would not be able to connect either. I've done this for a while. The problem lies either with RedHat 8.0 and their whacked glibc (still) _OR_ the MySQL*.rpm files on the mysql.com site are not statically linked as they say they are. > -Original Message- > From: Insanely Great [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 08, 2002 7:05 PM > To: Daevid Vincent > 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 > > - Original Message - > From: "Daevid Vincent" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: "'Karam Chand'" <[EMAIL PROTECTED]> > Sent: Monday, December 09, 2002 2:07 AM > Subject: RE: Can't connect error 10061 - nothing but Mascon > works remotely. > > > > Error No. 2003 > > Can't connect to MySQL server on 'daevid.com'(10061) > > > > This is the same error I get with all the other programs too... > > > > No SSH or SSL. > > > > I'm connecting from my WinXP box to my Linux server over my > local LAN. > > > > > -Original Message- > > > From: Karam Chand [mailto:[EMAIL PROTECTED]] > > > 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 ( console > > > client to mysql ) > > > > > > > > > > > > > > > --- Daevid Vincent <[EMAIL PROTECTED]> wrote: > > > > Yes. I've done this all before, and I am aware of > > > > the RH8 glibc issue, > > > > but I thought that the current RPMS on the mysql > > > > site fixed that. 'cept > > > > it doesn't. I don't understand why mascon works but > > > > other windows > > > > clients don't work when everything else is the same. > > > > > > > > > -Original Message- > > > > > From: Karam Chand [mailto:[EMAIL PROTECTED]] > > > > > > > > > Sent: Thursday, December 05, 2002 9:02 PM > > > > > To: Daevid Vincent > > > > > Subject: Re: Can't connect error 10061 - nothing > > > > but Mascon > > > > > works remotely. > > > > > > > > > > > > > > > Are you trying to access Linux MySQL from a > > > > Windows > > > > > machine? > > > > > > > > > > If yes, you can try SQLYog at > > > > http://www.webyog.com > > > > > > > > > > __ > > > > > Do you Yahoo!? > > > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > > > > now. > > > > http://mailplus.yahoo.com > > > > > > > > > > > > > __ > > > Do you Yahoo!? > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > > http://mailplus.yahoo.com > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] > Sent: 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 can think of to connect to a MySQL server. It > should report "mysqld is alive". > > If even that doesn't work, try "mysqladmin ping -h > 192.168.1.1" (or whatever your server host ip is). If that > fails, too, mail your Mascon connection settings to the list, > so someone more savvy than me may find out what's happening. > > HTH! > -- > Stefan Hinz <[EMAIL PROTECTED]> > CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +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 > > Can't connect to MySQL server on 'daevid.com'(10061) > > > > This is the same error I get with all the other programs too... > > > > No SSH or SSL. > > > > I'm connecting from my WinXP box to my Linux server over my > local LAN. > > > > > -Original Message- > > > From: Karam Chand [mailto:[EMAIL PROTECTED]] > > > 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 ( console > > > client to mysql ) > > > > > > > > > > > > > > > --- Daevid Vincent <[EMAIL PROTECTED]> wrote: > > > > Yes. I've done this all before, and I am aware of > > > > the RH8 glibc issue, > > > > but I thought that the current RPMS on the mysql > > > > site fixed that. 'cept > > > > it doesn't. I don't understand why mascon works but > > > > other windows > > > > clients don't work when everything else is the same. > > > > > > > > > -Original Message- > > > > > From: Karam Chand [mailto:[EMAIL PROTECTED]] > > > > > > > > > Sent: Thursday, December 05, 2002 9:02 PM > > > > > To: Daevid Vincent > > > > > Subject: Re: Can't connect error 10061 - nothing > > > > but Mascon > > > > > works remotely. > > > > > > > > > > > > > > > Are you trying to access Linux MySQL from a > > > > Windows > > > > > machine? > > > > > > > > > > If yes, you can try SQLYog at > > > > http://www.webyog.com > > > > > > > > > > __ > > > > > Do you Yahoo!? > > > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > > > > now. > > > > http://mailplus.yahoo.com > > > > > > > > > > > > > __ > > > Do you Yahoo!? > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > > http://mailplus.yahoo.com > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect error 10061 - nothing but Mascon works remotely.
Dear Daevid, > Can't connect to MySQL server on 'daevid.com'(10061) Try "mysqladmin ping -h mysql_host_name". This is the most basic thing I can think of to connect to a MySQL server. It should report "mysqld is alive". If even that doesn't work, try "mysqladmin ping -h 192.168.1.1" (or whatever your server host ip is). If that fails, too, mail your Mascon connection settings to the list, so someone more savvy than me may find out what's happening. HTH! -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +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 > Can't connect to MySQL server on 'daevid.com'(10061) > > This is the same error I get with all the other programs too... > > No SSH or SSL. > > I'm connecting from my WinXP box to my Linux server over my local LAN. > > > -----Original Message- > > From: Karam Chand [mailto:[EMAIL PROTECTED]] > > 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 ( console > > client to mysql ) > > > > > > > > > > --- Daevid Vincent <[EMAIL PROTECTED]> wrote: > > > Yes. I've done this all before, and I am aware of > > > the RH8 glibc issue, > > > but I thought that the current RPMS on the mysql > > > site fixed that. 'cept > > > it doesn't. I don't understand why mascon works but > > > other windows > > > clients don't work when everything else is the same. > > > > > > > -Original Message- > > > > From: Karam Chand [mailto:[EMAIL PROTECTED]] > > > > > > > Sent: Thursday, December 05, 2002 9:02 PM > > > > To: Daevid Vincent > > > > Subject: Re: Can't connect error 10061 - nothing > > > but Mascon > > > > works remotely. > > > > > > > > > > > > Are you trying to access Linux MySQL from a > > > Windows > > > > machine? > > > > > > > > If yes, you can try SQLYog at > > > http://www.webyog.com > > > > > > > > __ > > > > Do you Yahoo!? > > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > > > now. > > > http://mailplus.yahoo.com > > > > > > > > > __ > > Do you Yahoo!? > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > http://mailplus.yahoo.com > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't connect error 10061 - nothing but Mascon works remotely.
Error No. 2003 Can't connect to MySQL server on 'daevid.com'(10061) This is the same error I get with all the other programs too... No SSH or SSL. I'm connecting from my WinXP box to my Linux server over my local LAN. > -Original Message- > From: Karam Chand [mailto:[EMAIL PROTECTED]] > 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 ( console > client to mysql ) > > > > > --- Daevid Vincent <[EMAIL PROTECTED]> wrote: > > Yes. I've done this all before, and I am aware of > > the RH8 glibc issue, > > but I thought that the current RPMS on the mysql > > site fixed that. 'cept > > it doesn't. I don't understand why mascon works but > > other windows > > clients don't work when everything else is the same. > > > > > -Original Message----- > > > From: Karam Chand [mailto:[EMAIL PROTECTED]] > > > > > Sent: Thursday, December 05, 2002 9:02 PM > > > To: Daevid Vincent > > > Subject: Re: Can't connect error 10061 - nothing > > but Mascon > > > works remotely. > > > > > > > > > Are you trying to access Linux MySQL from a > > Windows > > > machine? > > > > > > If yes, you can try SQLYog at > > http://www.webyog.com > > > > > > __ > > > Do you Yahoo!? > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > > now. > > http://mailplus.yahoo.com > > > > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 is that "Mascon" will connect and work just fine, but NO other programs will, and I've tried: mySQL-front, DBTools-manager, mySQL-GUI and mySQL AB's very own "myCC" (which I thought for sure would work). This all started b/c I'm trying to get Datanamic's DeZign to work. It's always error '10061', and yes, my 'mysql' databse table permissions are all correct AFAIK. Again, "Mascon" works just fine which is the baffling part. [root@daevid SAMBA]# rpm -qa | grep "mysql" -i MySQL-client-3.23.53a-1 MySQL-Max-3.23.53a-1 MySQL-python-0.9.1-4 libdbi-dbd-mysql-0.6.5-2 MySQL-bench-3.23.53a-1 MySQL-devel-3.23.53a-1 perl-DBD-MySQL-2.1017-3 qt-MySQL-3.0.5-17 mod_auth_mysql-1.11-1 MySQL-shared-3.23.53a-1 php-mysql-4.1.2-7.3.4 MySQL-3.23.53a-1 I try to telnet to the port, and it 'looks' like it works, although there's a bunch of gibberish at the end that makes me nervous, but mebbe it's supposed to be like that? [root@daevid SAMBA]# telnet 192.168.1.254 3306 Trying 192.168.1.254... Connected to 192.168.1.254. Escape character is '^]'. - 3.23.53a-Max2qe%)<3(, Connection closed by foreign host. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie can't connect error
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 it was running before. Does 'ps -auxwww |grep mysqld' say something's running? Does 'mysqladmin -p status' confirm that the server running? Check the log for why the server may have stopped. In a pinch, restart the server. Usually works unless there's some more fundamental problem. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie can't connect error
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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connect Error
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't connect error 111
> 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 the > following error. > > Warning: MySQL Connection Failed: Can't connect to MySQL server on > 'dns1.3dsources.com' (111) in /home/trade-revenues/require/password.php on > line 1 > 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 the > following error. > > Warning: MySQL Connection Failed: Can't connect to MySQL server on > 'dns1.3dsources.com' (111) in /home/trade-revenues/require/password.php on > line 1 You tried to connect using the mysql client, and got an error from... php... Try "mysql -u user -h firstserver -ppassword", the @ipaddress is your own ip address and is automatically detected, it is NOT part of the username. > oh I forgot to tell, I have used a firewall "ipchains". what > port do I have > to open for mysql: tcp or udp Port 3306, tcp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't connect error 111
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 the following error. Warning: MySQL Connection Failed: Can't connect to MySQL server on 'dns1.3dsources.com' (111) in /home/trade-revenues/require/password.php on line 1 oh I forgot to tell, I have used a firewall "ipchains". what port do I have to open for mysql: tcp or udp Thank you Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connect error
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
