shanepresley
asked on
Groups/Permissions for Database Admins (RedHat 3 & MySQL)
Hello,
I have a RedHat ES 3 system. It's a standard build from the CDs, and then MySQL installed from RHN.
Currently only I use the system (as either my personal account, or root when doing admin).
I now want to have another person administer all database related "things". So I assume I need to create a group. But I've never done that. Also, it appears mysql was installed as root. How would I change that, so the new group owns all MySQL related things?
Thanks
Shane
I have a RedHat ES 3 system. It's a standard build from the CDs, and then MySQL installed from RHN.
Currently only I use the system (as either my personal account, or root when doing admin).
I now want to have another person administer all database related "things". So I assume I need to create a group. But I've never done that. Also, it appears mysql was installed as root. How would I change that, so the new group owns all MySQL related things?
Thanks
Shane
rindi
I'd install webmin (First look if it is part of your distro, otherwise you can download it from http://webmin.com). This is a browser based system which helps you administer most parts of a linux installation, including user accounts and MySQL Server administration. Being webbased, it makes the setup pretty easy, and it is more or less selfexplanatory, so it shouldn't be necessary for me to explain more, but if there are problems, tell us.
if you want the other user only to do mysql administration and not requiring console based access then there are lot of web based clients for mysql to administer.
ASKER
Hey guys,
This will be a text only installation. No GUI. I will look into the MySQL web based client, but I think our DBA's require CLI.
Anyway, could you tell me how to:
-Create a group
-Assign users to a group
-Assign an applcation (MySQL) to that group
All using CLI if possible
Thanks
Shane
This will be a text only installation. No GUI. I will look into the MySQL web based client, but I think our DBA's require CLI.
Anyway, could you tell me how to:
-Create a group
-Assign users to a group
-Assign an applcation (MySQL) to that group
All using CLI if possible
Thanks
Shane
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Rindi, that's most of what I needed. I'll go play with groupadd and useradd.
But let's just say that I create a group DBA, and assign a user SPRESLEY to that group. (using the commands you gave me).
So now SPRESLEY can log in, has a home directory etc.
Now I need to give SPRESLEY the ability to run the command /usr/bin/mysql, which is currently owned by root. How do I make it so the group DBA can run the command /usr/bin/mysql
But let's just say that I create a group DBA, and assign a user SPRESLEY to that group. (using the commands you gave me).
So now SPRESLEY can log in, has a home directory etc.
Now I need to give SPRESLEY the ability to run the command /usr/bin/mysql, which is currently owned by root. How do I make it so the group DBA can run the command /usr/bin/mysql
I think that is done with chmod. Use man chmod to get more details for that command. But I'm not so sure, because whenever I need to do things similar, I either use webmin or midnight commander, so I hardly ever use the commands directly...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.