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 have 
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:

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 


FreeBSD sarevok.webteckies.org 5.2-BETA FreeBSD 5.2-BETA #1: Sat Nov 29 
00:15:33 CET 2003     [EMAIL PROTECTED]:/usr/obj/usr/src/sys/

Attachment: pgp00000.pgp
Description: signature

Reply via email to