fabtools.mysql

MySQL users and databases

This module provides tools for creating MySQL users and databases.
See also
fabtools.require.mysql

Queries

fabtools.mysql.query(query, use_sudo=True, _kwargs_)**[source]
Run a MySQL query.

Manage users

fabtools.mysql.userexists(_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.databaseexists(_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’)