shell
pip install mysqlclient
shell
sudo apt update
sudo apt install mysql-server
shell
mysql_config --libs
mysql_config --include
shell
setx LIBMYSQL_PATH "C:\Program Files\MySQL\MySQL Server 8.0\lib\libmysql.dll"
setx LIBMYSQL_INCLUDE "C:\Program Files\MySQL\MySQL Server 8.0\include"
shell
export LIBMYSQL_PATH=/usr/lib/x86_64-linux-gnu/libmysqlclient.so
export LIBMYSQL_INCLUDE=/usr/include/mysql
python
import MySQLdb
db = MySQLdb.connect(
host="localhost",
user="your_username",
passwd="your_password",
db="your_database_name"
)
cursor = db.cursor()
cursor.execute("SELECT * FROM your_table")
result = cursor.fetchall()
for row in result:
print(row)
db.close()
