Re: MySQL refuses to work

On 3 Mar 1999 HyperMail_www_at_associate.com wrote:

> Several people in this list have reported success with getting MySQL to
> run. The most popular "trick" was to get the o version of glibc, which I
> did. I'm not sure if most people build MySQL from source (tar.gz) or from
> SRPM. I tried it with 3.21.30rh50 and with 3.22.19a, which is the current
> release. In both cases, I am unable to connect to the server locally,
> which is not what I experienced on a i386 RH5.1 box.

        I'm just trying to figure this out, but...um...why did you send it to the hypermail list again? <grin>

> I've worked at this for many hours and can create tables with mysqladmin,
> but cannot seem to do anything that requires a database connection. Examples:
>
> > mysqladmin ping
> mysqladmin: connect to server at 'localhost' failed
> error: ''
> > mysqladmin -h mysite.com ping
> mysqladmin: connect to server at 'mysite.com' failed
> error: 'Lost connection to MySQL server during query'
> > mysqladmin -h mysite.com reload
> mysqladmin: connect to server at 'mysite.com' failed
> error: 'Lost connection to MySQL server during query'
> > mysqladmin -h mysite.com status
> mysqladmin: connect to server at 'mysite.com' failed
> error: 'Lost connection to MySQL server during query'
> > mysql
> ERROR:
>
> >From another box, I get this reply when I try to telnet in:
> GHost 'myisp.com' is not allowed to connect to this MySQL serverConnection
> closed by foreign host.

        Try this:

        $MySQLHOME #> bin/mysql -u root -p<root's passwd> test

        This let me connect to my test db (or any other DB for that matter) and you can setup individual users that are allowed to use the db. Your mileage may vary.

        AMK4

--
H | Command, n.:
  |   Statement presented by a human and accepted by a computer in
  |   such a manner as to make the human feel as if he is in control.
  |____________________________________________________________________
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  Ashley M. Kirchner <ashley_at_pcraft.com>          .   303.442.6410 x130
  SysAdmin / Websmith                           .     800.441.3873 x130
  Photo Craft Laboratories, Inc.             .        3550 Arapahoe Ave
  http://www.pcraft.com                  .            Boulder, CO 80303
  .................. .  .  .     .