mycli
mycli copied to clipboard
dbcli
A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
I use Version: 1.23.2 of mycli. I have this DSN: `myAlias = mysql://username:passwordWith@and@[email protected]:5555/mydb` (a bunch of stuff is changed there) But when I go: `mycli myAlias` I receive this error:...
In the middle of writing a query, currently `mycli` checking the syntax and throwing an error. For example: ```sql database> select count(*) from users where account_id=112354 +----------+ | count(*) |...
I would like to speed up query building process. Most of the time i need to write `SELECT * FROM tableName` and than come back to `*` to have autocompletion...
Please support \W to show warnings after each statement and \w to hide them, just like regular mysql cli.
Context == Queries written without back-ticks on the table names will sometimes result in a table name of `DUAL` in the generated sql-insert formatted text. ``` mysql 10.5.15-MariaDB-0+deb11u1 mycli 1.23.2...
``` mysql --defaults-file="$tmpfile" ``` worked for me (mysql v8), but ``` mycli --defaults-file="$tmpfile" ``` didn't. Turned out I needed to add `--ssl-verify-server-cert` (for some reason that I haven't really figured...
The background of the event is as follows. My database is only limited to a specific machine that can connect. This machine has a socks5 proxy open. If mycli supports...
MySQL 5.5.27 introduces the option `--enable-cleartext-plugin` to _Enable cleartext authentication plugin_ This option is required, for example, in order to use [AWS Aurora MySQL IAM authorized user login](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.Connecting.AWSCLI.html). It would...
When I type `status` at the mycli prompt, it returns the string `'Flush commands'`, not the normal mysql status output that I was expecting. This is causing tests that rely...
I'd like to start contributing, and I followed the steps in **CONTRIBUTING.md** and then tried to run the version of _mycli_ in my virtualenv bin dir. I got module not...