MySQL Privileges

Charles Curley charlescurley at charlescurley.com
Fri Mar 18 09:54:43 MST 2005


I'm having a problem with MySQL privileges. SeLinux is turned off, so
should not be an issue.

As root, I can create a database, customers, and grant privileges on
it to user ccurley.

mysql> select * from db where Db='customers';
+------+-----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db        | User    | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+------+-----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| %    | customers | ccurley | Y           | Y           | Y           | Y           | Y           | Y         | N          | Y               | Y          | Y          |
+------+-----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
1 row in set (0.01 sec)

mysql> show grants for ccurley;
+--------------------------------------------------------------+
| Grants for ccurley@%                                         |
+--------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON `customers`.* TO 'ccurley'@'%'       |
...
+--------------------------------------------------------------+
4 rows in set (0.00 sec)

As the user, I cannot use the database:

mysql> use customers;
ERROR 1044: Access denied for user: '@localhost' to database 'customers'

What am I doing wrong?

-- 

Charles Curley                  /"\    ASCII Ribbon Campaign
Looking for fine software       \ /    Respect for open standards
and/or writing?                  X     No HTML/RTF in email
http://www.charlescurley.com    / \    No M$ Word docs in email

Key fingerprint = CE5C 6645 A45A 64E4 94C0  809C FFF6 4C48 4ECD DFDB
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://plug.org/pipermail/plug/attachments/20050318/e1137ee7/attachment.bin 


More information about the PLUG mailing list