-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

TR --

...and then [EMAIL PROTECTED] said...
% 
% I wish to attempt to clarify one of my earlier questions:

That's always helpful :-)


% 
% Most things I've read say to establish a "mysql" user -I take it this 
% is to run the daemon(mysqld?) under?

No; that's a UNIX (or Windows or whatever) user who is running the
daemon.


% Is the above user one that will be created in the users table of the 

Yep.  On a *NIX machine you have users, one (or at least few) of whom are
root and the rest of which are pretty ordinary.  Similarly, inside a
database you have users with various designations.

The users on the machine have nothing to do with the users in the
database.  The two sets are completely separate, even if some of them
('root', 'david', 'guest') may have similar names (and even similar
passwords, if you care to have it that way).


% mysql db? What mysql privileges does such a user need?

It depends on what the user needs to do.  You might have a user who can
only select from and update in one table of one database, or you might
have a user (like a backup job user) who can select from any table in any
database.


% 
% Also, why is a mysql "root" user needed and what mysql privileges does 
% that user need?

It's good to have at least one user who can do anything in the database;
that user not only creates new databases and new users (sometimes delegated
to other accounts with certain limited create capabilities) but also goes
in and fixes things when they get mucked up.


% 
% I do not know how this fits in with the above users (root & mysql) but 
% I usually make "myself" a mysql superuser, should I do that?

Just like you shouldn't casually log in on your machine as root, you
shouldn't casually use a root mysql user for your work.  You might make a
root account for yourself, but also make a normal account and work within
that except when you need special access.


% 
% Thanks,
% 
% TR 


HTH & HAND

mysql query,
:-D
- -- 
David T-G                      * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/    Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE9/IBkGb7uCXufRwARArsQAJ9zpvytbgDTsjWnXKI3pKPmASTQaQCg4nvZ
5fPu2lv1uAgjLlH3Kuaub4s=
=upSJ
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to