I'm running a Magento 18.104.22.168 instance that connects & functions successfully with a remote database when specified in app/etc/local.xml as the connection host.
However, when I switch to using 'localhost' as the connection host, it gives me the following error:
Error in file: "app/code/core/Mage/Core/sql/core_setup/install-22.214.171.124.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'core_resource' already exists
I'm not trying to create a new installation - the site is practically complete. Deleting the table it says 'already exists' just pulls up the same error, but with a different table referenced. If I delete all 'core_...' tables, it re-creates them, then throws the same error, saying that they exist. I have tried this on Windows and Linux environments.