# Using mysql in conjuntion with Sage?

Hello,

I'm using Ubuntu (new to it), and am really excited about Sage. I can't afford Matlab. I would like to interface Sage/Python with MySql. I've already installed MySql according to this link.

I tried the command import MySQLdb, but it didn't work. The output from my terminal is pasted below.

johndoe@johndoe:~$ python Python 2.6.6 (r266:84292, Sep 15 2010, 15:52:39) [GCC 4.4.5] on linux2 Type "help", "copyright", "credits" or "license" for more information.

import MySQLdb Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: No module named MySQLdb quit Use quit() or Ctrl-D (i.e. EOF) to exit quit() johndoe@johndoe:~$ cd ~/Sage johndoe@johndoe:~/Sage$ ./sage ---------------------------------------------------------------------- | Sage Version 4.6.1, Release Date: 2011-01-11 | | Type notebook() for the GUI, and license() for information. | ---------------------------------------------------------------------- sage: import MySQLdb --------------------------------------------------------------------------- ImportError

Traceback (most recent call last)/home/johndoe/Sage/<ipython console=""> in <module>()

ImportError: No module named MySQLdb sage: sage:

I believe I have the same problem as discussed here

However, I'm so new to Ubuntu, that I don't quite follow. I followed the instructions and ran

```
import sys
for path in sys.path:
print path
```

I then received the output pasted below.

```
/home/johndoe/Sage/local/bin
/home/johndoe/Sage/local/lib/python2.6/site-packages/setuptools-0.6c9-py2.6.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/Twisted-9.0.0-py2.6-linux-i686.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/zope.interface-3.6.1-py2.6-linux-i686.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/zope.proxy-3.6.0-py2.6-linux-i686.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/zope.exceptions-3.6.1-py2.6.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/zope.testing-3.9.5-py2.6.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/ZConfig-2.8.0-py2.6.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/zdaemon-2.0.4-py2.6.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/ZODB3-3.7.0-py2.6-linux-i686.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/Pygments-1.3.1-py2.6.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/Jinja2-2.5.5-py2.6.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/Sphinx-1.0.4-py2.6.egg
/home/johndoe/Sage/local/lib/python2.6/site-packages/SQLAlchemy-0.5.8-py2.6.egg
/home/johndoe/Sage/devel/sagenb
/home/johndoe/Sage/local/bin
/home/johndoe/Sage/local/lib/python
/home/johndoe/Sage/local/lib/python26.zip
/home/johndoe/Sage/local/lib/python2.6/plat-linux2
/home/johndoe/Sage/local/lib/python2.6/lib-tk
/home/johndoe/Sage/local/lib/python2.6/lib-old
/home/johndoe/Sage/local/lib/python2.6/lib-dynload
/home/johndoe/Sage/local/lib/python2.6/site-packages
/home/johndoe/Sage/local/lib/python2.6/site-packages/PIL
/home/johndoe/Sage/local/lib/python2.6/site-packages/IPython/Extensions
/home/johndoe/.sage/ipython
```

However, I don't understand how to use this information to update the PYTHONPATH environment variable or the library path.

Can anyone help? My basic dilemma is how to ...