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, [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 __ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
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.
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
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.
[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.
*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.
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.
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 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
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
