Can't connect to MySQL from remote

I have some problems with MySQL 3.23.52 on RedHat Linux 8.0.

I can connect to mysql when I am on the same machine but I can't connect to
it from another machine. Here is the error I get:

> mysqladmin -u cedric -h gdvi02 version
mysqladmin: connect to server at 'gdvi02' failed
error: 'Lost connection to MySQL server during query'

What's the problem ?

Cédric Pillonel

Cédric Pillonel wrote:

>I have some problems with MySQL 3.23.52 on RedHat Linux 8.0.
>
>I can connect to mysql when I am on the same machine but I can't connectto
>it from another machine. Here is the error I get:
>
>
>
>>mysqladmin -u cedric -h gdvi02 version
>>
>>
>mysqladmin: connect to server at 'gdvi02' failed
>error: 'Lost connection to MySQL server during query'
>
>What's the problem ?
>
>Cédric Pillonel
>
>
>
>
>
Are you sure it is set up to listen on the network? The default
configuration is often to listen only on Unix socket.

Check the configration file for the skip-networking option.

--
J. D. Addison
email (E-Mail Removed)

C�ric Pillonel wrote:

> I have some problems with MySQL 3.23.52 on RedHat Linux 8.0.
>
> I can connect to mysql when I am on the same machine but I can't connect
> to it from another machine. Here is the error I get:
>
>> mysqladmin -u cedric -h gdvi02 version
> mysqladmin: connect to server at 'gdvi02' failed
> error: 'Lost connection to MySQL server during query'
>
> What's the problem ?

Most likely permissions. You must grant a combination of user and host
permissions to access MySQL and the database. It is all spelled out in the
MySQL documentation.

--
Paul Lutus
http://www.arachnoid.com

Hi,

might be a permission issue, as merntioned but the error could also
indicate a networking
or timeout issue. are you expecting a large recordset to be returned ?
If so, you might
want to try otherwise. Furthermore, you might want to give the ODBC
Drivers available at
http://www.openlinksw.co.uk a go.

Hth,
Regards,
Jan


Paul Lutus <(E-Mail Removed)> wrote in message news:<(E-Mail Removed)>...
> C ric Pillonel wrote:
>
> > I have some problems with MySQL 3.23.52 on RedHat Linux 8.0.
> >
> > I can connect to mysql when I am on the same machine but I can't connect
> > to it from another machine. Here is the error I get:
> >
> >> mysqladmin -u cedric -h gdvi02 version
> > mysqladmin: connect to server at 'gdvi02' failed
> > error: 'Lost connection to MySQL server during query'
> >
> > What's the problem ?
>
> Most likely permissions. You must grant a combination of user and host
> permissions to access MySQL and the database. It is all spelled out in the
> MySQL documentation.