mysqlrocket 0.0.11

Simple CLI tool to create and delete easily MySQL databases.

MysqlRocket is a Simple CLI tool to create and delete easily MySQL databases.

usage: mysqlrocket [-h] [-v] [-u U] [-H H] [-p P] {mk,ls,rm,st} …

mysqlrocket commands are:

• mk Create a MySQL database

• ls Show databases on MySQL server

• rm Delete a MySQL database

• status Check your mysqlrocket config and MySQL server connectivity

Optional arguments:

• -h, –help show this help message and exit

• -v, –version Show program version.

• -u U mysql user

• -H H mysql host

• -p P mysql password

See ‘mysqlrocket <command> -h’ for more information on a specific command.

PyPI package http://pypi.python.org/pypi/mysqlrocket

Sources https://github.com/cypx/mysqlrocket

Installation

Install it easily:

Using pip

$ pip install autoenv

Using easy_install

On most Linux distribution

$ easy_install mysqlrocket

But on some, prerequisites are required, for example, on Debian 6

$ aptitude install python-pip python2.6-mysqldb

(mysqldb could not be installed by easy_install cause of some system dependencies)

Examples

Create a new database

Create a new database whith an associated user account using the same name and a random password

$ mysqlrocket mk test_database

Show all databases

Show all databases avalaible on your server

$ mysqlrocket ls

Remove a database

Remove a database and all user account with the same name if they exist

$ mysqlrocket rm test_database

Check mysqlrocket configuration

Check your mysqlrocket config file and MySQL server connectivity

$ mysqlrocket st