Try: DELETE FROM mysql.user WHERE User='obuch'; DELETE FROM mysql.db WHERE User='obuch'; REPAIR TABLE mysql.user, mysql.db; FLUSH PRIVILEGES;
Which should maybe get both entries in both tables. After all the entries are deleted, do the GRANT ALL ON obuch.* to ... > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Lou Hevly > Sent: Monday, September 07, 2009 10:49 AM > To: [email protected]; [email protected] > Subject: RE: mysql access problem > > At 08:02 AM 9/7/2009 -0500, Tony Aberenthy wrote: > >ob...@localhost grant ALL on obuch.* to ob...@localhost > >identified > >by 'xxxxxxx'; > >obuch...@localhost mysql -u obuchfot -p > >?? the user name > > No, sorry, that should have been obuch; I miscopied. > > > >See what you get from: > >SELECT Host, User, Password, Select_priv FROM mysql.user; > >SELECT Host, Db, User, Select_priv FROM mysql.db; > > > SELECT Host, User, Password, Select_priv FROM mysql.user; > ... > localhost | obuch | 130a5f060ae5aee8 | N > localhost | obuch | 0ec6a87e091493c8 | N > > mysql> SELECT Host, Db, User, Select_priv FROM mysql.db; > ... > localhost | obuch | obuch | Y > localhost | obuch | obuch | Y > > This seems to be it. The "obuch" user (and database) are > listed twice, > and the user has 2 different passwords. > > Now I've run: > /usr/local/bin/mysql_upgrade > and everything goes fine until it gets to here: > > Running 'mysql_fix_privilege_tables'... > ERROR 1062 (23000) at line 94: Duplicate entry > 'localhost-simi' for key > 1 > ERROR 1062 (23000) at line 163: Duplicate entry 'localhost-simi' for > key 1 > ERROR 1062 (23000) at line 202: Duplicate entry 'localhost-simi' for > key 1 > ERROR 1062 (23000) at line 207: Duplicate entry 'localhost-simi' for > key 1 > FATAL ERROR: Upgrade failed > > And it's true that there is also a duplicate entry for 'simi'. > > When I ran /usr/local/bin/mysql_fix_privilege_tables --password=xxxxxx > no error showed. > > So I tried to drop the user obuch: > > mysql> drop user ob...@localhost; > Query OK, 0 rows affected (0.00 sec) > > mysql> flush privileges; > Query OK, 0 rows affected (0.00 sec) > > mysql> drop user ob...@localhost; > Query OK, 0 rows affected (0.00 sec) > > It says 0 rows affected, which is the case, since both obuch entries > are still in the mysql.user table. In fact, I can't drop any > users at > all using that syntax. > > I suppose this is something pretty basic, but I haven't been able to > Google anything useful. I can't seem to drop users. > > Thanks for your help. > > Lou > > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[email protected]] On Behalf Of Lou Hevly > > > Sent: Monday, September 07, 2009 5:40 AM > > > To: [email protected] > > > Subject: mysql access problem > > > > > > Hello: > > > > > > I'm running MYSQL mysql-server-5.0.51a on 4.3. > > > > > > One of my users called this morning and said he could no > > > longer connect to his database. It was working fine last > > > Tuesday and he claims to have made no changes. The error is > > > "Access denied". So I tried regranting his privileges (the > > > obuch database exists at > > > /var/mysql/obuch): > > > > > > ************************************************************** > > > $ mysql -u root -p > > > Enter password: ******* > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > > Your MySQL connection id is 516738 > > > Server version: 5.0.51a-log OpenBSD port: mysql-server-5.0.51a > > > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > > mysql> grant ALL on obuch.* to ob...@localhost identified by > > > 'xxxxxxx'; > > > Query OK, 0 rows affected (0.00 sec) > > > > > > mysql> flush privileges; > > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > > > > > mysql> quit > > > Bye > > > > > > $ mysql -u obuchfot -p > > > Enter password: xxxxxxx > > > ERROR 1045 (28000): Access denied for user 'obuchfot'@'localhost' > > > (using password: YES) > > > ****************************************************************** > > > > > > -- > > > All the best (Adéu-siau), > > > Lou Hevly > > > [email protected] > > > http://visca.com > > > > > > _______________________________________________ > > > Openbsd-newbies mailing list > > > [email protected] > > > http://mailman.theapt.org/listinfo/openbsd-newbies > > -- > All the best (Adéu-siau), > Lou Hevly > [email protected] > http://visca.com > > _______________________________________________ > Openbsd-newbies mailing list > [email protected] > http://mailman.theapt.org/listinfo/openbsd-newbies > _______________________________________________ Openbsd-newbies mailing list [email protected] http://mailman.theapt.org/listinfo/openbsd-newbies
