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,
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 wonder
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 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
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 this to be the case since I assume you've
created other
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
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
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 as
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 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 changed.
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
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
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
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):
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]
://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 permission so that can also
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
, 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. hiep
--
MySQL General Mailing List
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 '%'.
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 by using
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
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 the
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)
*** If I add
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:
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:
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'
I've sent
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';
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,
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
-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
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)
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 master
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
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
To: [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
35 matches
Mail list logo