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