How To create a MySQL database and set privileges to a user

mysql> CREATE USER 'root'@'10.0.0.1' IDENTIFIED BY 'password';


mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.0.1' WITH GRANT OPTION;


mysql> FLUSH PRIVILEGES;

How to backup MySQL databases

1. create /backup directory
2. create startbackup.sh script file:

rm -f /backup/mysql*
### System Setup ###
BACKUP=/backup
NOW=$(date +"%d-%m-%Y")

### MySQL Setup ###
MUSER="mysqluser"
MPASS="password"
MHOST="localhost"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
GZIP="$(which gzip)"


### Start MySQL Backup ###
# Get all databases name
DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
for db in $DBS
do
FILE=$BACKUP/mysql-$db.$NOW-$(date +"%T").gz
$MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
done