From owner-freebsd-questions@FreeBSD.ORG Tue Jun 8 21:42:43 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E5D1F16A4CE for ; Tue, 8 Jun 2004 21:42:42 +0000 (GMT) Received: from smtp.infracaninophile.co.uk (ns0.infracaninophile.co.uk [81.2.69.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7A47043D45 for ; Tue, 8 Jun 2004 21:42:41 +0000 (GMT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost.infracaninophile.co.uk [IPv6:::1])i58LgUwb007780 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 8 Jun 2004 22:42:30 +0100 (BST) (envelope-from matthew@happy-idiot-talk.infracaninophile.co.uk) Received: (from matthew@localhost)id i58LgUjB007779; Tue, 8 Jun 2004 22:42:30 +0100 (BST) (envelope-from matthew) Date: Tue, 8 Jun 2004 22:42:30 +0100 From: Matthew Seaman To: RazorOnFreeBSD Message-ID: <20040608214230.GA7575@happy-idiot-talk.infracaninophile.co.uk> Mail-Followup-To: Matthew Seaman , RazorOnFreeBSD , freebsd-questions@freebsd.org References: <00ca01c44d6b$b4887e20$0f01a8c0@razor> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="gKMricLos+KVdGMg" Content-Disposition: inline In-Reply-To: <00ca01c44d6b$b4887e20$0f01a8c0@razor> User-Agent: Mutt/1.5.6i X-Greylist: Message not sent from an IPv4 address, not delayed by milter-greylist-1.3.8 (smtp.infracaninophile.co.uk [0.0.0.0]); Tue, 08 Jun 2004 22:42:30 +0100 (BST) X-Virus-Scanned: clamd / ClamAV version devel-20040604, clamav-milter version 0.71c on smtp.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on happy-idiot-talk.infracaninophile.co.uk cc: freebsd-questions@freebsd.org Subject: Re: mysql user X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Jun 2004 21:42:43 -0000 --gKMricLos+KVdGMg Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Jun 08, 2004 at 05:15:51PM +0200, RazorOnFreeBSD wrote: > I maybe didn't see something, for sure it's a dumb problem.... > I installed MySQL 4.0.20 from sources downloaded on MySQL website and the= n I checked before adding my "mysql" user on the box if there was one .... = I never installed MySQL before and I already have a mysql user but I don't = know his password..... > What should I do ? Uninstall / ReInstall MySQL ? Delete user "mysql" and = create another one ? or is there an obvious first password to change I didn= 't get ? > I'm a little bit lost there... even if it's not an obligation to have thi= s user named "mysql", it's easy to use everyday! A mysql user will be created if you install mysql (any version) from ports. Even if you are strange enough to decide not to use ports, the way the mysql user is set up by the port would be a good thing to copy: mysql:*:88:88::0:0:MySQL Daemon:/var/db/mysql:/sbin/nologin Where UID 88 and group 88 are reserved for MySQL: http://www.freebsd.org/doc/en_US.ISO8859-1/books/porters-handbook/dads-= uid.html This account is designed to be the owner of the MySQL processes and nothing more. Specifically, it has a locked password (the '*' in the second field) and the shell set to /sbin/nologin -- a small program that prints "This account is currently not available." and exits immediately. The home directory shown (/var/db/mysql) is the default, and the location where MySQL keeps its data files. You can override that when installing the port. Note that you never need to login as the mysql user. MySQL has it's own set of user IDs and it's own passwords /within/ the database which are separate from the passwd database on your server. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks Savill Way PGP: http://www.infracaninophile.co.uk/pgpkey Marlow Tel: +44 1628 476614 Bucks., SL7 1TH UK --gKMricLos+KVdGMg Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQFAxjLGiD657aJF7eIRAogBAJ9ba9FCdLwCr6XQda5djgUkAPoRIACfU6rS R21GKAHeszA0cHVaS4UKfVI= =zk0A -----END PGP SIGNATURE----- --gKMricLos+KVdGMg--