MySQL Privileges

Stephen Ward sjward at gmail.com
Fri Mar 18 10:09:42 MST 2005


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

Not sure if this is absolutely necessary in this case, but it never
hurts to flush the privileges.

mysql> flush privileges;

Cheers,
Stephen


On Fri, 18 Mar 2005 09:54:43 -0700, Charles Curley
<charlescurley at charlescurley.com> wrote:
> 
> 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
> 
> 
> .===================================.
> | This has been a P.L.U.G. mailing. |
> |      Don't Fear the Penguin.      |
> |  IRC: #utah at irc.freenode.net   |
> `==================================='
> 
> 
>



More information about the PLUG mailing list