Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 23 Sep 2003 09:09:57 -0700 (MST)
From:      Technical Director <trodat@ultratrends.com>
To:        "H. Bartel" <lists@u-rep.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Users & mySQL User
Message-ID:  <Pine.BSF.4.21.0309230905110.36827-100000@server1.ultratrends.com>
In-Reply-To: <r02000100-1028-3B28691AEDD711D791EA00306583A5FE@[10.0.0.119]>

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

Holgar,

No. MySQL supports users through the database manager itself. Once MySQL
is running on the system you can add users to the user table found in the 
mysql database.

Remember to 'flush privileges' once this is done to make the changes
apply.

It would also be a really good idea to think/learn about this process
before implementing a production level system using this setup.

eg:

-- Checking out the MySQL documentation at http://www.mysql.com/, a sample
of this: http://www.mysql.com/doc/en/General_security.html
-- Planning 'how' your databases will work as far as access privileges.

R.

On Tue, 23 Sep 2003, H. Bartel wrote:

> Hi,
> 
> I have installed mySQL-Server on my freeBSD 4.8, and now I want to set it up. I can connect to the database with root@localhost and the according password, but I would like to add another user, which would then only be used to connect to the database server.
> Does this need to be another user on my system, or just an "internal" mySQL User? Any hints on how to set this up?
> 
> Thanks, Holger
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
> 



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