Then i got this error that Zope can't find a file (see below for the error) i have tried putting the files in the directory, and in the product directory, but all these attempts fail. It just won't work. I also have set the MYSQLDB variable on other paths and checked the rights but it still won't work.

I suspect you did the installation of the adaptor (MySQLDA) with the wrong version of python. You *must* use the python used by Zope for the paths and libraries to get set correctly. Try to reinstall the adaptor using the python in $INSTANCEHOME/bin/python.