"Nupur Jain" <[EMAIL PROTECTED]> wrote on 02/08/2005 01:26:06 PM:
> I have problems with access permissions on a Solaris 9 installtion
> of MySql-max 4.1. My user table shows this
>
> select * from user;
> | Host| User | Password
> | Select_priv | Insert_priv | Update_priv | Delete
I have problems with access permissions on a Solaris 9 installtion of MySql-max
4.1. My user table shows this
select * from user;
| Host| User | Password |
Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv
| Reload_priv
Message-
> From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
> Sent: Tuesday 20 July 2004 16:44
> To: [EMAIL PROTECTED]
> Subject: RE: CIDR ranges in MySQL permissions?
>
> Sorry - a /32 is a single ip - I meant a /27 :)
>
> A
>
> -Original Message-
> From:
Hi All,
Can I assume by the lack of any responses that the anwser to my question
is no?
Cheers,
Andrew
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Tuesday 20 July 2004 16:44
To: [EMAIL PROTECTED]
Subject: RE: CIDR ranges in MySQL permissions?
Sorry
Sorry - a /32 is a single ip - I meant a /27 :)
A
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Tuesday 20 July 2004 16:16
To: [EMAIL PROTECTED]
Cc: Karl Skidmore
Subject: CIDR ranges in MySQL permissions?
Hi All,
Has anyone had any experience with using
Hi All,
Has anyone had any experience with using IP address ranges in MySQL
permissions? It would be easy if you had a whole class C for example
because you would be able to do:
Grant all privileges on *.* to someuser@'192.87.12.%';
But if you only wanted to give permissions to a
[EMAIL PROTECTED] wrote:
>>Description:
>Every time I restart the database engine it loses grant entries, and I have
>to manually reenter them by hand. Why aren't there rows finding their
>way to disk?
>>How-To-Repeat:
>Add some grants, restart the database.
>>Fix:
>Description:
Every time I restart the database engine it loses grant entries, and I have
to manually reenter them by hand. Why aren't there rows finding their
way to disk?
>How-To-Repeat:
Add some grants, restart the database.
>Fix:
I don't know of a fix.
thank you victoria!
-Original Message-
From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net]
Sent: Friday, November 08, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: re: mysql permissions
Shon,
Friday, November 08, 2002, 4:46:19 PM, you wrote:
SS> i need to create a u
Shon,
Friday, November 08, 2002, 4:46:19 PM, you wrote:
SS> i need to create a user (besides root) that can show databases,
Use Show_db_priv after 4.0.2, before 4.0.2 user can see all databases
if mysqld is running without --skip-show-database option.
SS> show tables
SS> from every database,
Us
grant all ?
-Original Message-
From: Shon Stephens [mailto:sstephens@;corp.goamerica.net]
Sent: Saturday, November 09, 2002 1:46 AM
To: '[EMAIL PROTECTED]'
Subject: mysql permissions
i need to create a user (besides root) that can show databases, show tables
from every data
i need to create a user (besides root) that can show databases, show tables
from every database, lock all tables, and flush all tables. what permissions
should i grant to this user?
thanks,
shon
[don't bounce me as spam]
mysql
sql
query
---
ursday, May 17, 2001 0:55
Subject: Re: Adding columns/tables to the mysql permissions database
> So, when MySQL goes to its own permisions table, it does a "select *", not
a
> "select user, host" etc.? Why is that? It seems that for flexibility it
> would name the fields
iteria than just
> > their name/host. Will mysql complain/refuse to work if I add columns to
> > the "mysql" database "user" table, or any other table in the "mysql"
> > permissions database? If I could do that, it would greatly simplify
> &
their name/host. Will mysql complain/refuse to work if I add columns to the
> "mysql" database "user" table, or any other table in the "mysql" permissions
> database? If I could do that, it would greatly simplify things for me.
>
> Thanks.
>
> j
I add columns to the
"mysql" database "user" table, or any other table in the "mysql" permissions
database? If I could do that, it would greatly simplify things for me.
Thanks.
j- k-
--
Joshua Kugler
Associated Students of the University of Alaska Fai
16 matches
Mail list logo
