Simple CLI tool to create and delete easily MySQL databases.
Project description
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.