From owner-freebsd-questions@FreeBSD.ORG  Sun Nov 30 08:54:12 2003
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id DF88416A4CE
	for <questions@FreeBSD.ORG>; Sun, 30 Nov 2003 08:54:12 -0800 (PST)
Received: from morpheus.webteckies.org (node123e0.a2000.nl [24.132.35.224])
	by mx1.FreeBSD.org (Postfix) with ESMTP id EAD9243FAF
	for <questions@FreeBSD.ORG>; Sun, 30 Nov 2003 08:54:11 -0800 (PST)
	(envelope-from freebsd-questions@webteckies.org)
Received: from sarevok.idg.nl (unknown [192.168.1.12])
	by morpheus.webteckies.org (Postfix) with ESMTP
	id E4FEB107C6; Sun, 30 Nov 2003 17:50:52 +0100 (CET)
From: Melvyn Sopacua <freebsd-questions@webteckies.org>
Organization: WebTeckies.org
To: "FreeBSD-questions" <questions@FreeBSD.ORG>
Date: Sun, 30 Nov 2003 17:54:09 +0100
User-Agent: KMail/1.5.93
References: <000801c3b760$28c246b0$0901a8c0@bloodlust>
In-Reply-To: <000801c3b760$28c246b0$0901a8c0@bloodlust>
MIME-Version: 1.0
Content-Type: multipart/signed;
  protocol="application/pgp-signature";
  micalg=pgp-sha1;
  boundary="Boundary-02=_xCiy/rxH9IklFFr";
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <200311301754.09828.freebsd-questions@webteckies.org>
cc: Xpression <admin@atenas.cult.cu>
Subject: Re: MySQL question...
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 30 Nov 2003 16:54:13 -0000


--Boundary-02=_xCiy/rxH9IklFFr
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Sunday 30 November 2003 17:36, Xpression wrote:

>         Hi all, I've finished installing MySQL on
> FreeBSD-4.5 RELEASE, now I've to add the users to control
> their databases, but I'm confused...

Right. Because this is not a FreeBSD issue but a MySQL issue. MySQL users h=
ave=20
nothing to do with the local users for the operating system.

You only need the 'mysql' user, which is created by the port, and read:
http://www.mysql.com/doc/en/Privileges.html

All databases will go under /var/db/mysql and the quick and dirty answer is:
mysql -e "GRANT ALL ON $dbname.* TO '$dbuser'@'localhost' IDENTIFIED BY=20
'$userpasswd'"

=2D-=20
Melvyn

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D
=46reeBSD sarevok.webteckies.org 5.2-BETA FreeBSD 5.2-BETA #1: Sat Nov 29=20
00:15:33 CET 2003     root@sarevok.webteckies.org:/usr/obj/usr/src/sys/
SAREVOK_NOFW_DBG  i386
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D

--Boundary-02=_xCiy/rxH9IklFFr
Content-Type: application/pgp-signature
Content-Description: signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (FreeBSD)

iD8DBQA/yiCxOv9JNmfFN5URAsZsAJ9+ChMQ1yrgS+MkKqo6Pqf0Nii+kACfXWWQ
3jSu0IQLgCgJr1WyxtcBISc=
=LoCH
-----END PGP SIGNATURE-----

--Boundary-02=_xCiy/rxH9IklFFr--