Fixed mySQL config documentation (home-assistant#1821)

nodomain · fabaff · commit 33191734db75 · 2017-01-19T07:56:08.000+01:00
I just did not work with the description before. See also https://community.home-assistant.io/t/error-in-setting-up-recorder-with-mysql/7705/2
diff --git a/source/_components/recorder.markdown b/source/_components/recorder.markdown
@@ -90,8 +90,8 @@ If you only want to hide events from e.g. your history, take a look at the [`his
 | Database engine | `db_url`                                                 | 
 | :---------------|:---------------------------------------------------------|
 | SQLite          | `sqlite:///PATH/TO/DB_NAME`                              |
-| MySQL           | `mysql://SERVER_IP/DB_NAME`                              |
-| MySQL           | `mysql://user:password@SERVER_IP/DB_NAME`                |
+| MySQL           | `mysql+pymysql://SERVER_IP/DB_NAME`                      |
+| MySQL           | `mysql+pymysql://user:password@SERVER_IP/DB_NAME`        |
 | PostgreSQL      | `postgresql://SERVER_IP/DB_NAME`                         |
 | PostgreSQL      | `postgresql://scott:tiger@SERVER_IP/DB_NAME`             |
 
@@ -105,8 +105,16 @@ For MySQL you may have to install a few dependencies:
 
 ```bash
 $ sudo apt-get install libmysqlclient-dev
-$ pip3 install mysqlclient
+$ pip3 install pymysql
 ```
+If you are in a virtual environment, don't forget to activate it before installing the pymysql package.
+
+```bash
+pi@homeassistant:~ $ sudo -i
+root@homeassistant:~# su homeassistant  
+homeassistant@homeassistant:/root$ cd /srv/homeassistant/homeassistant_venv/
+homeassistant@homeassistant:/srv/homeassistant/homeassistant_venv$ source bin/activate
+(homeassistant_venv) homeassistant@homeassistant:/srv/homeassistant/homeassistant_venv$ pip3 install pymysql
 
 ### {% linkable_title PostgreSQL %}
 
