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 zope -P
Could not open outputfile ~/mysqlaccess.log for debugging-info
mysqlaccess Version 2.06, 20 Dec 2000
Password for MySQL superuser :
Access-rights
for USER 'zope', from HOST 'localhost', to DB 'zope'
+-----------------+---+ +-----------------+---+
| Select_priv | N | | Shutdown_priv | N |
| Insert_priv | N | | Process_priv | N |
| Update_priv | N | | File_priv | N |
| Delete_priv | N | | Grant_priv | N |
| Create_priv | N | | References_priv | N |
| Drop_priv | N | | Index_priv | N |
| Reload_priv | N | | Alter_priv | N |
+-----------------+---+ +-----------------+---+
BEWARE: Everybody can access your DB as user `zope' from host `localhost'
: WITHOUT supplying a password.
: Be very careful about it!!
BEWARE: Accessing the db as an anonymous user.
: Your username has no relevance
The following rules are used:
db : 'No matching rule'
host : 'Not processed: host-field is not empty in db-table.'
user : 'localhost','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N'
www:~ #
Any suggestions for further diagnostics and solutions?
Thanks, again, everybody, for your help.
-Kevin Zembower
>>> Carl Troein <[EMAIL PROTECTED]> 11/14/01 02:47PM >>>
KEVIN ZEMBOWER writes:
> mysql> grant all on zope.* to zope identified by "xxxxxxx";
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> select * from user where user="zope";
> | % | zope | 34577362486f3680 | N | N | N | N
> | N | N | N | N | N | N
> | N | N | N | N |
> My questions:
> 1. Why didn't this work?
It did work. You granted all privileges on the database zope, but
the privileges in the 'user' table are the _global_ privileges.
Those are what you set with GRANT ... ON *.* ...
To see the ones you set, have a look in the table 'db'.
> 2. If it had worked, would I have seen something other than "zero records affected"
>in response to the GRANT command?
For some reason you always get a 0 back from GRANT. There's probably
some internal reason for this.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
