Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 16 Apr 1998 13:53:03 +0200 (CEST)
From:      Gediminas Vilutis <gedas@itpa.lt>
To:        freebsd-questions@FreeBSD.ORG, ken@mui.net
Subject:   RE: mysql
Message-ID:  <Pine.BSF.3.96.980416131634.13242A-100000@mserv.itpa.lt>

next in thread | raw e-mail | index | archive | help

I assume that you didn't set root password in mysql (if you did, then
run mysql[admin] with -p switch ;) )

Now if we talk about FreeBSD, "make-localhost" script (that comes with
system) creates reverse DNS file for 127 network in which 127.0.0.1
resolves to localhost.domain.tld (localhost.mui.net in your case). Mysql
install procedure creates grant tables, in which access is granted to
root@localhost simply. So, either hack mysql install scripts and
make them to use 'localhost.mui.net' instead of simple 'localhost', or
make your DNS server to resolve 127.0.0.1 as localhost

>I installed mysql, but now it sez:
>
>access denied for user: 'root@localhost.mui.net' (using password: 
>NO).

Gedas


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.980416131634.13242A-100000>