Connecting MySQLServer from Jupyter notebook

Question

I wrote this piece of code to connect the MySQLServer from Jupyter notebook:

import sqlalchemy
from sqlalchemy import create_engine

engine = sqlalchemy.create_engine(‘mysql+mysqlconnector://root:password@localhost:3306/dbname′)

I am getting the following error:

File "<ipython-input-12-c958f7670e02>", line 6
    engine = sqlalchemy.create_engine(‘mysql+mysqlconnector://root:password@localhost:3306/events′)
                                           ^
SyntaxError: invalid character in identifier

pip list command also lists PyMySQL (0.9.2).

I used this guideline: https://stackoverflow.com/questions/49359627/access-to-a-mysql-database-via-jupyter-notebook-w-python3. Still it shows : ImportError: No module named 'pymysql' — Debbie, Sep 24 '18 at 18:45
cannot remember. Installed 1 year back. import pymysql perfectly works with gedit editor. — Debbie, Sep 24 '18 at 18:59
@roganjosh : Please see the image I added to my main question. — Debbie, Sep 24 '18 at 19:22
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/180687/discussion-between-debbie-and-roganjosh). — Debbie, Sep 24 '18 at 19:34

score -1 · Answer 1 · answered Sep 24 '18 at 18:46

-1

Replace ‘ character to ' .

Here is new code:

import sqlalchemy from sqlalchemy import create_engine

engine = sqlalchemy.create_engine('mysql+mysqlconnector://root:password@localhost:3306/dbname')

answered Sep 24 '18 at 18:46

Marek Blazicek

1

ImportError: No module named 'mysql' – Debbie Sep 24 '18 at 18:49
For Python 3.6.5 install modules: pip install pymysql pip install mysql-connector-python – Marek Blazicek Sep 24 '18 at 19:29

Connecting MySQLServer from Jupyter notebook

1 Answers1