Re: [gentoo-dev] Bugzilla Bug #109301 dev-db/mysql-4.1.14 stable request.

[Jeff Smelser <tradergt@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 1061 bytes --]

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. Restart 
is usually the only thing that fixes this.. 

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

And you do NOT need the flush priv command after grant statements, only when 
you go after the priv tables directly.

Jeff

[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]