]
> 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
I'm clearly doing something wrong. All I want is to grant a user rights
to create databases:
grant create on *.* to 'user'@'localhost' identified by 'pass';
doesn't do the trick, nor does
grant super on *.* to 'user'@'localhost' identified by 'pass';
The user in question was originally created
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
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):
grant all on test.* to
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
OPTION;
http://dev.mysql.com/doc/refman/5.0/en/grant.html
-Original Message-
From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2008 10:17 AM
To: mysql@lists.mysql.com
Subject: grant user
hi all, i have a user that can only access localhost, how do i grant this
user perm
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?
thanks
t. hiep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On my servers i'm using the 'user'@'localhost' for PHP apps.
running on the local web-server. Those users allocated for
web-apps can only connect to their specific DB from localhost.
On Tue, May 22, 2007 03:19, Miguel Cardenas wrote:
>> Localhost is indeed a special value that isn't include in '%'
> Hm, I didn't know that! I thought it was only a special value to the
> client tools, which I know will try to connect via socket on UNIX machines
> when they see 'localhost' but will try to connect via TCP/IP when they see
> '127.0.0.1'. Thanks for pointing this out!
>
> Baron
In fact that was
> Localhost is indeed a special value that isn't include in '%'. It's a
> feature not a bug ;)
>
> Regards,
Bingo! That was the point! If i connect to the server ip or server name it
works perfectly, but if I try to connect to localhost it fails unless I add a
new user specific to localhost :D
> If you don't specify a hostname in SHOW GRANTS, '%' is assumed. My mistake
> for not telling you this before. If you enable networking, and connect
> with
>
> mysql -h 127.0.0.1
>
> instead of
>
> mysql -h localhost
Well, in fact 127.0.0.1 and localhost produce the same effect but
Hi,
Miguel Cardenas wrote:
Remember to quote the user and host carefully. So,
The quoting is okay, I tested again
If you have doubts about what you actually granted, do this:
SHOW GRANTS FOR 'user'
I've sent this command:
grant all on mydatabase.* to 'myuser'@'%' identified by 'mypass';
You are still missing the GRANT for 'myuser'@'localhost'
On Mon, May 21, 2007 03:06, Miguel Cardenas wrote:
>> Remember to quote the user and host carefully. So,
>
> The quoting is okay, I tested again
>
>> If you have doubts about what you actually granted, do this:
>> SHOW GRANTS FOR 'user'
>
>
> Remember to quote the user and host carefully. So,
The quoting is okay, I tested again
> If you have doubts about what you actually granted, do this:
> SHOW GRANTS FOR 'user'
I've sent this command:
grant all on mydatabase.* to 'myuser'@'%' identified by 'mypass';
Then tested the show grants
Mathieu Bruneau wrote:
Baron Schwartz a écrit :
Hi,
Miguel Cardenas wrote:
Hello list
I have a problem adding a user with host '%' ...
*** If I add a user with host '%' when trying to connect get this error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES
Baron Schwartz a écrit :
> Hi,
>
> Miguel Cardenas wrote:
>> Hello list
>>
>> I have a problem adding a user with host '%' ...
>>
>> *** If I add a user with host '%' when trying to connect get this error:
>> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
>> password: YES)
Hi,
Miguel Cardenas wrote:
Hello list
I have a problem adding a user with host '%' ...
*** If I add a user with host '%' when trying to connect get this error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES)
*** If I add the same user with localhost it
Hello list
I have a problem adding a user with host '%' ...
*** If I add a user with host '%' when trying to connect get this error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES)
*** If I add the same user with localhost it connects and works fine...
My
Hi!
On Mon 2003-03-10 at 16:44:40 -0500, [EMAIL PROTECTED] wrote:
[...]
> - Given a system user 'junk' I would like to create a "master" user
> 'junk' that can have all permissions (including grant?) on all 'junk_*'
> databases so that he can create and manage his own databases
>
> - Given a
why don't you try...
mysql > SHOW GRANTS for 'junk'@'localhost'
just to see what has been granted at present?
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I am having a bit of trouble with GRANT and users and database access. I
would like to do two things:
- - Given a system user 'junk' I would like to create a "master" user
'junk' that can have all permissions (including grant?) on all '
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
Hello,
Is there any way to grant a user only SELECT permissions on a set of tables
in MySQL, but to also allow them to have CREATE, DROP, and INSERT on the
Database itself??
What I want is a database where the users cannot modify the core tables, but
I want them to be able to CREATE and DROP t
: [EMAIL PROTECTED]
Subject: How to grant user access to specific column
Hi
This is my first question to this group.
Is there anyway to grant access for all users to a table but two columns in
that table should be readonly, and
if username is something else it should have access to those two columns
Hi
This is my first question to this group.
Is there anyway to grant access for all users to a table but two columns in
that table should be readonly, and
if username is something else it should have access to those two columns
with read and write and change.
Regards
Jonas Arvidsson
--
35 matches
Mail list logo
