I created two users with grant; obdba with select,insert,index,file and
other privileges and obdbu with select only privileges. Flushed
privileges. Mysqlaccess shows the correct perms for database
'properties' (the only database) for each user although when I try
logging in as either user to test I get access denied every time. what
did I do wrong? here's the output of mysqlaccess if it helps.
Thank you, justin
oba:~# mysqlaccess obdba properties
Could not open outputfile ~/mysqlaccess.log for debugging-info
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier ([EMAIL PROTECTED])
Changes by Steve Harvey ([EMAIL PROTECTED])
This software comes with ABSOLUTELY NO WARRANTY.
Access-rights
for USER 'obdba', from HOST 'localhost', to DB 'properties'
+-----------------+---+ +-----------------+---+
| Select_priv | Y | | Shutdown_priv | N |
| Insert_priv | Y | | Process_priv | N |
| Update_priv | N | | File_priv | Y |
| Delete_priv | Y | | Grant_priv | N |
| Create_priv | N | | References_priv | N |
| Drop_priv | N | | Index_priv | Y |
| Reload_priv | N | | Alter_priv | Y |
+-----------------+---+ +-----------------+---+
NOTE: A password is required for user `obdba' :-(
The following rules are used:
db :
'localhost','properties','obdba','Y','Y','N','Y','N','N','N','N','Y','Y'
host : 'Not processed: host-field is not empty in db-table.'
user :
'localhost','obdba','255c3b646e0fb525','N','N','N','N','N','N','N','N','
N','Y','N','N','N','N'
oba:~# mysqlaccess obdbu properties
Could not open outputfile ~/mysqlaccess.log for debugging-info
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier ([EMAIL PROTECTED])
Changes by Steve Harvey ([EMAIL PROTECTED])
This software comes with ABSOLUTELY NO WARRANTY.
Access-rights
for USER 'obdbu', from HOST 'localhost', to DB 'properties'
+-----------------+---+ +-----------------+---+
| Select_priv | Y | | 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 |
+-----------------+---+ +-----------------+---+
NOTE: A password is required for user `obdbu' :-(
The following rules are used:
db : 'No matching rule'
host : 'Not processed: host-field is not empty in db-table.'
user :
'localhost','obdbu','62ee70220efa4cb8','Y','N','N','N','N','N','N','N','
N','N','N','N','N','N'
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
