Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- run('mysql -u %s -p %s -h %s ' % (env.mysqluser, env.mysqlpassword, env.mysqlhost), pty=True)
- run('CREATE DATABASE %s; ' % (dataname), pty=True)
- run('exit', pty=True)
- run('echo "CREATE DATABASE %s;"|mysql --batch --user=%s --password=%s --host=%s' % (dataname, env.mysqluser, env.mysqlpassword, env.mysqlhost), pty=True)
- run('mysqladmin -u %s -p%s create %s' % (user, password, dbname))
- mysql -uroot -prootpassword -e "CREATE DATABASE dbname";
- #!/bin/bash
- DB="mydb"
- USER="user1"
- PASS="pass_bla"
- mysql -uroot -prootpassword -e "CREATE DATABASE $DB CHARACTER SET utf8 COLLATE utf8_general_ci";
- mysql -uroot -prootpassword -e "CREATE USER $USER@'127.0.0.1' IDENTIFIED BY '$PASS'";
- mysql -uroot -prootpassword -e "GRANT SELECT, INSERT, UPDATE ON $DB.* TO '$USER'@'127.0.0.1'";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement