Cannot connect to Mysql database

Chris Angelico rosuav at
Tue Nov 19 07:10:04 CET 2013

On Tue, Nov 19, 2013 at 5:03 PM, Himanshu Garg <hgarg.india at> wrote:
> I have written the script as:
> import os
> import MySQLdb as mdb
> os.chroot("/lxc/rootfs")
> os.chdir("/")
> con = mdb.connect(host="", user="root", passwd="password")
> print "opened"
> con.close()
> But when I execute, I get the following error:
> "File "/usr/lib/python2.7/dist-packages/MySQLdb/", line 80, in Connect
> ImportError: No module named connections"
> I have checked there is a module in the above directory.  Also, when I run the script without doing chroot, it works perfectly.

Do you have a full duplicate of your /usr/lib/python2.7 inside
/lxc/rootfs? It looks like the connect call is trying to import
something, and now that you're chrooted, it can't find it. The
solution might be to manually import a few more modules beforehand
(putting them into sys.modules means they don't need to come from the
file system), or to add more files to your chroot jail.

For a guess, I would try:

import MySQLdb.connections

above your chroot, and see if that helps.


More information about the Python-list mailing list