using Mysql and SqlAlchemy in Pyramid Framework
Question: Pyramid Framework comes with a sample tutorial of sql alchemy that uses
sqlite. The problem is that i want to use mysql so i change this

    
    
    sqlalchemy.url = sqlite:///%(here)s/tutorial.db
    

Into this

    
    
    sqlalchemy.url = mysql://root:22password@localhost/alchemy
    

when i try to run

    
    
    ../bin/pserve development.ini --reload
    

It gives me the following error

    
    
     File "build/bdist.linux-i686/egg/sqlalchemy/connectors/mysqldb.py", line 52, in dbapi
    ImportError: No module named MySQLdb
    

I understand that i should include the dependecies of my app in setup.py but i
don't know what to include right now some help please my setup.py looks like
this

    
    
    import os
    import sys
    
    from setuptools import setup, find_packages
    
    here = os.path.abspath(os.path.dirname(__file__))
    README = open(os.path.join(here, 'README.txt')).read()
    CHANGES = open(os.path.join(here, 'CHANGES.txt')).read()
    
    requires = [
        'pyramid',
        'SQLAlchemy',
        'transaction',
        'pyramid_tm',
        'pyramid_debugtoolbar',
        'zope.sqlalchemy',
        ]
    
    if sys.version_info[:3] < (2,5,0):
        requires.append('pysqlite')
    
    setup(name='tutorial',
          version='0.0',
          description='tutorial',
          long_description=README + '\n\n' +  CHANGES,
          classifiers=[
            "Programming Language :: Python",
            "Framework :: Pylons",
            "Topic :: Internet :: WWW/HTTP",
            "Topic :: Internet :: WWW/HTTP :: WSGI :: Application",
            ],
          author='',
          author_email='',
          url='',
          keywords='web wsgi bfg pylons pyramid',
          packages=find_packages(),
          include_package_data=True,
          zip_safe=False,
          test_suite='tutorial',
          install_requires = requires,
          entry_points = """\
          [paste.app_factory]
          main = tutorial:main
          [console_scripts]
          populate_tutorial = tutorial.scripts.populate:main
          """,
          )
    


Answer: Try adding `"MySQLdb"` to the requires list. It was fine with sqlite3 as that
comes with python (as of version 2.5), MySQLdb doesn't and needs to be
installed separately.

UPDATE:

Try `"mysql-python"` in the requires list instead.

