Hello All,
I've been searching and searching and searching for an answer to this problem but can't seam to find an answer anywhere!
Problem:
A non-root hosted cPanel account user with regular shell access gets permission denied when trying to use mysqldump
"-bash: dbbackup.sql: Permission denied"
The user can successfully log into any of their databases with mysql (using: mysql -u username -p database_name) but no use of mysqldump - response says bash permission denied!
Is there a way to give normal shell non-root cPanel user accounts the ability to use mysqldump? I can't find anything on extending privileges to shell users (other than making them a sudo user and adding them to the wheel group) but I don't want to give them the ability to execute commands that could be a security risk - I just want to give regular shell accounts the ability to use mysqldump for their databases.
- I've been having to login as server root user to create a mysql backup using dump for several users (and it's getting to be a pain)
- Most users are fine without shell to backup their databases having phpMyAdmin, however there are a couple accounts with excessively large databases and phpMyAdmin fails, so shell with mysqldump is required for database backup on those accounts.
-Accept I can't find documentation on adding functions, features or commands to shell for users.
Any help here would be greatly appreciated!
~Thank You
I've been searching and searching and searching for an answer to this problem but can't seam to find an answer anywhere!
Problem:
A non-root hosted cPanel account user with regular shell access gets permission denied when trying to use mysqldump
"-bash: dbbackup.sql: Permission denied"
The user can successfully log into any of their databases with mysql (using: mysql -u username -p database_name) but no use of mysqldump - response says bash permission denied!
Is there a way to give normal shell non-root cPanel user accounts the ability to use mysqldump? I can't find anything on extending privileges to shell users (other than making them a sudo user and adding them to the wheel group) but I don't want to give them the ability to execute commands that could be a security risk - I just want to give regular shell accounts the ability to use mysqldump for their databases.
- I've been having to login as server root user to create a mysql backup using dump for several users (and it's getting to be a pain)
- Most users are fine without shell to backup their databases having phpMyAdmin, however there are a couple accounts with excessively large databases and phpMyAdmin fails, so shell with mysqldump is required for database backup on those accounts.
-Accept I can't find documentation on adding functions, features or commands to shell for users.
Any help here would be greatly appreciated!
~Thank You