MySQL kernel for Jupyter/IPython

install:

pip install git+https://github.com/bertrandpsi/jupyter-mysql-kernel

mysql config:

mkdir -p ~/.local/config/
vi ~/.local/config/mysql_config.json

{
    "user"     : "root",
    "port"     : "3306",
    "host"     : "127.0.0.1",
    "charset"  : "utf8",
    "password" : "",
    "display"  : "prettytable"
}

Multi-line sql statements

For multi-line sql statements either ends your last command with a semi-column (;) or have semi-columns and returns in the string.