Date: Mon, 7 Jul 2003 19:25:17 +0100 From: Daniel Bye <dan@slightlystrange.org> To: FreeBSD-questions <freebsd-questions@FreeBSD.ORG> Subject: Re: Users question... Message-ID: <20030707182517.GC79983@catflap.home.slightlystrange.org> In-Reply-To: <005601c344b4$119e3990$0501a8c0@bloodlust> References: <005601c344b4$119e3990$0501a8c0@bloodlust>
next in thread | previous in thread | raw e-mail | index | archive | help
--hYooF8G/hrfVAmum Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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 g= ive > 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_Ad= ministration.html#User_Account_Management The online documentation is really pretty good. HTH, Dan --=20 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 / \ --hYooF8G/hrfVAmum Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQE/CbsNhvzwOpChvo8RAripAKClVwT6UgHqR8IPWcUSVayqVzQ1uACfX44P U1IBw+hi2Ch6eRECmc2cYxg= =p7WK -----END PGP SIGNATURE----- --hYooF8G/hrfVAmum--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030707182517.GC79983>