MySQL question...

Melvyn Sopacua freebsd-questions at
Sun Nov 30 08:54:13 PST 2003

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 5.2-BETA FreeBSD 5.2-BETA #1: Sat Nov 29 
00:15:33 CET 2003     root at
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: signature
Url :

More information about the freebsd-questions mailing list