From owner-freebsd-ports  Wed Oct  1 03:36:16 1997
Return-Path: <owner-freebsd-ports>
Received: (from root@localhost)
          by hub.freebsd.org (8.8.7/8.8.7) id DAA05254
          for ports-outgoing; Wed, 1 Oct 1997 03:36:16 -0700 (PDT)
Received: from gate.mgt.msk.ru (mgtrep.24h.dialup.ru [194.87.18.139])
          by hub.freebsd.org (8.8.7/8.8.7) with ESMTP id DAA05248;
          Wed, 1 Oct 1997 03:36:09 -0700 (PDT)
Received: from asteroid.mgt.msk.ru (asteroid.mgt.msk.ru [192.168.133.145])
	by gate.mgt.msk.ru (8.8.6/8.8.6) with ESMTP id OAA04696;
	Wed, 1 Oct 1997 14:34:22 +0400 (MSD)
Received: from asteroid.mgt.msk.ru (localhost.mgt.msk.ru [127.0.0.1])
	by asteroid.mgt.msk.ru (8.8.7/8.8.6) with ESMTP id OAA15757;
	Wed, 1 Oct 1997 14:34:07 +0400 (MSD)
Message-Id: <199710011034.OAA15757@asteroid.mgt.msk.ru>
To: Donald Burr <dburr@POBoxes.com>
cc: FreeBSD Ports <freebsd-ports@FreeBSD.ORG>,
        FreeBSD Questions <freebsd-questions@FreeBSD.ORG>
Reply-To: tarkhil@mgt.msk.ru
Subject: Re: how to use mysql port/package 
In-reply-to: Your message of "Wed, 01 Oct 1997 02:45:39 PDT."
             <XFMail.971001025439.dburr@POBoxes.com> 
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Wed, 01 Oct 1997 14:34:06 +0400
From: "Alexander B. Povolotsky" <tarkhil@mgt.msk.ru>
Sender: owner-freebsd-ports@FreeBSD.ORG
X-Loop: FreeBSD.org
Precedence: bulk

> I'd like to get the mysql package or port working, but have had no success
> so far.  I have tried both the package and the port (both in
> FreeBSD-current).  Basically, I am always getting "access denied" when
> accessing any database, as any user (even root).
> 
> The MySQL faq (installed in /usr/local/share/doc/mysql) was less than
> helpful.  In fact, it provided NO information to help me even get started
> fixing this problem.  I had to go to the mysql tarball for that: the file
> INSTALL-BINARY in said tarball mentions a "mysql_install_db" script that
> is to be run if you wish to reset all of the databases and permissions to
> the default (which specify that root has access to everything).  It says
> to remove all of the /var/db/mysql/mysql/*.{ISD,ISM} files then run the
> mysql_install_db script.  I tried this several times, but it does not
> help.  I still get "access denied" messages, such as:
> 
> # try to access the "test" database
> [root@DonaldBurr:120 ~]# mysql test
> ERROR: Access denied
A common bug/feature. You've installed permissions for root@localhost, but 
mysqld sees you as localhost.your.fully.qualified.domain. Fix scripts 
creating access database, and all will run happily.

Alex.