{"id":260,"date":"2011-10-13T20:26:45","date_gmt":"2011-10-13T20:26:45","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2011\/10\/13\/how-to-use-python-to-connect-to-a-database\/"},"modified":"2022-02-15T11:09:43","modified_gmt":"2022-02-15T16:09:43","slug":"how-to-use-python-to-connect-to-a-database","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/","title":{"rendered":"How to Connect a Database to Python"},"content":{"rendered":"
\"How<\/figure>\n\n\n\n

It is helpful to understand how to connect a database to Python scripts for serving dynamically generated web pages and collaborative reports. Python is almost always included in Linux distributions and used for multiple applications already. You don\u2019t need PHP for this.<\/p>\n\n\n\n

Below we\u2019ll cover how to create a Python database connection (MySQL\/MariaDB) in the Linux terminal.<\/p>\n\n\n\n

How to Connect a Database to Python 2.7<\/h2>\n\n\n\n
  1. Log into SSH<\/a>.<\/li>
  2. From your website root directory, create a Python script file in the \u201ccgi-bin\u201d directory: 
    touch cgi-bin\/test-db.py<\/pre><\/li>
  3. Change the file\u2019s permissions to 755:
    chmod 755 cgi-bin\/test-db.py<\/pre><\/li>
  4. If you wish to execute Python scripts in web browsers, edit your Apache .htaccess file:
    nano .htaccess<\/pre><\/li>
  5. Add the following at the top of the file and save changes: 
    AddHandler cgi-script .py<\/pre><\/li>
  6. To complete the Python database connection you\u2019ll need to know the database host (\u201clocalhost\u201d if on the same system), name, username, and user password.<\/li>
  7. Run Python:
    python<\/pre><\/li>
  8. Ensure you have the MySQL Python module installed:
    import MySQLdb<\/pre> If you receive no notification, that means it is installed. You\u2019ll need to install the module if you receive the error \u201cImportError: No module named mysqldb.\u201d<\/li>
  9. Exit Python:
    exit ()<\/pre><\/li>
  10. If you need to install it, we recommend using your OS repositories. You can also use PIP.
    Alma \/ Enterprise Linux: 
    sudo yum install MySQL-python<\/pre>
    Ubuntu:
    sudo apt-get install python-pip python-dev libmysqlclient-dev<\/pre>
    PIP:
    pip install MySQL-python<\/pre><\/li>
  11. Edit your Python script:
    nano cgi-bin\/test-db.py<\/pre><\/li>
  12. Insert the code below to connect to the database and run \u201cSELECT VERSION(),\u201d which shows our current version of MySQL. Replace the database user, password, and database.
    #!\/usr\/bin\/env python
    import MySQLdb
    # connect to the database
    db = MySQLdb.connect(\"localhost\",\"user\",\"password\",\"database\" )
    # setup a cursor object using cursor() method
    cursor = db.cursor()
    # run an sql question
    cursor.execute(\"SELECT VERSION()\")
    # grab one result
    data = cursor.fetchone()
    # begin printing data to the screen
    print \"Content-Type: text\/html\"
    print
    print \"\"\"
    <!DOCTYPE html>
    <html>
    <head>
    <title>Python - Hello World<\/title>
    <\/head>
    <body>
    \"\"\"
    print \"Database version : %s \" % data
    print\"\"\"
    <\/body>
    <\/html>
    \"\"\"
    # close the mysql database connection
    db.close()<\/pre><\/li>
  13. Save changes.<\/li>
  14. Run the Python script:
    python test-db.py<\/pre> The results should show basic HTML markup and your current database version.<\/li><\/ol>\n\n\n\n
    You can also visit the Python script URL in the web browser if you updated your web server configuration file. You\u2019ll see the database version line.<\/p>\n\n\n\n
    Congrats on learning how to connect a database to Python 2.7+. Learn more about programming with Python<\/a>.<\/p>\n\n\n
    \r\n
    If you don\u2019t need cPanel, don't pay for it. Only pay for what you need with our scalable Cloud VPS Hosting<\/a>.<\/p>\r\n
    \"checkCentOS, Debian, or Ubuntu    \"checkNo Bloatware    \"checkSSH and Root Access<\/p>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"
    It is helpful to understand how to connect a database to Python scripts for serving dynamically generated web pages and collaborative reports. Python is almost always included in Linux distributions and used for multiple applications already. You don\u2019t need PHP for this. Below we\u2019ll cover how to create a Python database connection (MySQL\/MariaDB) in the Read More ><\/a><\/p>\n","protected":false},"author":57014,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4288,4305],"tags":[],"class_list":["post-260","post","type-post","status-publish","format-standard","hentry","category-website","category-databases"],"acf":[],"yoast_head":"\nHow to Connect a Database to Python | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"In this tutorial, we'll show you how you can connect to a MySQL database using python.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect a Database to Python | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, we'll show you how you can connect to a MySQL database using python.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-13T20:26:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-15T16:09:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion-1024x538.jpg\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\"},\"headline\":\"How to Connect a Database to Python\",\"datePublished\":\"2011-10-13T20:26:45+00:00\",\"dateModified\":\"2022-02-15T16:09:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/\"},\"wordCount\":306,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion-1024x538.jpg\",\"articleSection\":[\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/\",\"name\":\"How to Connect a Database to Python | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion-1024x538.jpg\",\"datePublished\":\"2011-10-13T20:26:45+00:00\",\"dateModified\":\"2022-02-15T16:09:43+00:00\",\"description\":\"In this tutorial, we'll show you how you can connect to a MySQL database using python.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion.jpg\",\"width\":1200,\"height\":630,\"caption\":\"How to Connect a Database to Python\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Connect a Database to Python\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Connect a Database to Python | InMotion Hosting","description":"In this tutorial, we'll show you how you can connect to a MySQL database using python.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/","og_locale":"en_US","og_type":"article","og_title":"How to Connect a Database to Python | InMotion Hosting","og_description":"In this tutorial, we'll show you how you can connect to a MySQL database using python.","og_url":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2011-10-13T20:26:45+00:00","article_modified_time":"2022-02-15T16:09:43+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion-1024x538.jpg","type":"","width":"","height":""}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644"},"headline":"How to Connect a Database to Python","datePublished":"2011-10-13T20:26:45+00:00","dateModified":"2022-02-15T16:09:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/"},"wordCount":306,"commentCount":5,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion-1024x538.jpg","articleSection":["Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/","url":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/","name":"How to Connect a Database to Python | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion-1024x538.jpg","datePublished":"2011-10-13T20:26:45+00:00","dateModified":"2022-02-15T16:09:43+00:00","description":"In this tutorial, we'll show you how you can connect to a MySQL database using python.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/02\/python-mysql-database-connetion.jpg","width":1200,"height":630,"caption":"How to Connect a Database to Python"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/how-to-use-python-to-connect-to-a-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Connect a Database to Python"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/57014"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=260"}],"version-history":[{"count":3,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/260\/revisions"}],"predecessor-version":[{"id":94147,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/260\/revisions\/94147"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}