{ "info": { "author": "xgtiger", "author_email": "xgtiger@163.com", "bugtrack_url": null, "classifiers": [ "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "Operating System :: Unix", "Programming Language :: Python", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: SQL", "Topic :: Database", "Topic :: Database :: Front-Ends", "Topic :: Software Development", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "# smycli\n\nBase on the cli tool *mycli* (HomePage: [http://mycli.net](http://mycli.net) ),\nadd additional secure manner via proxy\n\n\n\nQuick Start\n-----------\n\nIf you already know how to install python packages, then you can install it via pip:\n\nYou might need sudo on linux.\n\n```\n$ sudo pip install smycli\n```\n\n### Usage\n\n $ smycli --help\n Usage: smycli [OPTIONS] [DATABASE]\n\n Options:\n --ssh-host TEXT Ssh host of the proxy,spicify this option to\n indcate use ssh tunnel;if not spicified,use\n mycli directly\n --ssh-port INTEGER Ssh port of the proxy.\n --ssh-user TEXT Ssh user of the proxy.\n --ssh-pkey TEXT Ssh pravite key\n --ssh-password TEXT the password for pravite key or password auth\n -h, --host TEXT Host address of the database.\n -P, --port INTEGER Port number to use for connection. Honors\n $MYSQL_TCP_PORT\n -u, --user TEXT User name to connect to the database.\n -S, --socket TEXT The socket file to use for connection.\n -p, --password TEXT Password to connect to the database\n --pass TEXT Password to connect to the database\n --ssl-ca PATH CA file in PEM format\n --ssl-capath TEXT CA directory\n --ssl-cert PATH X509 cert in PEM format\n --ssl-key PATH X509 key in PEM format\n --ssl-cipher TEXT SSL cipher to use\n --ssl-verify-server-cert Verify server's \"Common Name\" in its cert\n against hostname used when connecting. This\n option is disabled by default\n -v, --version Version of mycli.\n -D, --database TEXT Database to use.\n -R, --prompt TEXT Prompt format (Default: \"\\t \\u@\\h:\\d> \")\n -l, --logfile FILENAME Log every query and its results to a file.\n --defaults-group-suffix TEXT Read config group with the specified suffix.\n --defaults-file PATH Only read default options from the given file\n --auto-vertical-output Automatically switch to vertical output mode\n if the result is wider than the terminal\n width.\n -t, --table Display batch output in table format.\n --warn / --no-warn Warn before running a destructive query.\n --local-infile BOOLEAN Enable/disable LOAD DATA LOCAL INFILE.\n --login-path TEXT Read this path from the login file.\n -e, --execute TEXT Execute query to the database.\n --help Show this message and exit.\n\n### Examples\n #connect mydb on localhost user mycli directly\n $ smycli -h localhost -u root mydb \n\n #connect mydb on dbhost but via the tunnel \"localhost->sshhost\" which is encrypted,then \"sshhost->dbhost\" is not encrypted.\n $ smycli -u admin -h dbhost -P 3306 --ssh-user=root --ssh-host sshhost mydb \n\n #connect mydb on dbhost but via the tunnel \"localhost->dbhost\" which is encrypted on the whole traffic.\n $ smycli -u admin -h dbhost -P 3306 --ssh-user=root --ssh-host dbhost mydb \n\nFeatures\n--------\n\nexcept the excillent features of cli tool `mycli`,smycli has additional ones:\n* encrypt the traffic data via ssh\n* via the \"proxy node\" ,connect to DB hosts from anywhere, safely\n\nCopyright:\n--------------\nAll rights of `mycli` is reserved BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS,the license is [here](https://github.com/dbcli/mycli/blob/master/LICENSE.txt),and other rights is reserved by the BY THE COPYRIGHT HOLDERS .\nAll rights of `smycli` is reserved .\nEmail:xgtiger@163.com\n\n## Detailed Install Instructions:\nyou can install mycli as follows:\n\n```\n$ sudo pip install mycli\n```\n\n### Thanks:\nThanks to all the ones who made this excellent tool `mycli`.\n\n### Compatibility\n\nTests have been run on OS X and Linux.\n\nTHIS HAS NOT BEEN TESTED IN WINDOWS, but the libraries used in this app are Windows compatible. This means it should work without any modifications.", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/XGTIGER/smycli", "keywords": "cli mysql mycli", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "smycli", "package_url": "https://pypi.org/project/smycli/", "platform": "", "project_url": "https://pypi.org/project/smycli/", "project_urls": { "Homepage": "https://github.com/XGTIGER/smycli" }, "release_url": "https://pypi.org/project/smycli/0.1.6/", "requires_dist": null, "requires_python": "", "summary": "Base on the MYCLI CLI for MySQL Database,add additional secure manner via ssh tunnel", "version": "0.1.6" }, "last_serial": 2998769, "releases": { "0.1.2": [ { "comment_text": "", "digests": { "md5": "dcfde473f0ac74d326c4abf1e0031758", "sha256": "c6e123ca496e6248d9690a6a81cf12aacbe0321d6a31e09a22c7d3bf20e2b8cf" }, "downloads": -1, "filename": "smycli-0.1.2.tar.gz", "has_sig": false, "md5_digest": "dcfde473f0ac74d326c4abf1e0031758", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8274, "upload_time": "2017-01-03T07:14:15", "url": "https://files.pythonhosted.org/packages/15/42/81e8228312e9af168bd2e808088cb188cbc4d5f41f1d38e0a1a22bff772c/smycli-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "86024bea078c236c722a668e409870e9", "sha256": "a5df711cb97758ae13d70fd5c787fefbd725b545d0ad766d6cf99d5e30b5f14f" }, "downloads": -1, "filename": "smycli-0.1.3.tar.gz", "has_sig": false, "md5_digest": "86024bea078c236c722a668e409870e9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8288, "upload_time": "2017-01-03T09:45:08", "url": "https://files.pythonhosted.org/packages/e9/8d/9289f047f6a3eabe5bd553426baa251261807a650fbbf34ad4e2611ba110/smycli-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "157741493f2c6c92deb8b7ab4b16cb5e", "sha256": "62cd5f641855b5e8cbdd8e447c774f939bec1292805ed4f6e6d795348cc65609" }, "downloads": -1, "filename": "smycli-0.1.4.tar.gz", "has_sig": false, "md5_digest": "157741493f2c6c92deb8b7ab4b16cb5e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8306, "upload_time": "2017-01-03T09:54:25", "url": "https://files.pythonhosted.org/packages/98/0e/145e55f4fdf081df51b81aa8a62d803cb19df7f35208ec2162b2f8910315/smycli-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "615a9277625577e4c48328e258193919", "sha256": "4aa876ef9b2928261754745ebabb23df5670270b42e3d8dcaefb53436deb671a" }, "downloads": -1, "filename": "smycli-0.1.5.tar.gz", "has_sig": false, "md5_digest": "615a9277625577e4c48328e258193919", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8306, "upload_time": "2017-01-03T10:00:44", "url": "https://files.pythonhosted.org/packages/93/b2/11336517f88f54f1d1a80bb5ec6eb7e00d0f45fb0abb071294c77c2d6d0b/smycli-0.1.5.tar.gz" } ], "0.1.6": [ { "comment_text": "", "digests": { "md5": "a41d113cc8f7c3ebeec9dcf42ce167cf", "sha256": "9dae40b94265dfecac33ebc582a3da82617825904024dbe1f24f3d4f2e759726" }, "downloads": -1, "filename": "smycli-0.1.6.tar.gz", "has_sig": false, "md5_digest": "a41d113cc8f7c3ebeec9dcf42ce167cf", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8322, "upload_time": "2017-01-03T10:37:28", "url": "https://files.pythonhosted.org/packages/9e/b5/49187cad8754aeef601466a35504c4c47932b1e2ad321741faef1c8918e6/smycli-0.1.6.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "a41d113cc8f7c3ebeec9dcf42ce167cf", "sha256": "9dae40b94265dfecac33ebc582a3da82617825904024dbe1f24f3d4f2e759726" }, "downloads": -1, "filename": "smycli-0.1.6.tar.gz", "has_sig": false, "md5_digest": "a41d113cc8f7c3ebeec9dcf42ce167cf", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8322, "upload_time": "2017-01-03T10:37:28", "url": "https://files.pythonhosted.org/packages/9e/b5/49187cad8754aeef601466a35504c4c47932b1e2ad321741faef1c8918e6/smycli-0.1.6.tar.gz" } ] }