Block Access to mysql

baddah · 02-18-2011, 05:18 AM

Hi,

What's the best way in centos to block a user from accessing mysql. I don't want him to be able to run the mysql command, so just putting passwords up in mysql is not good enough. Mysql is running ad user=mysql, and i added the user in a different group by he is able to access mysql by typing in the command.

How can i block this command being availible for this user.

Hangdog42 · 02-18-2011, 07:08 AM

You probably just need to change the permissions on the mysql binary so that normal users can't run it. So if you changed mysql to something like 750, only the owner and accounts in the proper group could run it. What are the current permissions on mysql?

baddah · 02-18-2011, 07:41 AM

Yes,thanks i changed it to 754 now. I just need to make 100% sure i'm not now blocking something that actually needs mysql.

thanks for reply

Guttorm · 02-18-2011, 08:50 AM

Quote:

I don't want him to be able to run the mysql command, so just putting passwords up in mysql is not good enough.

What's to stop him from compiling a mysql client and run it from his own home directory? Or simply copy it from a different computer?

unixfool · 02-18-2011, 09:17 AM

Hrmm...

How about SELinux?

Also, to be honest, if you can't trust this user and want to lock him out of a certain command, you might want to start worrying about what else he may be doing that you aren't currently aware of. Guttorm has a point, too...how far do you want to take it?

nitrogendizzy · 02-21-2011, 07:44 PM

Quote:

Originally Posted by Guttorm

What's to stop him from compiling a mysql client and run it from his own home directory? Or simply copy it from a different computer?

Trusted Path Execution, RBAC etc, depends if the server is properly configured.

Don't really use MySQL, but couldn't you also bind to socket and change permissions on it too.
Could also RSH the user so can only exec certain commands in a chroot(if they connect via SSH).