fabtools.mysql

MySQL users and databases

This module provides tools for creating MySQL users and databases.

Manage users

fabtools.mysql.user_exists(name, host='localhost', **kwargs)[source]

Check if a MySQL user exists.

fabtools.mysql.create_user(name, password, host='localhost', **kwargs)[source]

Create a MySQL user.

Example:

import fabtools

# Create DB user if it does not exist
if not fabtools.mysql.user_exists('dbuser'):
    fabtools.mysql.create_user('dbuser', password='somerandomstring')

Manage databases

fabtools.mysql.database_exists(name, **kwargs)[source]

Check if a MySQL database exists.

fabtools.mysql.create_database(name, owner=None, owner_host='localhost', charset='utf8', collate='utf8_general_ci', **kwargs)[source]

Create a MySQL database.

Example:

import fabtools

# Create DB if it does not exist
if not fabtools.mysql.database_exists('myapp'):
    fabtools.mysql.create_database('myapp', owner='dbuser')

Project Versions

Table Of Contents

Previous topic

fabtools.group

Next topic

fabtools.network

This Page