mysql access problem

[Frank Bax]

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.


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)
> ******************************************************************
>