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

Reply via email to