Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #! /bin/bash
- newUser='testuser'
- newDbPassword='testpwd'
- newDb='testdb'
- host=localhost
- #host='%'
- commands="CREATE DATABASE \`${newDb}\`;CREATE USER '${newUser}'@'${host}' IDENTIFIED BY '${newDbPassword}';GRANT USAGE ON *.* TO '${newUser}'@'${host}' IDENTIFIED BY '${newDbPassword}';GRANT ALL privileges ON \`${newDb}\`.*
- TO '${newUser}'@'${host}';FLUSH PRIVILEGES;"
- echo "${commands}" | /usr/bin/mysql -u root -p
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement