Installing mysql-python on Centos

by

Step 1 – Install package

# yum install MySQL-python
Loaded plugins: auto-update-debuginfo, langpacks, presto, refresh-packagekit
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MySQL-python.i686 0:1.2.3-3.fc15 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package              Arch         Version                 Repository      Size
================================================================================
Installing:
 MySQL-python         i686         1.2.3-3.fc15            fedora          78 k

Transaction Summary
================================================================================
Install       1 Package(s)

Total download size: 78 k
Installed size: 220 k
Is this ok [y/N]: y
Downloading Packages:
Setting up and reading Presto delta metadata
Processing delta metadata
Package(s) data still to download: 78 k
MySQL-python-1.2.3-3.fc15.i686.rpm                       |  78 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : MySQL-python-1.2.3-3.fc15.i686                               1/1 

Installed:
  MySQL-python.i686 0:1.2.3-3.fc15                                              

Complete!

Step 2 – Test working

import MySQLdb
db = MySQLdb.connect("localhost","myusername","mypassword","mydb" )
cursor = db.cursor()
cursor.execute("SELECT VERSION()")
data = cursor.fetchone()    
print "Database version : %s " % data    
db.close()

Ouput:

Database version : 5.5.20

More Related Contents:

  1. mysql to pdf – python or ruby [closed]
  2. Installing specific package version with pip
  3. Why do integers in database row tuple have an ‘L’ suffix?
  4. How can I connect to MySQL in Python 3 on Windows?
  5. Python: best practice and securest way to connect to MySQL and execute queries
  6. Python & MySql: Unicode and Encoding
  7. Authentication plugin ‘caching_sha2_password’ is not supported
  8. How to disable SQLAlchemy caching?
  9. Setting Django up to use MySQL
  10. memory-efficient built-in SqlAlchemy iterator/generator?
  11. How can I insert data into a MySQL database?
  12. How to use MySQLdb with Python and Django in OSX 10.6?
  13. When to close cursors using MySQLdb
  14. How to enable MySQL client auto re-connect with MySQLdb?
  15. How to build a flask application around an already existing database?
  16. SQLAlchemy ON DUPLICATE KEY UPDATE
  17. Python MySql Insert not working
  18. What is the best solution for database connection pooling in python?
  19. Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
  20. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  21. trapping a MySql warning
  22. Repeated MySQL queries from Python return the same data [duplicate]
  23. ImportError: No module named ‘MySQL’
  24. Simple Subquery with OuterRef
  25. pymysql fetchall() results as dictionary?
  26. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  27. Install mysqlclient for Django Python on Mac OS X Sierra
  28. ‘pip install MySQL-python’ fails with ‘IndexError’
  29. How to insert / retrieve a file stored as a BLOB in a MySQL db using python
  30. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject

Leave a Comment