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 1ESHVU-0001WI-Kf
	for garchives@archives.gentoo.org; Wed, 19 Oct 2005 17:13:41 +0000
Received: from robin.gentoo.org (localhost [127.0.0.1])
	by robin.gentoo.org (8.13.5/8.13.5) with SMTP id j9JHANJ1005738;
	Wed, 19 Oct 2005 17:10:23 GMT
Received: from mail2.performics.com (mail2.performics.com [63.240.137.252])
	by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id j9JH75eE011084
	for <gentoo-dev@lists.gentoo.org>; Wed, 19 Oct 2005 17:07:06 GMT
Received: from [172.18.33.41] ([172.18.33.41]) by mail2.performics.com with Microsoft SMTPSVC(6.0.3790.211);
	 Wed, 19 Oct 2005 12:14:10 -0500
From: Jeff Smelser <tradergt@gmail.com>
To: gentoo-dev@lists.gentoo.org
Subject: Re: [gentoo-dev] Bugzilla Bug #109301 dev-db/mysql-4.1.14 stable request.
Date: Wed, 19 Oct 2005 12:10:10 -0500
User-Agent: KMail/1.8.2
References: <200510171606.29351.vivo@gentoo.org> <20051019124600.GB16978@peter.avira.local>
In-Reply-To: <20051019124600.GB16978@peter.avira.local>
Precedence: bulk
List-Post: <mailto:gentoo-dev@lists.gentoo.org>
List-Help: <mailto:gentoo-dev+help@gentoo.org>
List-Unsubscribe: <mailto:gentoo-dev+unsubscribe@gentoo.org>
List-Subscribe: <mailto:gentoo-dev+subscribe@gentoo.org>
List-Id: Gentoo Linux mail <gentoo-dev.gentoo.org>
X-BeenThere: gentoo-dev@gentoo.org
Reply-to: gentoo-dev@lists.gentoo.org
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart1510986.hgNuxB2Xgu";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <200510191210.13078.tradergt@gmail.com>
X-OriginalArrivalTime: 19 Oct 2005 17:14:10.0792 (UTC) FILETIME=[857F3680:01C5D4D0]
X-Archives-Salt: 3cd577f0-2598-4c3b-b9d4-ce55f2d6282c
X-Archives-Hash: 594cd428fae6e737fa9b71acd564da2c

--nextPart1510986.hgNuxB2Xgu
Content-Type: text/plain;
  charset="iso-8859-6"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Wednesday 19 October 2005 07:46 am, Petre Rodan wrote:
> is that
> grant all privileges on 'DB'.* to 'user'@'localhost' identified by
> 'password'; deprecated in 4.1?
> because it inserts the line in mysql.users, but authentication is
> impossible :/

Do it here all the time..

> 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?

I have seen this when the mysql tables are out of scope with mysqld. Restar=
t=20
is usually the only thing that fixes this..=20

Unless you have MAX_CONNECTIONS_PER_HOUR defined to low somewhere.. show=20
global viariables like 'MAX_CONNECTIONS_PER_HOUR' will show that.. (somethi=
ng=20
to the affect)

And you do NOT need the flush priv command after grant statements, only whe=
n=20
you go after the priv tables directly.

Jeff

--nextPart1510986.hgNuxB2Xgu
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQBDVn31oOk9EvUvEtgRAt13AKDpo+fm6p0Pyw8tnZb1CfjsgGrr6ACfeQ1M
8JdXqmO8z+EEpexKZh3bBx8=
=vPXA
-----END PGP SIGNATURE-----

--nextPart1510986.hgNuxB2Xgu--
-- 
gentoo-dev@gentoo.org mailing list