What do you want to save?
Add Code snippet
New code examples
-
Python 2021-10-13 04:41:08
connect to mysql database jupyter
# In the python cmd, install packages: pip3 install pymysql pip3 install ipython-sql pip3 install mysqlclient # in the jupyter notebook: import pymysql import pandas as pd conn=pymysql.connect(host='localhost',port=int(3306),user='root',passwd='YOUR_PAS... Add solution -
SQL 2021-10-11 16:05:09
Did you install mysqlclient or MySQL-python?
//For Mysql sudo apt-get install libmysqlclient-dev //If you are using MariaDB sudo apt-get install libmariadbclient-dev pip install mysqlclient /* If you are getting a error like error: command 'x86_64-linux-gnu-gcc' failed with exit status 1 ... Add solution -
-
Python 2021-09-28 05:16:04
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
You have probably installed mysql-connector instead of mysql-connector-python. So you need to install it again for python3: pip3 install mysql-connector-python Add solution -
Best helpers
A. Pettit
+5
Moo-Juice
+5
Jeff Ava
+5
Pharma
+5
Seige
+5
Parallax
+5
PixelZerg
+5
Akiman Barwa
+5
Andrew Lowe
+5
JohnDoe
+5
Meaning
+5
Mahnaz
+5
Silver Rain
+5
Tralston
+5
Rahul Ramesh
+5
Jcjr
+5
Thruston
+5
Alec Cook
+5
Catimann
+5
PeterBocan
+5