The mysql libraries are not per see installed with python, thus:<\/p>\n
sudo apt-get install python-mysql<\/code><\/pre>\nScript:<\/p>\n
\r\n#!\/usr\/bin\/python\r\nimport MySQLdb\r\n\r\ndb = MySQLdb.connect(host=\"localhost\", # your host, usually localhost\r\n user=\"tomas\", # your username\r\n passwd=\"tomas1234\", # your password\r\n db=\"test\") # name of the data base\r\n\r\n# Create a cursor object that executes all required queries\r\ncur = db.cursor()\r\n\r\n# create sample table\r\ncur.execute(\"CREATE TABLE IF NOT EXISTS tomastest(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, data VARCHAR(100))\")\r\n\r\n# create sample data\r\ncur.execute(\"INSERT INTO tomastest(data) VALUES('Test data'); commit;\")\r\n\r\n# execute select sql\r\ncur.execute(\"SELECT * FROM tomastest\")\r\n\r\n# Get the number of rows in the resultset\r\nnumrows = cur.rowcount\r\nprint \"Rows count: \",numrows\r\nfor row in cur.fetchall():\r\n print row[0], row[1]\r\ndb.close()\r\n<\/code><\/pre>\nIf not providede, thus create test mysql db (sMySQL Docs<\/a>)<\/p>\nmysql> CREATE DATABASE test;\r\nmysql> use test<\/code><\/pre>\n