Users mySQL User

2003-09-23 Thread H. Bartel
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 [EMAIL PROTECTED] 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
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Users mySQL User

2003-09-23 Thread 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 [EMAIL PROTECTED] 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
 ___
 [EMAIL PROTECTED] mailing list
 http://lists.freebsd.org/mailman/listinfo/freebsd-questions
 To unsubscribe, send any mail to [EMAIL PROTECTED]
 

___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]