Tagged Questions
0
votes
1answer
24 views
Which privileges for MySQL extended status?
If I want to execute "SHOW STATUS" within MySQL or use "mysqladmin extended-status" on command line with a non-root user, which privileges would this user then need?
0
votes
2answers
38 views
Why does this procedure raise a privilege error?
I am having trouble getting the following procedure to run on a remote MySQL database - the given error is privilege based (#1227). Locally, the procedure runs fine.
QUESTIONS
Could somebody help ...
2
votes
2answers
100 views
EMS SQL manager permission problem
I have a strange problem with EMS SQL Manager.
I'm using MySQL 5.5 with linux servers. One of my developers need to edit store procedure, so I grant him:
GRANT CREATE ROUTINE, ALTER ROUTINE ON ...
1
vote
2answers
118 views
mysqldump: flush-privileges option
I'd like to get some clarification about the --flush-privileges option for mysqldump.
Here's the description of the option from the MySQL docs:
--flush-privileges
Send a FLUSH PRIVILEGES ...
0
votes
0answers
10 views
hosting account with advanced mysql privileges
Is it possible to have a mysql database where either:
a) the user has limited permissions on a table by table basis (e.g. can only select, insert from table_a, and can only update table_b)
b) ...
1
vote
2answers
181 views
how to import mysql system “mysql” database [closed]
This question might be already answered but it's almost impossible to google it.
When I perform full backup of mysql server using
mysqldump --all-databases
then reinstall it from scratch I want to ...
1
vote
1answer
53 views
mysql allow access for localhost and named server
Hope we're enjoying this Fine Friday afternoon and getting ready for the weekend.
I've got a quick question. I'm trying to set up a user to allow them access from localhost and from a specific named ...
1
vote
1answer
42 views
Can't SHOW GRANTS after MySQL re-install
I had to completely re-install MySQL on one of the slaves and then rebuild it via a sql dump (we have 1 master and 2 slaves). I tried to SHOW GRANTS for one of the users, but keep getting the ...
0
votes
0answers
61 views
Unable to set table-specific privileges
I want to give a user access to only a few tables. I execute this query:
GRANT SELECT (credits_features_csgo, steam_code, credits_csgo, userid,
credits_forum, credits_features_tf2, credits_tf2, ...
2
votes
1answer
1k views
How do I automatically grant all privileges to a schema created by a user in mysql?
Someone new joined the company and I created an account for her in mysql using the following:
CREATE USER 'username' IDENTIFIED BY 'password'
She needs to create her own schema and so used:
GRANT ...
1
vote
1answer
166 views
How to restrict MySQL user to not import and export database
I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
0
votes
0answers
37 views
Give privilege to new created databases in MySQL
I have user "U" who I want to give him full access to all the existing databases except "db1". I want him to only have select privilege for that db. What I did is I gave "U" all permissions for each ...
2
votes
3answers
7k views
Cannot GRANT privileges as root
Because of having some problems, I decided to re-create all users except for root@localhost. This works fine, but the newly created user has no right to do anything. What I want is to simply give all ...
3
votes
3answers
2k views
can't remove “GRANT USAGE”
I was testing some stuff, and added a:
grant usage on statistics.* to cptnotsoawesome@localhost identified by 'password';
so now when I do
show grants for cptnotsoawesome@localhost;
I can see ...
5
votes
3answers
12k views
How do I change the DEFINER of a VIEW in Mysql?
When I run mysqldump, I get an error:
mysqldump: Got error: 1449: The user specified as a definer ('root'@'foobar') does not exist when using LOCK TABLES
This makes sense because foobar is a legacy ...
3
votes
1answer
77 views
Is it possible to find the values of MySQL variables if I do not have SELECT privileges on mysql.user?
I am getting a 'msyql server has gone away' error sometimes when doing a large binary insert, so I wanted to check the settings on mysql, things like wait_timeout and max_allowed_packet. However
show ...
4
votes
2answers
532 views
How to retrieve granted privileges without access to the database “mysql”?
As a MySQL user without access to the mysql database, is it possible to retrieve my privileges?
7
votes
3answers
980 views
Can you “su -” in MySQL?
If I have root on a mysql database and I want to drop privileges to that of a normal user, without using their password, can I do it? if so how? think # su - username on unix. Basically, I'm just ...
