At 13:40 -0700 6/3/04, Robert Frame wrote:
Thank you for the reply. I apologize for not
clearly demonstrating what I am trying to
accomplish.
No apology necessary. I know what you're trying to accomplish.
My questions (which you have not answered) are designed to cause
you to think about what
This is probably something simple that I am just not seeing, but I
would appreciate your help.
As root, I have created a schema named test, along with several
tables.
I then created a template user named SysAdmin for test using the
following syntax.
GRANT SELECT, INSERT, UPDATE, DELETE
ON TEST
SysAdmin only has rights to the TEST database. This user will need to be
able to update the mysql database tables and therefore will need access to
the mysql database.
-Original Message-
From: Robert Frame
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:15 AM
Subject: Granting privileges to other
At 9:15 -0700 6/2/04, Robert Frame wrote:
This is probably something simple that I am just not seeing, but I
would appreciate your help.
As root, I have created a schema named test, along with several
tables.
I then created a template user named SysAdmin for test using the
following syntax.
GRANT
I have installed Red Hat 9 and it installs MySQL. After logging on as
root, I did the following:
mysql
mysql use mysql;
mysql grant all
- on *
- to todd indentified by 'my_password'
- with grant option;
I then log out of mysql and log out as root. Logged in as "todd" I
type the following:
You still need to flush the privileges. Changes in permissions are not
automatically committed. Also you should add the host to the username.
grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with
grant option;
flush privileges;
Jamie
On Sun, 2003-08-03 at 09:52, Todd Cary
Jamie -
Two questions:
1) Does "grant all" give the user the rights to create a database.
2) What is the difference between "on * " and "on *.* "
Todd
Jamie Krasnoo wrote:
You still need to flush the privileges. Changes in permissions are not
automatically committed. Also you should
Jamie -
grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with
grant all;
flush privileges;
That definitely works, but what I am not sure about is now -u todd -h localhost has all "Y" in the privileges; before only the first few had "Y".
Why is that? Is that due to the
Hi Todd,
2003 8 4 08:01Todd Cary :
Nils -
What is the difference between *.* and * ?
Hi Todd I just double checked.
There is no difference. Both work the same way. I originally thought that the
first one wouldn't have worked, but I checked it now. However I believe that
*.* is the prober
Hi Todd,
2003 8 4 08:17Todd Cary :
Jamie -
grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with
grant all;
flush privileges;
Flush privileges is not necessary here I believe. Only when you update the
privileges 'manually' with INSERT, UPDATE,DELETE
Best regards
I did some experimenting and here is what I found:
grant all
- on *
- to bugsbunny indentified by 'bugs
- with grant option;
After putting the above into MySQL as root, I signed on as "todd" with
the appropriate PW and tried to get into mysql with
mysql -u bugsbunny -p [using bugs as
Hi Todd,
Thank you for the reply.
I once more created an account.
See below the SHOW GRANTS FOR usertest command. I did login without setting
a default database. If you use the first command * then you will only be
able to login (no other privileges), depending on the mysql version you will
* Todd Cary
I did some experimenting and here is what I found:
[...]
The % in the Host column does not appear to work for me,
and there is something different about * and *.*.
The manual is a usefull source of information... ;)
URL: http://www.mysql.com/doc/en/Adding_users.html
URL:
Roger -
Thank you for taking the time to clarify that for me. I was using "PHP
with MySQL" and they are not clear on the differences I found and you
explained.
Thanks again
Todd
Roger Baklund wrote:
* Todd Cary
I did some experimenting and here is what I found:
Just run mysql in it's own little jail
with --user=mysql # or some username you add to the tables...
Regards,
Kelly Black
-Original Message-
From: Dimitar Haralanov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 4:18 PM
To: [EMAIL PROTECTED]
Subject: Re: granting
: granting privileges using wildcards
That would grant the user select on everything in every database no matter
what host they are coming from. He wants to only grant on specific tables,
and did not mention anything about allowing from all hosts.
To answer the original question, I have tried
On Wed, 26 Mar 2003 13:14:09 -0600
Black, Kelly W [PCS] wrote:
I think this might do what you want, but then you will be required
to log
in with the -p syntax...
GRANT SELECT on *.* TO yourlogin@'%' IDENTIFIED BY somepassword;
FLUSH PRIVILEGES;
mysql -u
Is there a reason for not using tables_priv table for this purpose?
Mihail
- Original Message -
From: Dimitar Haralanov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:29 PM
Subject: Re: granting privileges using wildcards
On Wed, 26 Mar 2003 13:14:09 -0600
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dimitar --
...and then Dimitar Haralanov said...
%
...
% Basically, is something like the following possible?
%
% GRANT SELECT ON db.table_% TO user@'%' IDENTIFIED BY 'pass';
AFAIK it is not. See Benjamin's quite thorough response to
was the question again?
-Original Message-
From: Dimitar Haralanov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 11:03 AM
To: [EMAIL PROTECTED]
Subject: granting privileges using wildcards
Hi,
I have been trying to find information on the following question
On Wed, 26 Mar 2003 14:37:33 -0800
Jennifer Goodie wrote:
To answer the original question, I have tried a lot of different
ways, but
the only solution I have found is granting on the entire database
or
specifing each table in the tables_priv table. I go with the
second option
with it?
-Original Message-
From: Black, Kelly W [PCS] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 11:14 AM
To: 'Dimitar Haralanov'; [EMAIL PROTECTED]
Subject: RE: granting privileges using wildcards
I think this might do what you want, but then you will be required to log
Hey there!
Hoping someone can help me out when it comes to granting privileges for a
user in MySQL.
Basically, I have granted privileges to a user who I do not want to have
root access and I want to minimize his access to only his databases.
Using the MySQL manual, I granted him basic
23 matches
Mail list logo