mysql access problem

[soc at visca.com]

At 09:49 AM 9/7/2009 -0400, Frank Bax wrote:
>It could be a change you made.  Does using ip address in place of 
>"localhost" work?  I've seen this before, but I don't remember how to 
>fix it properly when it happens.

Thanks for your comments, but no joy.

Lou



>Lou Hevly wrote:
>>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 obuch at 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)
>>******************************************************************
>
>_______________________________________________
>Openbsd-newbies mailing list
>Openbsd-newbies at sfobug.org
>http://mailman.theapt.org/listinfo/openbsd-newbies

-- 
All the best (Adéu-siau),
Lou Hevly
soc at visca.com
http://visca.com