4 ms·
I'm the author of this project. I'll be happy to answer any questions. Brief Intro: This is a command line tool that is intended as a replacement for MySQL cli
by amjith 11y ago
I'm the author of this project. I'll be happy to answer any questions.
Brief Intro:
This is a command line tool that is intended as a replacement for MySQL client.
It works with MySQL, MariaDB and Percona.
It is written in Python and it works in Python 2.6 to Python 3.4.
This is a counter part to http://pgcli.com http://pgcli.com.
MyCli was funded through Kickstarter (https://www.kickstarter.com/projects/1839007321/mysql-cli https://www.kickstarter.com/projects/1839007321/mysql-cli)
- trashcan 11y agoI tried installing it via pip on CentOS 6.6, and I get: Traceback (most recent call last): File "/usr/bin/mycli", line 5, in <module> from pkg_resources import load_entry_point File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 2655, in <module> working_set.require(__requires__) File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 648, in require needed = self.resolve(parse_requirements(requirements)) File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 546, in resolve raise DistributionNotFound(req) pkg_resources.DistributionNotFound: six>=1.8 Am I missing something obvious?
- amjith 11y agoI've heard it from someone else as well. I couldn't reproduce it myself. The suggested solution was to uninstall mycli and reinstall directly from github. pip uninstall mycli six; pip install https://github.com/dbcli/mycli/archive/master.zip https://github.com/dbcli/mycli/archive/master.zip
- autotune 11y agoYep, getting the same issue: [foo@chef-solo ~]$ mycli Traceback (most recent call last): File "/usr/bin/mycli", line 5, in <module> from pkg_resources import load_entry_point File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 2655, in <module> working_set.require(__requires__) File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 648, in require needed = self.resolve(parse_requirements(requirements)) File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 546, in resolve raise DistributionNotFound(req) pkg_resources.DistributionNotFound: six>=1.8 Running sudo python install did the trick. I'm not sure I can really recommending anyone check this out without a working install from a package manager though.
- ecesena 11y agoDid you try it with memsql? Just curious... I don't see any reason why it shouldn't work.
- amjith 11y agoI don't fully understand your question. If you're asking whether this client will work with memsql, then the answer is No. Unless, memsql uses mysql protocol to talk to clients. Mycli uses MySQL adapter called PyMySQL to connect to MySQL instances. I don't think it'll work with memsql. If you're talking about writing a similar client for memsql, then yes it is possible to do that as long as there is a Python adapter for it.
- cauterize 11y agoIs there a way to have it bundled into a single file which I can scp to remote systems and need not worry about dependencies?
- simeonf 11y agoYou could use pex which bundles up python requirements into an executable zip. I ran $ virtualenv PEX (PEX) $ pip install pex (PEX) $ pex mycli -e mycli.main:cli -o mycli.pex (PEX) $ deactivate $ chmod +x mycli.pex $ ./mycli.pex Version: 1.0.1 Chat: https://gitter.im/dbcli/mycli Mail: https://groups.google.com/forum/#!forum/mycli-users Home: http://mycli.net Thanks to the contributor - jweiland.net mysql user@localhost:(none)> You could scp the .pex to another host that also has python installed and it should run. You can also unzip it to inspect its contents...
- cauterize 11y agoVery cool! Thanks!