-----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