Date: Wed, 01 Oct 1997 14:34:06 +0400 From: "Alexander B. Povolotsky" <tarkhil@mgt.msk.ru> To: Donald Burr <dburr@POBoxes.com> Cc: FreeBSD Ports <freebsd-ports@FreeBSD.ORG>, FreeBSD Questions <freebsd-questions@FreeBSD.ORG> Subject: Re: how to use mysql port/package Message-ID: <199710011034.OAA15757@asteroid.mgt.msk.ru> In-Reply-To: Your message of "Wed, 01 Oct 1997 02:45:39 PDT." <XFMail.971001025439.dburr@POBoxes.com>
next in thread | previous in thread | raw e-mail | index | archive | help
> 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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?199710011034.OAA15757>