How to allow Normal Linux User to run particulare bash / shell script

[php-pandit]

Hi

Plz, help me out i want to allow one of my linux user to run this below bash script to take mysql database backup.

[b]Shell Script:[/b]

<!---------------- ##################### ----------------------->

#!/bin/bash
TIMESTAMP=`date +%m-%d-%y-%H%M`

cd /home/backups/mysql

find /home/backups/mysql/*.tar.gz -mtime +7 -exec rm -f {} ;


# my database
DBNAME=my_database
mysqldump --opt -c -e -Q -u MYSQL_USER -p'MYSQL_PASSWORD' $DBNAME > $DBNAME.sql
tar czpf $DBNAME.$TIMESTAMP.tar.gz $DBNAME.sql
rm -f $DBNAME.sql

<!---------------- ##################### ----------------------->

But when i am running this script as a normal user it is giveing me an  error of [b]"Permission denied"[/b]

Thanks
Harshad Pandit
alias(PHP Pandit)
<a href="http://php-pandit.blogspot.com/">Harshad Pandit's Blog</a>

[steelmanronald06]

Gotta make that user part of the mysql group ;)

[Daniel0]

You just need to give it executable permissions (or whatever you'd call it).

[code]chmod +x your_script.sh[/code]