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? I'm connecting via ssh. 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'
---------------------------------------------------------------------
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
