provisioning-mysql.groovy

def _provisioningMysqlUser(host, master_username, master_password, new_username, new_username_password) {
    docker.image('mysql:5').inside(" --net=host ") {
        
        def sqlCreateUser = "CREATE USER '${new_username}'@'%' IDENTIFIED BY '${new_username_password}';"
        sh """ mysql -h ${host} -u ${master_username} --password="${master_password}" -e "${sqlCreateUser}" """
        
        def sqlGrantAllPriv = "GRANT ALL PRIVILEGES ON *.* TO '${new_username}'@'%';"
        sh """ mysql -h ${host} -u ${master_username} --password="${master_password}" -e "${sqlGrantAllPriv}" """
    }
}

node{
    _provisioningMysqlUser(
        "127.0.0.1", 
        "root", 
        "root", 
        "new_username", 
        "new_username_password"
    )
}