Skip to content

Commit b6d33e3

Browse files
nodomainfabaff
nodomain
authored andcommitted
Update recorder.markdown (home-assistant#1921)
Updated to include the "native" mysqlclient package as documented in https://community.home-assistant.io/t/error-in-setting-up-recorder-with-mysql/7705/4 - verified that it works as well ;-)
1 parent c362cab commit b6d33e3

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

source/_components/recorder.markdown

+4-4
Original file line numberDiff line numberDiff line change
@@ -90,8 +90,8 @@ If you only want to hide events from e.g. your history, take a look at the [`his
9090
| Database engine | `db_url` |
9191
| :---------------|:---------------------------------------------------------|
9292
| SQLite | `sqlite:///PATH/TO/DB_NAME` |
93-
| MySQL | `mysql+pymysql://SERVER_IP/DB_NAME` |
94-
| MySQL           | `mysql+pymysql://user:password@SERVER_IP/DB_NAME`       |
93+
| MySQL | `mysql://SERVER_IP/DB_NAME` |
94+
| MySQL           | `mysql://user:password@SERVER_IP/DB_NAME`       |
9595
| PostgreSQL | `postgresql://SERVER_IP/DB_NAME` |
9696
| PostgreSQL | `postgresql://scott:tiger@SERVER_IP/DB_NAME` |
9797

@@ -105,7 +105,7 @@ For MySQL you may have to install a few dependencies:
105105

106106
```bash
107107
$ sudo apt-get install libmysqlclient-dev
108-
$ pip3 install pymysql
108+
$ pip3 install mysqlclient
109109
```
110110
If you are in a virtual environment, don't forget to activate it before installing the pymysql package.
111111

@@ -114,7 +114,7 @@ pi@homeassistant:~ $ sudo -i
114114
root@homeassistant:~# su homeassistant
115115
homeassistant@homeassistant:/root$ cd /srv/homeassistant/homeassistant_venv/
116116
homeassistant@homeassistant:/srv/homeassistant/homeassistant_venv$ source bin/activate
117-
(homeassistant_venv) homeassistant@homeassistant:/srv/homeassistant/homeassistant_venv$ pip3 install pymysql
117+
(homeassistant_venv) homeassistant@homeassistant:/srv/homeassistant/homeassistant_venv$ pip3 install mysqlclient
118118
```
119119

120120
### {% linkable_title PostgreSQL %}

0 commit comments

Comments
 (0)