have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv privilege as described here:
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave
My question is about what replication-related users and
privileges.
I understand on the master, the replication user must have the
Repl_slave_priv privilege as described here:
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave
My question is about what replication-related users and privileges
must
exist on the slave
Hello Jim,
On 2/25/2019 7:29 PM, Jim wrote:
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv privilege as described here:
https://dev.mysql.com
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv privilege as described here:
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
- Original Message -
> From: "Mr. Left"
> Subject: Set session binlog_format need SUPER privileges???
>
> When i want to set session binlog_format, I got error which means i should
> have the SUPER privileges,
> So i want to know, why i need such privileges j
Hi, all,
When i want to set session binlog_format, I got error which means i should have
the SUPER privileges,
So i want to know, why i need such privileges just for the session variable?
OP's first question: " I am not able to create a table on my own. what
privileges I need to create and modify tables in this database?"
The answer to that question is that he/she needs CREATE to create tables and
ALTER to alter them.
-Original Message-
From
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow
the user to create or drop tables, the user below is
able to do anything for a common web-app
to anser the OP's question
% in mysql is the same as * for the bash
so yes, % means "any
oh, osrry
i was focused on the " at % means I can do the operations from other hosts too?"
Am 27.02.2013 19:00, schrieb Stillman:
> OP's first question: " I am not able to create a table on my own. what
> privileges I need to create and modify tables in this database
you need CREATE Privileges.
http://dev.mysql.com/doc/refman/5.0/en/grant.html#grant-privileges
On Wed, Feb 27, 2013 at 10:42 PM, Rajeev Prasad wrote:
> Hello,
>
> currently on this version of MySQL a database has been built for me to
> use. and following privileges are given: I am
ory question and a question on implementation of
privileges. First theory. I have been using:
grant all privileges on db-name.* to user@localhost
identified by 'password';
Because I blunder about as root I never was impacted by 'file' being a
global permission. As 'load
EST
single quotes prevent any problem in case of special characters in the host
name.
Cheers!
Claudio
2011/7/31
> I have both a theory question and a question on implementation of
> privileges. First theory. I have been using:
>
> grant all privileges on db-name.* to use
I have both a theory question and a question on implementation of privileges.
First theory. I have been using:
grant all privileges on db-name.* to user@localhost
identified by 'password';
Because I blunder about as root I never was impacted by 'file' being a gl
Hello, just wondering if anyone can advise the query that phpMyAdmin generates
to list all the privileges for a specific database.
What I'm after is an output like:
+-++--+-+
|User | Host| Type | Privi
ards
-Original Message-
From: Rolando Edwards [mailto:redwa...@logicworks.net]
Sent: Thursday, May 27, 2010 12:39 PM
To: Carlos Mennens; MySQL
Subject: RE: Verify User Privileges
SHOW GRANTS FOR 'carlos'@'localhost';
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenu
On Thu, May 27, 2010 at 7:30 PM, Carlos Mennens wrote:
> On Thu, May 27, 2010 at 12:26 PM, win.a wrote:
> > Maybe phpmyadmin is a choice
>
> No I am only allowed to have MySQL installed. No GUI for DBA. I am
> sure there is a way to verify the privileges via CLI, I just can&#x
-Original Message-
From: Carlos Mennens [mailto:carlosw...@gmail.com]
Sent: Thursday, May 27, 2010 12:07 PM
To: MySQL
Subject: Verify User Privileges
I would like to know how I can verify what privileges have been
granted to a specific user on MySQL. I don't remember if my user
&#x
On Thu, May 27, 2010 at 12:26 PM, win.a wrote:
> Maybe phpmyadmin is a choice
No I am only allowed to have MySQL installed. No GUI for DBA. I am
sure there is a way to verify the privileges via CLI, I just can't
locate it on the site / documentation.
--
MySQL General Mailing List
I would like to know how I can verify what privileges have been
granted to a specific user on MySQL. I don't remember if my user
'carlos' has specific privileges on 'mydb' database. I am sure I could
simply re-run the following command:
GRANT ALL PRIVILEGES ON mydb
Carlos mennens wrote:
>
> Can you guys recommend something for me here? I don't really
> know enough about MySQL 'grant' permissions to determine
> which would work or if the 'backup' user would require high
> level privileges.
>
Hi,
Set the
. Now I could just place the MySQL
root user or my own user (admin) account in here which has a plain
text password exposed in the configuration for all to see. Should I
create a generic user in MySQL just for backup roles and privileges? I
don't know enough about GRANT OPTIONS or backups to know
lar
> user's password will be entered into the script noted above via plain
> text. I am scared the password will be compromised & that would be bad
> if it's root or someone who has GRANT ALL PRIVILEGES ON *.*.
>
> Can you guys recommend something for me here? I don&#
ed above via plain
text. I am scared the password will be compromised & that would be bad
if it's root or someone who has GRANT ALL PRIVILEGES ON *.*.
Can you guys recommend something for me here? I don't really know
enough about MySQL 'grant' permissions to determine whi
PengXiaoxun wrote:
I create a new account via the following statement:
CREATE USER 'monty'@'%' IDENTIFIED BY '123456';
Without any privileges granted, the user 'monty' can access the database
information_schema via a remote host.
Why?
How can I create a
an only connect from that host alone.
--
Thanks
Suresh Kuna
MySQL DBA
2010/3/2 PengXiaoxun
> I create a new account via the following statement:
> CREATE USER 'monty'@'%' IDENTIFIED BY '123456';
> Without any privileges granted, the user 'monty'
I create a new account via the following statement:
CREATE USER 'monty'@'%' IDENTIFIED BY '123456';
Without any privileges granted, the user 'monty' can access the database
information_schema via a remote host.
Why?
How can I create a new user without any privileges actually?
I'd rather not use the MySQL root user for a
> backup script, if I can get away with MySQL user with reduced privileges,
> for the following command:
>
> mysqlcheck -ao --auto-repair --all-databases -u someuserotherthanroot
> -pPASSWORD
>
> ...Rene
>
>
--
MyS
Just wondering what they are. I'd rather not use the MySQL root user for a
backup script, if I can get away with MySQL user with reduced privileges, for
the following command:
mysqlcheck -ao --auto-repair --all-databases -u someuserotherthanroot -pPASSWORD
...Rene
--
MySQL General Ma
Never mind. Had to add @'localhost'
On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi wrote:
> Hi;
> I created a user and then granted privileges:
> grant all to victor identified by 'pw';
> Looked good. Tried to log in as victor an no go. Please advise.
> Victor
>
Hi;
I created a user and then granted privileges:
grant all to victor identified by 'pw';
Looked good. Tried to log in as victor an no go. Please advise.
Victor
ase people" get around using GRANT, just insert what they
> want directly into mysql.user,host,table, etc. and FLUSH PRIVILEGES.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@
e people" get around using GRANT, just insert what they
want directly into mysql.user,host,table, etc. and FLUSH PRIVILEGES.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
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
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 (t
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&#x
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
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 gra
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 a
I would like to thank everyone who gave suggestions about how to fix the mysql
privileges. Here's what we did:
We did a mysqldump on the mysql table on the old machine.
We brought the mysqldump into the mysql table on the new machine
We ran mysql_fix_privilege_tables
We gave the co
> AllGrants.sql
AllGrants.sql will have all GRANTS but each line has no semicolon at the end
Just append a semicolon at the end of every line like this:
sed -i 's/$/;/' AllGrants.sql
Give it a try !!!
-Original Message-
From: Tim McDaniel [mailto:[EMAIL PROTECTED]
Sent: Wed
Yes !!!
mysqldump -h... -u... -p... mysql > MySQLSchema.sql
Give it a try !!!
-Original Message-
From: Tim McDaniel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 2:17 PM
Cc: mysql@lists.mysql.com
Subject: RE: mysql privileges
On Wed, 19 Mar 2008, Rolando Edwards <
On Wed, 19 Mar 2008, Rolando Edwards <[EMAIL PROTECTED]> wrote:
Yes you will have all the GRANTS for every user sitting in the
'mysql' schema (from mysq.user) if you use the --all-databases
option of mysqldump.
Can I safely assume that dumping the database named "mysql" dumps just
as well as us
like this:
sed -i 's/$/;/' AllGrants.sql
Give it a try !!!
-Original Message-
From: Brown, Charles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 11:37 AM
To: Sebastian Mendel; mysql@lists.mysql.com
Subject: RE: mysql privileges
Here is a follow-up question: Using
Yes. Just use --all-databases as mysqldump option and the 'mysql' schema is
included.
-Original Message-
From: Brown, Charles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 12:15 PM
To: mysql@lists.mysql.com
Subject: Are user privileges included in MYSQLDUMP
Using
On Wed, Mar 19, 2008 at 12:15 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
> Using mysqldump, I'm about to dump all databases and import to another
> instance - new . My question is do I need to define all security and
> users in the new mysql or the security definitions
Using mysqldump, I'm about to dump all databases and import to another
instance - new . My question is do I need to define all security and
users in the new mysql or the security definitions and privileges will
be included in the dump file created by mysqldump. What is the functi
Brown, Charles schrieb:
Here is a follow-up question: Using mysqldump, I'm about to dump all
databases and import to another instance - new . My question is do I
need to define all security and users in the new mysql or the security
definitions and privileges will be included in the dump
Here is a follow-up question: Using mysqldump, I'm about to dump all
databases and import to another instance - new . My question is do I
need to define all security and users in the new mysql or the security
definitions and privileges will be included in the dump file created by
mysq
super doesn't have rights to select from the hr table. But why not? According to the tables_priv table, super should have right to select.
did you export/import your data, or just copied the data files from your old
to the new MySQL?
did you reload privileges after changes?
FLUSH PRIVILEGES;
;| Table_priv | Column_priv
>
> +--+---+---+++-++-+
> | %| web_positions | super | hr | [EMAIL PROTECTED] |
> 2002-07-21 15:07:17 | Select | |
>
>
+--+---+---+++-++-+
> | %| web_positions | super | hr | [EMAIL PROTECTED] |
> 2002-07-21 15:07:17 | Select | |
>
> When I give the following command, I aslo get the
| |
When I give the following command, I aslo get the same results on both machines:
select * from user where user ="super";
The results are N for all the different privileges.
Has anything changed in MySQL 5.0.45 that would cause this behavior?
Thanks for any help.
r clients seem to use it as a browsing tool more that anything,
> > but there are a few that might be called 'Power Users" that use it for
> > more SQL intense purposes. (FYI, I am using the PMA user, who only has
> > 'select' privileges to the mysql users t
[EMAIL PROTECTED] wrote:
Baron Schwartz wrote:
hi,
[EMAIL PROTECTED] wrote:
GRANT SELECT, INSERT, UPDATE ON the_database.*
-> TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password';
Query OK, 0 rows affected (0.00 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
T
Baron Schwartz wrote:
hi,
[EMAIL PROTECTED] wrote:
GRANT SELECT, INSERT, UPDATE ON the_database.*
-> TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password';
Query OK, 0 rows affected (0.00 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
That statement does (at leas
, INSERT, UPDATE ON the_database.*
-> TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password';
Query OK, 0 rows affected (0.00 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
That statement does (at least) two things to mysql.user:
1) if there's no row in mysql.user fo
, INSERT, UPDATE ON the_database.*
-> TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password';
Query OK, 0 rows affected (0.00 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
I've resolved this, but I had to restart the MySQL server in order for
the privileges to be relo
.*
-> TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password';
Query OK, 0 rows affected (0.00 sec)
FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
"0 rows affected" on the GRANT suggests that not much was accomplished.
SELECT * FROM user WHERE User = 'the_user'
s
'select' privileges to the mysql users table).
Recently, I noticed something that caused me to reflect on the
privileges that I currently have setup on the server, and was wondering
if I could get some feedback and/or some light tutoring on the topic of
privileges.
It is perhaps p
This one time, at band camp, "Grant Peel" <[EMAIL PROTECTED]> wrote:
> What priveleges should I grant users at setup time?
Perhaps look at the GRANT option
GRANT SELECT, UPDATE, DELETE TO [EMAIL PROTECTED] IDENTIFIELD BY 'password';
you can use GRANT * or any combi
offer it PHPMyAdmin which has server us well so
far. Our clients seem to use it as a browsing tool more that anything, but
there are a few that might be called 'Power Users" that use it for more SQL
intense purposes. (FYI, I am using the PMA user, who only has 'select'
pri
Hi All!
Here is a funny thing I come across when investigating our privilege control
system. Consider the following situation:
mysql> GRANT ALL ON `%o`.* TO rafal;
mysql> GRANT SELECT ON foo.* TO rafal;
The intention is that rafal has all privileges for all objects in databases
whos
new user, that don't have the global privileges!"
Maybe, I think is not correctly, cause that new user have a USAGE
privileges ok, and have the possibles privileges revoked in this moment.
In resuming, the user have all global privileges, but, revoked!
What you think about that
Ananda Kumar wrote:
Hi All,
Today I installed mysql for debian OS.
After the installation, i started mysql using mysqld_safe &.
Now if i try to connect to mysql using "mysql -uroot -p", it fails, but if i
use "-habc" it works.
Do i need to set some parameters or give p
Hi All,
Today I installed mysql for debian OS.
After the installation, i started mysql using mysqld_safe &.
Now if i try to connect to mysql using "mysql -uroot -p", it fails, but if i
use "-habc" it works.
Do i need to set some parameters or give privileges, plea
he
database. I don't need Joe Blow for indiana to have direct access :)
Oh, and do I specifically have to disallow certain privileges if all
I want them to be able to do is delete, select or update records?
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
[EMAIL PROTECTED]
On Mon, 11 Jun 2007, Mahmoud Badreddine wrote:
> Hello,
> I am trying to revoke all privileges from a user on a certain table in a
> database.
> I want the user to continue to have all his/her privileges intact for the
> other tables though.
>
> I used the statement &quo
Hello,
I am trying to revoke all privileges from a user on a certain table in a
database.
I want the user to continue to have all his/her privileges intact for the
other tables though.
I used the statement "REVOKE ALL PRIVILEGES on dbName.tableName from
thisUser";
But that doesn
sr_id`) ON DELETE CASCADE". By the way I forgot to mention that
engine is of course InnoDB.
Baron Schwartz wrote:
Hi Sergei,
Sergei wrote:
Hello,
I have a weird problem with privileges and deleting from tables.
I have a MySQL user that has only "mydb2" database specific
privil
ELETE CASCADE". By the way I forgot to mention that
engine is of course InnoDB.
Baron Schwartz wrote:
Hi Sergei,
Sergei wrote:
Hello,
I have a weird problem with privileges and deleting from tables.
I have a MySQL user that has only "mydb2" database specific
privileges (no SU
Hi Sergei,
Sergei wrote:
Hello,
I have a weird problem with privileges and deleting from tables.
I have a MySQL user that has only "mydb2" database specific privileges
(no SUPER privileges). All tables were created prior to granting any
privileges.
Privileges have been grant
Hello,
I have a weird problem with privileges and deleting from tables.
I have a MySQL user that has only "mydb2" database specific privileges
(no SUPER privileges). All tables were created prior to granting any
privileges.
Privileges have been granted by this query:
"GRANT
block subqueries? I do not think that one is possible in mysql (or any
other db IMO).
Also - I wonder why would you want to block subqueries but allow
normal queries - surely most (if not all) subqueries can be rewritten
using JOINs right.
Anoop
On 5/29/07, Ricardo Conrado Serafim <[EMAIL PROTE
Thanks!!
It helps me a lot!! But now, I just need to know how I do to block
subqueries (if it's possible...)
Anoop kumar V escreveu:
http://dev.mysql.com/doc/refman/5.0/en/revoke.html
You can use:
REVOKE ALTER ROUTINE, CREATE ROUTINE, EXECUTE ON * TO USER;
Anoop
On 5/28/07, Rica
http://dev.mysql.com/doc/refman/5.0/en/revoke.html
You can use:
REVOKE ALTER ROUTINE, CREATE ROUTINE, EXECUTE ON * TO USER;
Anoop
On 5/28/07, Ricardo Conrado Serafim <[EMAIL PROTECTED]> wrote:
Hi,
I need to know if it's possible block things like store procedures,
triggers, etc in MySQL 5.0
Hi,
I need to know if it's possible block things like store procedures,
triggers, etc in MySQL 5.0 using grant statement. Some users can't uses
this stuff.
If someone knows please help me.
Regards,
--
Ricardo Conrado Serafim
DBA Júnior (MySQL)
URANET Projetos e Sistemas
www.uranet.com.br
-
Up to this point, I have controlled MySQL privileges from Perl or PHP
pages. All connections to the database used the same MySQL login. Ordinary
users used pages that strictly controlled selections, insertions, or updates.
Administrators/Developers used password-protected pages that
E ON *.* TO 'WP_INT_BASEBALL'@'localhost' IDENTIFIED BY PASSWORD
'*37638FAC6D9ED84696E9504AC8EA4495EA97A908' |
| GRANT ALL PRIVILE
SEBALL'@'localhost' IDENTIFIED BY PASSWORD
'*37638FAC6D9ED84696E9504AC8EA4495EA97A908' |
| GRANT ALL PRIVILE
, Denise [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 05, 2007 4:08 PM
To: mysql@lists.mysql.com
Subject: Privileges question.
Hi all,
I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE
privileges on a database. My question is when I type show grants for
the user I create, it says
Hi all,
I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE
privileges on a database. My question is when I type show grants for
the user I create, it says the user has full privileges over the
database and I only want them to have the ones listed above.
mysql > grant SEL
er 'username'@'localhost'
> (using password: YES)
>
> When I log in as root and run 'FLUSH PRIVILEGES' everything starts
> working again. I've looked at the doc for 'FLUSH PRIVILEGES' but I still
> can't work out what's going. Does
)
When I log in as root and run 'FLUSH PRIVILEGES' everything starts
working again. I've looked at the doc for 'FLUSH PRIVILEGES' but I
still can't work out what's going. Does anyone have any idea what
would make a previously working username stop workin
et i=i+1;
end while;
end;
mysql> call g(hide_this_col);
Thanks
ViSolve DB Team.
- Original Message -
From: "Gilles MISSONNIER" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 07, 2007 9:26 PM
Subject: Re: revoke SELECT on a column [ MySQL 4.1 ] + column privileg
hello,
first thanks to ViSolve DB Team,
and since then, my question turns out to be :
in the base that contains a table of 100 columns, I want to disable SELECT
on only 1 column "hide_this",
how to apply column privileges using a loop in mysql, that could do :
for each
* now i can access with [EMAIL PROTECTED] but i can't create databases
What does "show grants" display when you login as root?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
ok, you can tell me i'm a crazy boy...
I've made a lot of changes to privileges in a mysql server.
Then, i saw 2 root account: the first may be able to access from
localhost, the second from all hosts.
Mysql server is inside our intranet so i decided to drop [EMAIL PROTECT
Bummer! I was hoping that you'd see what actually gets executed
during a SHOW DATABASES, like "select * from user, table_privs where
" so you could then run an EXPLAIN on it.
For me on 5.0.21 EXPLAIN SHOW DATABASES gives me an error so no joy there.
I suspect you've got a lot more entries i
Nico, as a first stab, I would try optimizing the tables in question.
OPTIMIZE TABLE mysql.user
etc.
The one with 194,177 entries would be a good candidate for this especially.
done, but with no improvement
I wonder also if you would see something logged in the slow query log
as this happe
Nico, as a first stab, I would try optimizing the tables in question.
OPTIMIZE TABLE mysql.user
etc.
The one with 194,177 entries would be a good candidate for this especially.
I wonder also if you would see something logged in the slow query log
as this happens? Perhaps the tables_priv table
Hello,
as the title reads, when a user X with access to few tables runs "show
databases"
the query executes _very_ slowly and there's a sudden HUGE load (mysqld
takes 99% cpu for the whole
duration of the query):
show databases;
++
| Database |
+--
> Hi Scott,
>
> One would think that you should be able to accomplish what you are
> looking for by changing rows in table -> "tables_priv" in mysql
> database. And using "flush privileges" when you done.
So does this mean my database privs of select, in
Hi Scott,
One would think that you should be able to accomplish what you are
looking for by changing rows in table -> "tables_priv" in mysql
database. And using "flush privileges" when you done.
mysq
revoke all privileges from a user for one table in a database,
and still maintain the existing privileges for the other tables?
For example, I have these tables:
Email
Logbook
Sales_tax
Sessions
Transactions
Users
Orders_A
Orders_B
Lets say I have two users, user_A and user_B
Currently, both users
27;user'@'hostname';
>
>
>> MySQL - 4.0.18-standard-log
>
> How do you revoke all privileges from a user for one table in a database,
> and still maintain the existing privileges for the other tables?
>
> For example, I have these tables:
> Email
>
Sean,
As http://dev.mysql.com/doc/refman/5.0/en/revoke.html states,
REVOKE ALL ON `database`.`table` FROM 'user'@'hostname';
> MySQL - 4.0.18-standard-log
How do you revoke all privileges from a user for one table in a database,
and still maintain the existing privileg
MySQL - 4.0.18-standard-log
How do you revoke all privileges from a user for one table in a database,
and still maintain the existing privileges for the other tables?
For example, I have these tables:
Email
Logbook
Sales_tax
Sessions
Transactions
Users
Orders_A
Orders_B
Lets say I have two
1 - 100 of 464 matches
Mail list logo
