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#priv_replication-slave
My question is about what replication-related users
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
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
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?
- Original Message -
From: Mr. Left hdch...@163.com
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 just for the session
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 rp.ne...@yahoo.com wrote:
Hello,
currently on this version of MySQL a database has been built for me to
use. and following privileges are given: I
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?
The answer to that question
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 host
Am
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: Reindl Harald [mailto:h.rei
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 global
permission
problem in case of special characters in the host
name.
Cheers!
Claudio
2011/7/31 d...@safeport.com
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
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 infile' seems (to me) to be equivalant
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 | 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
'carlos' has specific privileges on 'mydb' database. I am sure I could
simply re-run the following command:
GRANT ALL PRIVILEGES ON mydb.* TO 'carlos'@'localhost
On Thu, May 27, 2010 at 12:26 PM, win.a win@gmail.com 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
-
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
'carlos' has specific privileges
On Thu, May 27, 2010 at 7:30 PM, Carlos Mennens carlosw...@gmail.comwrote:
On Thu, May 27, 2010 at 12:26 PM, win.a win@gmail.com 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
-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 Avenue of the Americas, Fifth Floor
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 rights of the script file to rwx-- . So only
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 which would work
or if the 'backup' user would require high
. 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 if I
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 which would work
or if the 'backup' user would require high level privileges
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?
that host alone.
--
Thanks
Suresh Kuna
MySQL DBA
2010/3/2 PengXiaoxun fikm...@163.com
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
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 new user without any privileges actually
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 Mailing List
For list archives: http://lists.mysql.com/mysql
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 Mailing
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
Never mind. Had to add @'localhost'
On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi victorsube...@gmail.comwrote:
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
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
and
allow the GRANT (after all, it's just an insert/update/delete statement
when
it all boils down to the mysql.user table). In fact, that COULD be the way
these special case people get around using GRANT, just insert what they
want directly into mysql.user,host,table, etc. and FLUSH PRIVILEGES
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
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
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
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 command
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;
--
Sebastian
--
MySQL General Mailing
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
mysqldump
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 file
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 function
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 and privileges
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 mysqldump
@lists.mysql.com
Subject: RE: mysql privileges
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
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 using
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 [EMAIL
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 [EMAIL PROTECTED] wrote:
Yes you will have all the GRANTS for every user sitting
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.
Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED]
08-934
] |
2002-07-21 15:07:17 | Select | |
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
| |
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?
Probably not. You are probably
, 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 for [EMAIL PROTECTED
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 least) two things
[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)
That statement
SQL intense purposes. (FYI, I am using the PMA user, who only has
'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
.*
- 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'\G
*** 1
, 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 reloaded. This appears
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'
privileges to the mysql
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 combination of privileges you like
' 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 prudent to start
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
whose name
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?
Thk's.
Wagner Bianchi
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 privileges, please let me know
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, please let me know.
regards
anandkl
:)
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]
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't seem to change
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 REVOKE ALL PRIVILEGES
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 ALL PRIVILEGES
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 granted by this query
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 SUPER privileges). All
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 SUPER privileges). All
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,
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
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
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
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
BY PASSWORD
'*37638FAC6D9ED84696E9504AC8EA4495EA97A908' |
| GRANT ALL PRIVILEGES ON `WP_INT_BASEBALL`.* TO 'WP_INT_BASEBALL'@'localhost
'@'localhost' IDENTIFIED BY PASSWORD
'*37638FAC6D9ED84696E9504AC8EA4495EA97A908' |
| GRANT ALL PRIVILEGES ON `WP_INT_BASEBALL`.* TO 'WP_INT_BASEBALL'@'localhost
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 SELECT
, 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
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 working until FLUSH
PRIVILEGES is called? I'm not doing any
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 anyone have any idea what would make a
previously working username stop working until FLUSH PRIVILEGES
.
- Original Message -
From: Gilles MISSONNIER [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, February 07, 2007 9:26 PM
Subject: Re: revoke SELECT on a column [ MySQL 4.1 ] + column privileges
hello,
first thanks to ViSolve DB Team,
and since then, my question turns out
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 column in the_base.t100
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 PROTECTED]
Now we
* 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]
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
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 in
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 |
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
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
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 privileges for the other tables
-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 users, user_A
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
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.
mysql describe tables_priv
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, insert, update, and delete
supercede any table
1 - 100 of 446 matches
Mail list logo