On Fri, Mar 18, 2005 at 10:02:25AM -0700, TJ Hunter wrote:
> GRANT ALL PRIVILEGES ON `customers`.* TO 'ccurley'@'%'
>
> is not the same as
>
> GRANT ALL PRIVILEGES ON `customers`.* TO 'ccurley'@'localhost'
>
> if you want to allow access to users from localhost, you have to
> specify that. Doin
> 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
<[EMA
Charles Curley wrote:
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';
+--+---+-+-+
GRANT ALL PRIVILEGES ON `customers`.* TO 'ccurley'@'%'
is not the same as
GRANT ALL PRIVILEGES ON `customers`.* TO 'ccurley'@'localhost'
if you want to allow access to users from localhost, you have to
specify that. Doing '%' grant won't do it.
As a side note, if the user will always only be c
