Thanks that helped a lot. The root password was set right. Turned out to be that cron wasnt running in the first place as when I run the job manually it created the databases I expected. Guess it just wasnt part of the install or is expected to be running anyway.
Plus now its good to know that tasks are run through that process in ispconfig which I didnt know before.
Thanks for your help !!