On Mon, Jul 07, 2003 at 02:17:43PM -0400, Xpression wrote: > Can I have a special account to manage a specific service, > specifically MySQL. I mean, I running MySQL as mysql user, but when I want > to update the database I have to login as root, made changes and so on, > then, I want to create another user to this job, I have added a user as > member of wheel and assigned permissions in the current database directory > of MySQL and nothing happens...when I try to connect to the database it give > me an ERROR...
Shouldn't you be using MySQL users? You don't need to put your admin users' UNIX accounts in wheel - just create a MySQL user account with the appropriate rights, and let your admin use that. MySQL accounts are completely separate from UNIX accounts (I got caught out in the beginning, too). So, userx logs in to their userx UNIX account, then will need to connect to MySQL as adminuser to be able to manage the database. You will find more info about it all at http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#User_Account_Management The online documentation is really pretty good. HTH, Dan -- Daniel Bye PGP Key: ftp://ftp.slightlystrange.org/pgpkey/dan.asc PGP Key fingerprint: 3B9D 8BBB EB03 BA83 5DB4 3B88 86FC F03A 90A1 BE8F _ ASCII ribbon campaign ( ) - against HTML, vCards and X - proprietary attachments in e-mail / \
Description: PGP signature