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

[Petre Rodan]

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


bye,
peter

-- 
petre rodan
<kaiowas@g.o>
Developer,
Hardened Gentoo Linux