Date: Sun, 30 Nov 2003 17:54:09 +0100 From: Melvyn Sopacua <freebsd-questions@webteckies.org> To: "FreeBSD-questions" <questions@FreeBSD.ORG> Cc: Xpression <admin@atenas.cult.cu> Subject: Re: MySQL question... Message-ID: <200311301754.09828.freebsd-questions@webteckies.org> In-Reply-To: <000801c3b760$28c246b0$0901a8c0@bloodlust> References: <000801c3b760$28c246b0$0901a8c0@bloodlust>
next in thread | previous in thread | raw e-mail | index | archive | help
--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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200311301754.09828.freebsd-questions>