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 <[EMAIL PROTECTED]> Developer, Hardened Gentoo Linux
pgpd8cfoCMICg.pgp
Description: PGP signature