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

[Jeffrey Forman]

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

Peter,

After adding a person with the grant option, one must usually 'flush
privileges' to update all the tables and allow the person access.


-Jeffrey

-- 

---------------
Jeffrey Forman
Gentoo Infrastructure
Gentoo Release Engineering
bugs.gentoo.org Administrator
jforman@g.o
---------------
-- 
gentoo-dev@g.o mailing list