python连接mysql数据库

安装python

apt-get install python

安装mysqlLdb:

apt-cache search MySQLdb
2022 apt-get install python-mysqldb

实例代码:

#!/usr/bin/env python
#coding=utf-8
#!/usr/bin/python

# -*- coding: utf-8 -*-
import MySQLdb as mdb
import sys
con = None
try:
  con = mdb.connect('localhost', 'root', 'firmy', '56demo');
  cur = con.cursor()
  cur.execute("SELECT VERSION()")
  data = cur.fetchone()
  print "Database version : %s " % data
except mdb.Error, e:
  print "Error %d: %s" % (e.args[0],e.args[1])
  sys.exit(1)
finally:
  if con:
  con.close()

原文地址:https://www.cnblogs.com/firmy/p/3315427.html