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