Connect MySQL with Python 3.6

Question

I'm looking for a library to connect to MySQL with Python 3.6. All libraries I found did only work with older versions of Python. Sadly I can't change to an older Python version because i need some functions, which are introduced in Python 3.6.

I am programming on a raspberry pi3, but I don't think this should change anything.

Thanks for any help!

*"Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it."* — jww, Feb 28 '17 at 18:55
The question title of the OP seems clear to me. He is looking for a way to connect python 3.6 to the MySQL client when the installer only points to 3.4. This question is a good one and I also looking for this answer. — Yohan Obadia, Jan 22 '18 at 12:59
currently up for 10 months, 8 upvotes, 25,347 views... obviously a popular question with a clear problem and answer... closed as off topic... the poster did not ask which was best--only asked for possibilities to solve a well described problem... some people with too many points need to get their heads out of there, it's an exit only orifice — me_, Jan 23 '18 at 23:53
https://dev.mysql.com/downloads/connector/python/ Development releases -> download for 3.6 — Yan Khonski, Apr 12 '18 at 16:35

score 19 · Accepted Answer · answered Feb 28 '17 at 18:12

19

mysqlclient supports python3.6 officially.

https://pypi.python.org/pypi/mysqlclient

answered Feb 28 '17 at 18:12

Beomi

1,697
16
18

4

I installed mysqlclient with no errors, but I didn't manage to import it in my python script. I tried everything i found on the internet like import myslqclient, mysql, _mysql, mysqldb, ... but nothing worked out fine... – no0by5 Mar 01 '17 at 10:42
I peronally suggest you to use cursor: https://mysqlclient.readthedocs.io/en/latest/MySQLdb.html#module-MySQLdb.cursors – Beomi Mar 01 '17 at 10:50
1

I followed the Readme (https://github.com/PyMySQL/mysqlclient-python/blob/master/README.md) from their Github – no0by5 Mar 01 '17 at 10:55
import _mysql is working with Python 2.7.9, but i need python 3.6 – no0by5 Mar 01 '17 at 10:58
https://mysqlclient.readthedocs.io/en/latest/user_guide.html#some-examples – Beomi Mar 01 '17 at 11:10
1

Python3.6: ModuleNotFoundError: No module named 'MySQLdb' It's working with Python 2.7... – no0by5 Mar 01 '17 at 11:15
did you install with pip3? – Beomi Mar 01 '17 at 11:20
I did "sudo pip3 mysqlclient". For mysqldb it's not working with pip3 – no0by5 Mar 01 '17 at 11:31
does pip3 not working with normal user(not root?) – Beomi Mar 01 '17 at 11:39
pip3 install mysqldb (without sudo) isn't working aswell: Could not find any downloads that satisfy the requirement MySQLdb – no0by5 Mar 01 '17 at 11:44
1

I reinstalled mysqlclient manual with the source package and not with pip and now it's working. – no0by5 Mar 02 '17 at 17:20
Does the mysqlclient also support mariaDB? – Clint Street Aug 23 '17 at 20:07
@ClintStreet Sure – Beomi Aug 23 '17 at 23:39

Connect MySQL with Python 3.6

1 Answers1

Linked