Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql -e "create database if not exists ${UN}_${SQLBASE}"
- mysql -Be "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE ROUTINE ON `"$UN"\_"$SQLBASE"`.* TO '"$UN"_"$SQLUSER"'@'localhost' IDENTIFIED BY '$SQLPASS';FLUSH PRIVILEGES"
- username="usernamedb"
- password="passworddb"
- database="cpanel_db"
- databases=$(mysql -u $username -p$password -Bse 'show databases'|grep $database)
- max=1
- if [ -z "$databases" ];then
- mysql -u $username -p$password -Bse "create database ${database}$max"
- else
- for cdatabase in $databases
- do
- cdatabasenumber=$(echo $cdatabase|awk -F"db" '{print $2}')
- if [ $cdatabasenumber -gt $max ]; then
- max=$cdatabasenumber
- fi
- done
- let max++
- mysql -u $username -p$password -Bse "create database ${database}$max"
- fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement