On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1TR -- ...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.
Yes, that's what I meant, but please see below...
What I'm asking about is to use this created user, username = mysql, to start and I guess stop the server... I mean, is it a mysql user that starts and stops the daemon? That is what I am trying to understand.
% 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.
For example:
To me the manual sort of skips in both the Quick Start and the Adding New Users (section 4.3 and other places), and also this famous website:
http://www.entropy.ch/software/macosx/mysql/#install
(I am not using that installation, I am using Apple's.)
...seem to skip over what this user named "mysql" is actually for?
%What privileges might I NOT give myself as a "normal" user? (just curious, this is not to terribly important for me in this post.)
% 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 very much,
Ted
p.s. I consistently have the problem of starting mysqld manually (which is what I want here)... the problem is that I ALWAYS have to use sudo -s, get root... then I can start it.
Do you know why that might be?
So, I am essentially after *this info if nothing else: is there a user that is either already created by default on my MACHINE (not in mysql) (username = mysql?) such as on my OS X Server (whose docs also do NOT address this) or that I should Add to my MACHINE, that is *solely for running mysqld under? Does "running under" mean or include "starting and stopping"?
---
Does anyone know what NetInfo Manager means when it shows a username (mysql) whose passwd is "*" (an asterisk)? And how I might incorporate that user into... whatever I need it for? :)
---------------------------------------------------------------------
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
