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 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)
******************************************************************
_______________________________________________
Openbsd-newbies mailing list
[email protected]
http://mailman.theapt.org/listinfo/openbsd-newbies
