mycli
mycli copied to clipboard
dbcli
A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
The latest version of mariadb uses the "unix_socket" plugin My root user has no password. I can use sudo mysql sudo mysql -u root Direct Login No login password Only...
I was trying to connect a remote mysql server. and I got this message > (1045, u"Access denied for user 'oms-dev'@'10.1.9.18' (using password: YES)" following is mysql server connection information...
All autocomplete works fine, except when I try to create grant access, it doesn't autocomplete the database name. Example (no autocomplete): `> GRANT ALL ON database_name.* TO 'db_user'@'localhost'` I thought...
I read the [FAQ](https://www.mycli.net/faq) and the [Docs](https://www.mycli.net/docs) but I didn't find anything about this issue. Is it possible to disable quoting on auto-completed fields that do not require quoting? For...
Something I wish all mysql shells/cli clients had is the ability to easily browse to a related record if the foreign key is setup. Example: a posts table has a...
How do i echo / display mycli setting? i.e. I set key_bindings to vi, how can i now inspect what key_bindings is set to?
 I accessed MariaDB through mycli, and `localhost` is displayed as 'none'. Is this just default configuration? Or can I fix it?
When creating a query the foreign key relations on the tables can be used to inform autocomplete of possible JOINs, eg ``` CREATE TABLE Persons ( PersonID int, LastName varchar(255),...
General users can run it, but the **root** user will be error. ```sh > sudo mycli Traceback (most recent call last): File "/usr/bin/mycli", line 5, in from mycli.main import cli...
Not sure how easy this would be, but if sorting by frecency is possible then that'd really kick ass. There are tab completion terms that always show up on top...
