mycli icon indicating copy to clipboard operation
mycli copied to clipboard

No autocomplete while grant databases access

Open Izzur opened this issue 7 years ago • 1 comments

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 it will autocomplete like when you use USE command (selecting database) Example (with autocomplete): > USE database_name

===

Below my environtment:

  • mycli v1.5.2 (install via apt-get)
  • mysql v15.1 Distrib 10.2.12-MariaDB
  • Ubuntu 16.04.3 LTS

Izzur avatar Feb 08 '18 04:02 Izzur

I thought this phrase had a problem with the completion engine, so I looked for it. And there I found the grant phrase with a search engine. I ran a test by changing every phrase that is table. 271line in completion_engine file fix the table to database, and save it, an run it again, and it will operate normally. and issue will be solved.

Yedam22 avatar May 07 '21 02:05 Yedam22