ImportError: No module named MySQLdb
pip install mysql-python
apt-get install mysql-devel
OperationalError: (2003, "Can't connect to MySQL server on 'hostname' (10061)")
OperationalError: (1045, "Access denied for user 'username'@'hostname' (using password: YES)")
python
import MySQLdb
try:
conn = MySQLdb.connect(
host="localhost",
port=3306,
user="username",
passwd="password",
db="database"
)
except MySQLdb.Error as e:
print("Error connecting to MySQL:", e)
python
import MySQLdb
try:
conn = MySQLdb.connect(
host="localhost",
user="username",
passwd="password",
db="database",
charset="utf8"
)
except MySQLdb.Error as e:
print("Error connecting to MySQL:", e)
sql
ALTER DATABASE database_name CHARACTER SET utf8 COLLATE utf8_general_ci;
ProgrammingError: (1064, "You have an error in your SQL syntax...")
