Autocompletion in the MySQL command-line client

Edit or create a file called .my.cnf in your home directory, containing:

[mysql]
auto-rehash