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

[Petre Rodan <kaiowas@gentoo.org>]

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


Hi,

On Wed, Oct 19, 2005 at 09:30:19AM -0400, Jeffrey Forman wrote:
> 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.

I did flush a million times. I lost almost 4 hours with this mysql upgrade due to authentication problems.
It worked only when I used the second syntax.

can anyone please check out if you can create a new user with the 'deprecated' version and that you can actually use it in mysql-4.1.14? I invariably got 'bad password for user ...'.

a bug report will follow tomorrow.

thx,
peter

-- 
petre rodan
<kaiowas@gentoo.org>
Developer,
Hardened Gentoo Linux 

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