i'm used having tab-completion mysql keywords, database names etc in mysql, in freshly installed mysql (via 'apt-get install mysql-server') works table names, not database names.
i supplying --auto-rehash option when starting mysql command line client interface. i'm aware can set default via my.cnf, want working first.
the mysql docs tell me auto-rehash feature "requires mysql client compiled readline library."
'aptitude show mysql-client' tells me have 5.5.43-0ubuntu0.14.04.1.
for debugging purposes, how can know if mysql-client has readline, , if not, how 1 does?
resolved: wasn't specifying database name when invoking mysql command line interface!
auto-completion works expected if go in as:
mysql -u root -p mysql # or mysql -u root -p mydatabase
as opposed to:
mysql -u root -p
(and --auto-rehash on default per docs)
Comments
Post a Comment