4

I want one of my Linux users to be able to see the size of table files in /var/lib/mysql/[db]/..., but these dirs are owned by mysql:mysql and everyone does not have read access. Is it safe to add a normal user to the mysql group?

reynoldsnlp
  • 1,072
  • 1
  • 18
  • 45

1 Answers1

1

All things about security that I learned is about give access Only if it's absolutely necessary. Said that, you can think convenient to give them only read permissions, and for that, create new roles: MySQL - How to grant read only permissions to a user?

And if the users need to read the file (only the system file), you'll be opening the archives for their by making a specific group with the right permissions. And yes, is convenient, less secure, but resolve your problem.

Vitalizzare
  • 4,496
  • 7
  • 13
  • 32
Quazariun
  • 31
  • 4