Hi all...

HI all i am new to this community

---

 

i follow you since on vbulletin.com
since you told there now i always use centminmod on all my client server
but I do not know how to say thanks for you.
Regards

 

i have testing that very good performance

 

don't forget to addons Bash script to create MySQL database and user

 

yeah i have use that
but not effecient every time must open and login first to browser
i found this bash script on cyberciti and i try to modify the command is error but when echo and then copy paste the command is right no error

Code:

#!/bin/bash
# A shell script to add mysql database, username and password.
# It can also grant remote access on fly while creating the database.
# -------------------------------------------------------------------------

_db="$1"
_user="$2"
_pass="$3"
_dbremotehost="$4"
_dbrights="$5"

## Path to mysql bins ##
mysql="mysql"

## Mysql root settings ##
_madminuser='root'
_mhost='localhost'

# make sure we get at least 3 args, else die
[[ $# -le 2 ]] && { echo "Usage: $0 'DB_Name' 'DB_USER' 'DB_PASSORD' ['remote1|remote2|remoteN'] ['DB_RIGHTS']"; exit 1; }

echo -n "Enter the MySQL root password: "
read -s _madminpwd
echo ""

# fallback to ALL rights
[[ -z "${_dbrights}" ]] && _dbrights="ALL"

# build mysql queries
_uamq="${mysql} -u ${_madminuser} -h "${_mhost}" -p${_madminpwd} -e \"CREATE DATABASE ${_db}\";"
_upermq1="${mysql} -u "${_madminuser}" -h "${_mhost}" -p${_madminpwd} -e \"GRANT ${_dbrights} ON ${_db}.* TO ${_user}@'localhost' IDENTIFIED BY '${_pass}'\";"
                                                           
# run mysql queries
# modify to echo mode
echo $_uamq
echo $_upermq1

# read remote host ip in a bash loop
# build queires to grant permission to all remote webserver or hosts via ip using the same username
IFS='|'
for i in ${_dbremotehost}
do
  _upermq2="${mysql} -u "${_madminuser}" -h "${_mhost}" -p${_madminpwd} -e \"GRANT ${_dbrights} ON ${_db}.* TO ${_user}@${i} IDENTIFIED BY '${_pass}';\""
    echo $_upermq2
done

this bash script use so simple:
# ./sql.sh db_name db_user db_pass
# ./sql.sh db_name db_user db_pass '192.168.1.1|192.168.1.2|192.168.1.3' 'SELECT,INSERT,UPDATE,DELETE'
OR
# ./sql.sh db_name db_user db_pass '192.168.1.1|192.168.1.2|192.168.1.3' ALL

i hope you can fix
this bash script just refference only

 

thanks for your information, i will try.