]
> Sent: 07 May 2009 15:09
> To: Jim Lyons
> Cc: John Clement; mysql@lists.mysql.com
> Subject: Re: grant user create privilege
>
> Did you flush privileges after creating the user?
>
> On Thu, 2009-05-07 at 08:54 -0500, Jim Lyons wrote:
> > It's hard to believe
From: Jim Lyons [mailto:jlyons4...@gmail.com]
> Sent: 07 May 2009 14:55
> To: John Clement
> Cc: mysql@lists.mysql.com
> Subject: Re: grant user create privilege
>
> It's hard to believe this to be the case since I assume you've created
> other
> databases in
Did you flush privileges after creating the user?
On Thu, 2009-05-07 at 08:54 -0500, Jim Lyons wrote:
> It's hard to believe this to be the case since I assume you've created other
> databases in this instance, but the error on "create database", which is
> essentially a "mkdir" in Unix, makes me
It's hard to believe this to be the case since I assume you've created other
databases in this instance, but the error on "create database", which is
essentially a "mkdir" in Unix, makes me wonder if you don't have a file
permissions error on the datadir directory.
On Wed, May 6, 2009 at 9:14 AM,
John,
Are you loggin in as:
mysql -u 'user' -p
If not, you should (from the local host obviously).
The other thing to check is once you are logged in, run the following command:
mysql> show grants;
This will tell you what the grants are for the user that is logged in
(and whether or not you are
Sebastian Mendel schrieb:
Hiep Nguyen schrieb:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
privileges on test as same as internal.
how do i do thi
On Wed, Apr 16, 2008 at 1:18 PM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
>
> is there any command that can set so that admin's privileges on internal =
> admin's privileges on test???
>
> what i'm trying to avoid is manually adjust admin's privileges on test if
> admin's privileges on internal cha
On Wed, 16 Apr 2008, Daniel Brown wrote:
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
hi all, i have an existing database (internal) with a user named 'admin',
everything works fine as far as privileges concern.
i just created a new database (test) and want to grant
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
> hi all, i have an existing database (internal) with a user named 'admin',
> everything works fine as far as privileges concern.
>
> i just created a new database (test) and want to grant admin's privileges
> on test as same
Hiep Nguyen schrieb:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
privileges on test as same as internal.
how do i do this???
i tried (as root):
g
Can you give the output of the command
show grants for admin;
Thank You,
-srini
Hiep Nguyen wrote:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
pr
March 03, 2008 11:15 AM
Subject: Re: grant user
> On Mon, 3 Mar 2008, Hiep Nguyen wrote:
>
> > hi all, i have a user that can only access localhost, how do i grant
this
> > user permission so that can also be accessed from 192.168.1.50?
> >
> i got it. thanks
> t.
On Mon, 3 Mar 2008, Hiep Nguyen wrote:
hi all, i have a user that can only access localhost, how do i grant this
user permission so that can also be accessed from 192.168.1.50?
i got it. thanks
t. hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
GRANT [ALL PRIVILEGES|Appropriate Privileges] *.* TO root@'192.168.1.50'
IDENTIFIED BY '' WITH GRANT OPTION;
Or if you want a root user from a subnet
GRANT [ALL PRIVILEGES|Appropriate Privileges]ON *.* TO root@'192.168.1.%'
IDENTIFIED BY '' WITH GRANT OPTION;
http://dev.mysql.com/doc/refman/5.
Chris,
Thursday, April 18, 2002, 8:50:06 PM, you wrote:
CS> Is there any way to grant a user only SELECT permissions on a set of tables
CS> in MySQL, but to also allow them to have CREATE, DROP, and INSERT on the
CS> Database itself??
CS> What I want is a database where the users cannot modify
15 matches
Mail list logo
