Hi again Mark,
I have completed a re-install from the rpm files MySQL-3.23.53a-1.i386.rpm.
and the client.
I've added in the relevant records to grant myself priv to a database
(marketing) that I have created.
USE mysql;
INSERT INTO host
VALUES('localhost','marketing','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user
Values('localhost','bsafe'PASSWORD('pass123'),'Y','Y','Y','Y','Y','Y','Y','Y
','Y','Y','Y','Y','Y','Y');
INSERT INTO db
VALUES('localhost','marketing','bsafe','Y','Y','Y','Y','Y','Y','Y','Y','Y','
Y');
My RH is 7.2 - when I try to connect via telnet I get "Connection Closed by
Foreign Host"
When you say install "your binaries" are you talking about the one's I have
installed or are there some others.
Thanks for your help.
Kevin
-----Original Message-----
From: Mark Matthews [mailto:mark@;mysql.com]
Sent: 30 October 2002 13:02
To: Kevin Passey
Cc: Mysql (E-mail)
Subject: Re: Errors trying to connect to MYSQL using tomcat - do I need
to open any ports on my firewall or is this done internally?
Kevin Passey wrote:
> Hi Mark,
>
> Thanks for your response, my problem is that I've done that. It works on a
> windows machine running mysql, I've set my Linux machine up the same
> and it
> doesn't work.
>
> The only difference is that I am running MSQL 3.23.51-nt on my windows
> machine and the latest rpm's on my Linux machine.
>
> I thought there may be some known issues with these rpm's - that's why I
> asked the question.
>
> Thanks anyway.
>
> Kevin
What version of Linux? RedHat? If so, a GLIBC upgrade might have broken
your MySQL installation. (Look in the mailing list archives).
What happens when you telnet to port 3306 on your Linux database server
from the machine Tomcat is running on? You should get a MySQL server
answering and waiting for input from the client (which it won't
get)....If it disconnects right away, you have the GLIBC problem, and
you either need to install _our_ binaries for 3.23.53a (preferred), or
downgrade your GLIBC.
-Mark
--
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.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
