From owner-freebsd-questions@FreeBSD.ORG Sat Jan 9 09:56:48 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1B44D1065670 for ; Sat, 9 Jan 2010 09:56:48 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (gate6.infracaninophile.co.uk [IPv6:2001:8b0:151:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id 416E58FC0C for ; Sat, 9 Jan 2010 09:56:47 +0000 (UTC) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost [IPv6:::1]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.4/8.14.3) with ESMTP id o099ug4s001252; Sat, 9 Jan 2010 09:56:43 GMT (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.8.3 smtp.infracaninophile.co.uk o099ug4s001252 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1263031003; bh=O+jZiQa6wlUNm2FOqVgNS5NqKoTDtdh9k40Z4a/HHZY=; h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References: In-Reply-To:Content-Type:Cc:Content-Type:Date:From:In-Reply-To: Message-ID:Mime-Version:References:To; z=Message-ID:=20<4B4852D4.90002@infracaninophile.co.uk>|Date:=20Sat ,=2009=20Jan=202010=2009:56:36=20+0000|From:=20Matthew=20Seaman=20 |Organization:=20Infracaninophile |User-Agent:=20Thunderbird=202.0.0.23=20(X11/20091129)|MIME-Versio n:=201.0|To:=20jaymax=20|CC:=20freebsd-questio ns@freebsd.org|Subject:=20Re:=20mySQL=205.4=20server=20&=20Post=20 installation=20SNAFUs|References:=20<27086064.post@talk.nabble.com >|In-Reply-To:=20<27086064.post@talk.nabble.com>|X-Enigmail-Versio n:=200.95.6|Content-Type:=20multipart/signed=3B=20micalg=3Dpgp-sha 256=3B=0D=0A=20protocol=3D"application/pgp-signature"=3B=0D=0A=20b oundary=3D"------------enig356694F821A63F20B605B4AC"; b=xZ/hsTK3453CnjVOsCoRj5w07sn9Pwl0iYKmbALg/VvKA8nlb+HiEzY1tmxE/o1dv GZLIeN1Dq/2eKWs8Wb93QhLIcxmFEfNPlG3i6T6AzjXudWp4Fhxm21XEFdBAs6aZdr pKp6Nyx00/gTIheEnWDhpepousiS+zRHYuPfRLhQ= X-Authentication-Warning: happy-idiot-talk.infracaninophile.co.uk: Host localhost [IPv6:::1] claimed to be happy-idiot-talk.infracaninophile.co.uk Message-ID: <4B4852D4.90002@infracaninophile.co.uk> Date: Sat, 09 Jan 2010 09:56:36 +0000 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.23 (X11/20091129) MIME-Version: 1.0 To: jaymax References: <27086064.post@talk.nabble.com> In-Reply-To: <27086064.post@talk.nabble.com> X-Enigmail-Version: 0.95.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enig356694F821A63F20B605B4AC" X-Virus-Scanned: clamav-milter 0.95.3 at happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.9 required=5.0 tests=AWL,BAYES_00,DKIM_SIGNED, DKIM_VERIFIED,NO_RELAYS autolearn=ham version=3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on happy-idiot-talk.infracaninophile.co.uk Cc: freebsd-questions@freebsd.org Subject: Re: mySQL 5.4 server & Post installation SNAFUs X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 09 Jan 2010 09:56:48 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig356694F821A63F20B605B4AC Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable jaymax wrote: > Post installation SNAFUS > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > [i] support-files/mysql.server are apparently in "/usr/local/share/mysq= l" am > I correct, all of them? Yes, except that mysql-server is the rc.subr(8) script to start up mysql = on boot, and that is to be found in /usr/local/etc/rc.d/mysql-server > [ii] mysql_secure_installation is not found in this installation, it is= in > v. 5.5 however. It's part of a different port. You need to install databases/mysql54-scri= pts The same applies to mysql55 actually -- you must have somehow already installed databases/mysql55-scripts in that case. > [iii] Start restricted to /usr/local/bin/mysqld_safe & apparently since= > mysql_secure_installation is not available >=20 > [iv] /usr/local/bin/mysqladmin -u root password =3D=3D>=20 > ax# /usr/local/bin/mysqladmin -u root password 'xxxxxxxx' > /usr/local/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (using password: NO)'= > ax# /usr/local/bin/mysqladmin -u root -h ax.lall.com password xxxxxxxx > /usr/local/bin/mysqladmin: connect to server at 'ax.lall.com' failed > error: 'Access denied for user 'root'@'ax.lall.com' (using password: NO= )' > HOW can I setup root password ? If you're currently logged into ax.lall.com, then you definitely want to use '-h localhost' (or nothing, as that's the default). If there is already a root password, obviously you need to give it. Conversely, if you've got a password set in /root/.my.cnf or some other my.cnf file but this is a brand new mysql install with no root password yet, then you nee= d to temporarily move that file aside: mysql doesn't let you in if you try and supply a password for a no-password account. I advise using mysql_secure_installation -- but you're still going to hav= e to move aside any pre-existing .my.cnf files. Also, as a general securit= y thing, preferably don't allow root logins to mysql from anywhere other th= an localhost. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW --------------enig356694F821A63F20B605B4AC Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREIAAYFAktIUtoACgkQ8Mjk52CukIy9bwCgkhE/NotXK4vWX9s3/BTa3Die sy0An32y0LkPLKTyI+DVGqJynUibDrAo =NfhM -----END PGP SIGNATURE----- --------------enig356694F821A63F20B605B4AC--