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 you
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 S
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 us
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:
* 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... ;)
http://www.mysql.com/doc/en/Adding_users.html >
http://
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
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
Hi Todd,
2003年 8月 4日 月曜日 08:17、Todd 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
Hi Todd,
2003年 8月 4日 月曜日 08:01、Todd 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 tha
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
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 add
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 wrot
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]
Subjec
27;t seem to work in this instance. Has
anybody had any success 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
ccess 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
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
>
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 youruserid -p -h hostname dbasename
Regards,
Kelly Black
Linux was very clearly the answer, but what
-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 my
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
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
20 matches
Mail list logo
