I'm trying to install MySQL Workbench on my Ubuntu box (11.04). The website has a Ubuntu .deb available for download (for 10.10 and 10.04 so I chose 10.10).

However,

sudo dpkg -i mysql-workbench-gpl-5.2.34-1ubu1010-amd64.deb

yields:

(Reading database ... 194069 files and directories currently installed.)

Preparing to replace mysql-workbench-gpl 5.2.34-1ubu1010 (using mysql-workbench-gpl-5.2.34-1ubu1010-amd64.deb) ...

Unpacking replacement mysql-workbench-gpl ...

dpkg: dependency problems prevent configuration of mysql-workbench-gpl:

 mysql-workbench-gpl depends on libctemplate0; however:

  Package libctemplate0 is not installed.

 mysql-workbench-gpl depends on libpython2.6 (>= 2.6); however:

  Package libpython2.6 is not installed.

 mysql-workbench-gpl depends on libzip1 (>= 0.8); however:

  Package libzip1 is not installed.

 mysql-workbench-gpl depends on python-paramiko; however:

  Package python-paramiko is not installed.

 mysql-workbench-gpl depends on python-pysqlite2; however:

  Package python-pysqlite2 is not installed.

dpkg: error processing mysql-workbench-gpl (--install):

 dependency problems - leaving unconfigured

Processing triggers for bamfdaemon ...

Rebuilding /usr/share/applications/bamf.index...

Processing triggers for desktop-file-utils ...

Processing triggers for python-gmenu ...

Rebuilding /usr/share/applications/desktop.en_US.utf8.cache...

Processing triggers for python-support ...

Errors were encountered while processing:

 mysql-workbench-gpl

My question is, is there a way to tell dpkg to automatically fetch missing dependencies, or do I need to manually apt-get install missing packages like libctemplate0 and libpython2.6?

(Or alternatively, is there some other way to get MySQL Workbench easily up & running?)