How to setup numpy+scipy+matplotlib+MySQL with virtualenv in Eclipse or Scipy?

How to setup numpy+scipy+matplotlib+MySQL with virtualenv in Eclipse or
Scipy?

I need the following:
an IDE with an integrated console, code-completion and preferably a
"help"-window for functions I am about to use, similarly to Matlab
the ability to access the mySQL-database through python
if needed flexibly add more python modules
and thought that this would not be that hard. Two days later I don't know
how to get any further. What I did so far during long and painful learning
process:
install mySQL for mac
install macports couldn't figure out how to use it properly and
uninstalled it right away
installed anaconda-python package together with Spyder, tried to add the
mysql-package and uninstalled it
installed canopy from Enthought and uninstalled it since the mysql-package
requires a commercial version of Canopy
found that I messed up my system considerably and removed the /usr/local
directory and the `/Users/myaccountname/.batch_profile' and started again
installed homebrew, virtualenv according to this description
installed python2.7 and python 3 through homebrew
installed Eclipse (as one recommended IDE) with PyLDev and Spyder as
another option
created a virtualenv, activated it and installed mySQL-python package in it
Through all the installing/uninstalling I might have messed up my system
considerably, since I couldn't find any good description that I could
follow from step, I did trial and error, got quite far but now I am stuck:
In Eclipse I can select a python interpreter, likewise in spyder
(Preferences/console/Advanced settings). If I select the folder where
virtualenv created a version of Python + the mysql library, I am able to
use import mySQL-python in the code but unable to access
standard-libraries like numpy, scipy and matplotlib. If I try to add them
to the same virtualenv using pip install [...] I get a ton of errors for
each of the standard-libraries (an upload the log-files if needed).
How can I get either Eclipse of Spyder to run with all the regular
libraries as well as the mysql-library and any other future library that I
might need? I am running Mac OS X 10.8.4
If there is any way to start from scratch, I am happy to do that,
otherwise any advice that could take me from where I am at the moment
closer to where I want to get is appreciated,
thanks.