Date: Thu, 2 Oct 1997 15:07:20 -0400 (EDT) From: spork <spork@super-g.com> To: Keith Mitchell <kmitch@weenix.guru.org> Cc: questions@FreeBSD.ORG Subject: Re: MySQL access problems Message-ID: <Pine.BSF.3.96.971002150219.6187B-100000@super-g.inch.com> In-Reply-To: <199710010011.UAA29290@weenix.guru.org>
next in thread | previous in thread | raw e-mail | index | archive | help
This is my understanding of this... Since FBSD does not have native thread support (in 2.2), you end up using MIT pthreads. For whatever reason, this means that all connections must come from a TCP/IP socket rather than a "file system" socket (sorry for the misnomer). In the end, this means you must connect like so: mysql -h your.machine.com mysql as root, and it will let you in. It took me some time to dig this up, as it's strictly a FreeBSD issue. For whatever reason, "localhost" will not work, you have to use the full name of the machine. In mysql speak, I believe localhost tells it to connect to the (nonexistent) unix socket. Hope this helps, Charles On Tue, 30 Sep 1997, Keith Mitchell wrote: > I just compiled/installed the Mysql port. Everything appears to work except > for the access control stuff. I can't figurew out how to set it up so that > I can use it. > > According to the documentation it is supposed to install default access > that will allow root to access anything. All I can get is : > > ERROR: Access denied for user: 'root' (Using password: YES) > > > Note: It says it is using passwords, yet from what I can tell there are > no password in the access database. > > BTW I am running version 3.20.30b and am running it on a copy of -CURRENT > from about a month ago. > > Anyone have any clues? > > -- > Keith Mitchell Head Administrator: acm.vt.edu > Email: kmitch@weenix.guru.org PGP key available upon request > http://weenix.guru.org/~kmitch > Address and URL (c) 1997 Keith Mitchell - All Rights Reserved > Unauthorized use or duplication prohibited >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.971002150219.6187B-100000>