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 [EMAIL PROTECTED] |
+--------------------------------------------------------------+
| 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
pgpMoi6GgG00e.pgp
Description: PGP signature
.===================================. | This has been a P.L.U.G. mailing. | | Don't Fear the Penguin. | | IRC: #utah at irc.freenode.net | `==================================='
