All Questions
8 questions
2
votes
1
answer
1k
views
MySQL least privileges to get database/tables size
I'm using centreon_plugins to monitor some mysql databases. As a best practice I create a dedicated user for monitoring and I give it the least possible privileges.
For simple monitoring I usually ...
- 21
0
votes
3
answers
1k
views
Cascading REVOKE not working in MYSQL
I've read about an SQL option of cascading permissions when issuing a REVOKE statement. I've googled for how this option is implemented in MySQL, but haven't found it at all.
This is the docs page ...
- 285
0
votes
1
answer
186
views
MySQL 8 roles - I'm probably missing something obvious
I'm trying to use roles in MySQL 8, and failing. I have read the documentation and as far as I can tell, I'm doing it right. Since this is a 'hello world' level attempt, I assume I'm missing something ...
- 4,098
3
votes
1
answer
2k
views
What are the minimal MySQL grants for the debian-sys-maint user?
What are the minimal privileges that debian-sys-maint@localhost needs for the mysql service to work correctly?
This answer on ServerFault suggests granting RELOAD only, but this is incorrect, as it ...
- 141
1
vote
1
answer
2k
views
Allow multiple users to see procedures and functions
I have GRANT ALL PRIVILEGES ON `test1`.* TO 'admin'@'%', GRANT ALL PRIVILEGES ON `test1`.* TO 'devel'@'%' (from SHOW GRANTS FOR some_user) and I have created simple procedure as admin in test1.
And ...
- 189
3
votes
1
answer
3k
views
Allow multiple users to change functions in MySQL
I want to make multiple users and allow them to change procedures,functions and triggers in same DB. There must be user devel for developers and admin for admin, both can change developers DB, but ...
- 189
16
votes
2
answers
12k
views
What are reasonable privileges to grant typical users? [closed]
I find the list of privileges provided by MySQL to be a bit overwhelming. I'm not sure who should have what privileges. In my mind there are three typical users for my situation:
root
developer
...
9
votes
2
answers
9k
views
MySQL Permissions Necessary To Reset Password
On my team there is a desire for some users to periodically update their MySQL password.
Our MySQL server is shared between a few projects (and certain users are assigned to certain projects). If I'm ...
- 192