I've been having the same problem with WinXP to MySQL running under a
totally "up2date-ed" Red Hat 8 installation. What I did was to modify my
/etc/my.cnf to look like:
[mysqld]
datadir=/raid/mysql
socket=/raid/mysql/mysql.sock
set-variable=max_allowed_packet=10M
set-variable=thread_stack=1M
[mysql.server]
user=mysql
basedir=/raid
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
port=3306
socket=/raid/mysql/mysql.sock
That, according to a Bugzilla note at Red Hat (which, IIRC, mentions the
problem being with glibc) should fix the problem.
And it did - sort of. The MySQLGUI.exe Windows client could connect from
WinXP, but Access databases through MyODBC would not. After taking a close
look at the c:\my.cnf file:
[mysqld]
datadir=/raid/mysql
socket=/raid/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/raid
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
seems correct to me.
There was one thing missing: When configuring the MyODBC driver, I had to
check the option
Read options from C:\my.cnf
for this to work.
The **really** strange thing is that I have a different database on the same
RedHat 8 server, and I **didn't** have to select that option for it to
connect...
Cheers,
Mike
-----Original Message-----
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 25, 2003 7:18 PM
To: Scott Lewis; [EMAIL PROTECTED]
Subject: Re: Cannot connect from WInXp > MYSQL server - help
Scott,
most probably, you've got a glibc problem on your Red Hat box. Try
upgrading to a newer version of glibc, and if the problem (mysqld dies
when trying to connect from anywhere else than localhost) has gone, I
was right :)
(There was a very similar question a couple of days ago on this list. I
don't know if the Red Hat problem is exactly the same as the SuSE
problem I could solve by updating glibc, but the symptom is the same.)
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: "Scott Lewis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 25, 2003 6:51 PM
Subject: Cannot connect from WInXp > MYSQL server - help
> OK,
>
> I have a mysql server running on my home server. The main os is
Redhat8.
>
> I know that Mysql is running on port 3306 as its showing as listening.
I
> ahve opened the tcp port for boh internal and external connections -
fione.
> I ahve also disbaled it to test aswell.
>
> Anyway - I have loaded several MYsql clients on my winxp pro pc on my
home
> LAN, eg Dbmanager. I ahve set the settinsg fine, and each time I try
and
> connection I get the error:-
>
> Lost connection to mysql durring query.
>
> In the loags it says:-
>
> Number of processes running now: 1
> mysqld process hanging, pid 2522 - killed
> 030125 17:49:36 mysqld restarted
> /usr/libexec/mysqld: ready for connections
>
>
> So - its killing the pid, which I assume is my connections.
>
> Any ideas on what to look for.
>
> Scott
> www.toptravelsites.net
> www.myeyes-youreyes.co.uk
>
>
>
> ---------------------------------------------------------------------
> 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://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
