From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.50) id 1ESDME-0002ja-OV for garchives@archives.gentoo.org; Wed, 19 Oct 2005 12:47:51 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id j9JCjHvC028270; Wed, 19 Oct 2005 12:45:17 GMT Received: from node19.avira.ro (node19.avira.ro [193.226.114.19]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id j9JChZK1013156 for ; Wed, 19 Oct 2005 12:43:36 GMT Received: (qmail 8237 invoked from network); 19 Oct 2005 12:45:58 -0000 Received: from naliboat.avira.local (10.2.0.3) by node19.avira.ro with (DHE-RSA-AES256-SHA encrypted) SMTP; 19 Oct 2005 12:45:58 -0000 Received: (qmail 25253 invoked from network); 19 Oct 2005 12:45:58 -0000 Received: from prodanw.avira.local (HELO peter) (10.4.1.1) by naliboat.avira.local with SMTP; 19 Oct 2005 12:45:58 -0000 Date: Wed, 19 Oct 2005 15:46:00 +0300 From: Petre Rodan To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] Bugzilla Bug #109301 dev-db/mysql-4.1.14 stable request. Message-ID: <20051019124600.GB16978@peter.avira.local> Mail-Followup-To: gentoo-dev@lists.gentoo.org References: <200510171606.29351.vivo@gentoo.org> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@gentoo.org Reply-to: gentoo-dev@lists.gentoo.org Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="qcHopEYAB45HaUaB" Content-Disposition: inline In-Reply-To: <200510171606.29351.vivo@gentoo.org> User-Agent: mutt-ng/devel (Linux) X-Archives-Salt: 7e69f8da-6678-4b02-ab40-65fd1f080554 X-Archives-Hash: 58d781619a98bcc8f691a917177526e1 --qcHopEYAB45HaUaB Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi, On Mon, Oct 17, 2005 at 04:06:29PM +0200, Francesco R. wrote: > mysql-4.1.14 has been added to the tree on 29 Aug 2005, should be time=20 > to stabilize the 4.1 branch of mysql. quick question regarding this new version. is that grant all privileges on 'DB'.* to 'user'@'localhost' identified by 'passwor= d'; deprecated in 4.1? because it inserts the line in mysql.users, but authentication is impossibl= e :/ I had to use this syntax to get things going: GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY 'password' WITH MAX_= QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0; GRANT ALL PRIVILEGES ON `DB`.* TO 'user'@'localhost'; maybe it would be a Good Thing(TM) to add this to the upgrade document? bye, peter --=20 petre rodan Developer, Hardened Gentoo Linux=20 --qcHopEYAB45HaUaB Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2-ecc0.1.6 (GNU/Linux) iD8DBQFDVkAIixMPpwVd7zERAngmAKDFlFIztRrWiA7cgB9s3V4ZlTwyOQCgmSZT 3mfJE/Pwba2yNhxuiAY6BZk= =1/JA -----END PGP SIGNATURE----- --qcHopEYAB45HaUaB-- -- gentoo-dev@gentoo.org mailing list