Users & mySQL User

[Technical Director]

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 at 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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
>