1.5.2:

Bug Fixes:

Protect against port number being None when no port is specified in command line.

1.5.1:

Bug Fixes:

Cast the value of port read from my.cnf to int.

1.5.0:

Features:

Make a config option to enable audit_log. (Thanks: Matheus Rosa).
Add support for reading .mylogin.cnf to get user credentials. (Thanks: Thomas Roten). This feature is only available when pycrypto package is installed.
Register the special command prompt with the \R as alias. (Thanks: Matheus Rosa). Users can now change the mysql prompt at runtime using prompt command. eg:
```
mycli> prompt \u@\h>
Changed prompt format to \u@\h>
Time: 0.001s
amjith@localhost>
```
Perform completion refresh in a background thread. Now mycli can handle databases with thousands of tables without blocking.
Add support for system command. (Thanks: Matheus Rosa). Users can now run a system command from within mycli as follows:
```
amjith@localhost:(none)>system cat tmp.sql
select 1;
select * from django_migrations;
```
Caught and hexed binary fields in MySQL. (Thanks: Daniel West). Geometric fields stored in a database will be displayed as hexed strings.
Treat enter key as tab when the suggestion menu is open. (Thanks: Matheus Rosa)
Add "delete" and "truncate" as destructive commands. (Thanks: Martijn Engler).
Change \dt syntax to add an optional table name. (Thanks: Shoma Suzuki). \dt [tablename] will describe the columns in a table.
Add TRANSACTION related keywords.
Treat DESC and EXPLAIN as DESCRIBE. (Thanks: spacewander).

Bug Fixes:

Fix the removal of whitespace from table output.
Add ability to make suggestions for compound join clauses. (Thanks: Matheus Rosa).
Fix the incorrect reporting of command time.
Add type validation for port argument. (Thanks Matheus Rosa)

Internal Changes:

Make pycrypto optional and only install it in *nix systems. (Thanks: Iryna Cherniavska).
Add badge for PyPI version to README. (Thanks: Shoma Suzuki).
Updated release script with a --dry-run and --confirm-steps option. (Thanks: Iryna Cherniavska).
Adds support for PyMySQL 0.6.2 and above. This is useful for debian package builders. (Thanks: Thomas Roten).
Disable click warning.

1.4.0:

Features:

Add source command. This allows running sql statement from a file.

eg:
```
mycli> source filename.sql
```
Added a config option to make the warning before destructive commands optional. (Thanks: Daniel West)

In the config file ~/.myclirc set destructive_warning = False which will disable the warning before running DROP commands.
Add completion support for CHANGE TO and other master/slave commands. This is still preliminary and it will be enhanced in the future.
Add custom styles to color the menus and toolbars.
Upgrade prompt_toolkit to 0.46. (Thanks: Jonathan Slenders)

Multi-line queries are automatically indented.

Bug Fixes:

Fix keyword completion after the WHERE clause.
Add \g and \G as valid query terminators. Previously in multi-line mode ending a query with a \G wouldn't run the query. This is now fixed.

1.3.0:

Features:

Add a new special command (\T) to change the table format on the fly. (Thanks: Jonathan Bruno) eg:
```
mycli> \T tsv
```
Add --defaults-group-suffix to the command line. This lets the user specify a group to use in the my.cnf files. (Thanks: Iryna Cherniavska)

In the my.cnf file a user can specify credentials for different databases and invoke mycli with the group name to use the appropriate credentials. eg:
```
# my.cnf
[client]
user   = 'root'
socket = '/tmp/mysql.sock'
pager = 'less -RXSF'
database = 'account'

[clientamjith]
user     = 'amjith'
database  = 'user_management'

$ mycli --defaults-group-suffix=amjith   # uses the [clientamjith] section in my.cnf
```
Add --defaults-file option to the command line. This allows specifying a my.cnf to use at launch. This also makes it play nice with mysql sandbox.
Make -p and --password take the password in commandline. This makes mycli a drop in replacement for mysql.

1.2.0:

Features:

Add support for wider completion menus in the config file.

Add wider_completion_menu = True in the config file (~/.myclirc) to enable this feature.

Bug Fixes:

Prevent Ctrl-C from quitting mycli while the pager is active.
Refresh auto-completions after the database is changed via a CONNECT command.

Internal Changes:

Upgrade prompt_toolkit dependency version to 0.45.
Added Travis CI to run the tests automatically.

1.1.1:

Bug Fixes:

Change dictonary comprehension used in mycnf reader to list comprehension to make it compatible with Python 2.6.

1.1.0:

Features:

Fuzzy completion is now case-insensitive. (Thanks: bjarnagin)
Added new-line (\n) to the list of special characters to use in prompt. (Thanks: brewneaux)
Honor the pager setting in my.cnf files. (Thanks: Iryna Cherniavska)

Bug Fixes:

Fix a crashing bug in completion engine for cross joins.
Make <null> value consistent between tabular and vertical output.

Internal Changes:

Changed pymysql version to be greater than 0.6.6.
Upgrade prompt_toolkit version to 0.42. (Thanks: Yasuhiro Matsumoto)
Removed the explicit dependency on six.

2015/06/10:

Features:

Customizable prompt. (Thanks Steve Robbins)
Make \G formatting to behave more like mysql.

Bug Fixes:

Formatting issue in \G for really long column values.

2015/06/07:

Features:

Upgrade prompt_toolkit to 0.38. This improves the performance of pasting long queries.
Add support for reading my.cnf files.
Add editor command \e.
Replace ConfigParser with ConfigObj.
Add \dt to show all tables.
Add fuzzy completion for table names and column names.
Automatically reconnect when connection is lost to the database.

Bug Fixes:

Fix a bug with reconnect failure.
Fix the issue with use command not changing the prompt.
Fix the issue where \\r shortcut was not recognized.

2015/05/24

Features:

Add support for connecting via socket.
Add completion for SQL functions.
Add completion support for SHOW statements.
Made the timing of sql statements human friendly.
Automatically prompt for a password if needed.

Bug Fixes:

Fixed the installation issues with PyMySQL dependency on case-sensitive file systems.