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 [EMAIL PROTECTED] --------------- -- gentoo-dev@gentoo.org mailing list