>>Most things I've read say to establish a "mysql" user -I take it this >>is to run the daemon(mysqld?) under? Correct
>>Is the above user one that will be created in the users table of the >>mysql db? What mysql privileges does such a user need? No, this is a unix/linux user that is used to run the daemon like you mentioned above. >>Also, why is a mysql "root" user needed and what mysql privileges does >>that user need? This is the "Super User" for mysql. It is set up as root so you can login to mysql after the initial install and immediately get to work. The root user is only set up for localhost privileges though, so you could not connect from another computer through TCPIP and login to mysql. One thing you need to remember is that Users in mysql, really have no connection to unix/linux users except that if you don't use any username directive (mysql -u uname) it will use the unix/linux username to log you in with. >>I usually make "myself" a mysql superuser, should I do that? usually a good idea, that way you can add mysql users to the list of people that can use the databases. Hope this helps. Roger -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 14, 2002 8:12 PM To: MySQL List Subject: running mysql (mysql users) I wish to attempt to clarify one of my earlier questions: Most things I've read say to establish a "mysql" user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? Also, why is a mysql "root" user needed and what mysql privileges does that user need? 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? Thanks, TR --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
