I'm running a Magento 22.214.171.124 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-126.96.36.199.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.