Thank you, Carl and Chris, for helping me with this problem. Something else must be
happening, as I still can't log in:
www:~ # mysql -u zope -p
Enter password:
ERROR 1045: Access denied for user: 'zope@localhost' (Using password: YES)
www:~ #
Mysqlaccess shows:
www:~ # mysqlaccess -u zope -d
Yes, I've read this a number of times too. I've also read the section that says "If
you use GRANT, you don't need to use FLUSH PRIVILEGES."
The way that I read this is that GRANT is the "automatic" method, not requiring FLUSH
PRIVILEGES, whereas modifying the tables directly, using INSERT, UPDA
KEVIN ZEMBOWER writes:
> mysql> grant all on zope.* to zope identified by "xxx";
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> select * from user where user="zope";
> | %| zope | 34577362486f3680 | N | N | N | N
>| N | N | N
http://www.mysql.com/doc/P/r/Privilege_changes.html
"If you modify the grant tables manually (using INSERT, UPDATE, etc.),
you should execute a FLUSH PRIVILEGES statement or run mysqladmin
flush-privileges or mysqladmin reload to tell the server to reload the
grant tables. Otherwise your changes
I'm certain I'm making a simple mistake here, but can't find it. Here's what I'm
executing, using mysql 3.23.43-log:
[I'm root when I run this]
#mysql -p mysql
mysql> grant all on zope.* to zope identified by "xxx";
Query OK, 0 rows affected (0.00 sec)
mysql> select * from user where user="
