MySQL and Movable Type don't tango

I really would love to get stuck into trying out Movable Type for myself if I could get it to run.

No progress since I successfully installed it a few days ago on a local Windows PC running as a server. As far as I can tell, what's preventing me running MT isn't MT, it's MySQL.

Running the mt-check.cgi script produces a successful result - it tells me that MT is properly installed and set up and ready to go.

When I run the mt-load.cgi script, though, it stops very early in its execution with this error message:

Bad ObjectDriver config: Connection error: Access denied for user 'mt_user'@'localhost' (using password: YES)

The only difference from the error I first had is that, this time, the error includes a complete user name as I have uninstalled and reinstalled MySQL a couple of times.

I posted a comment about the error in the Movable Type Community Forum. Received a helpful response that was useful in initial troubleshooting, plus a link to a thread on the MySQL bugs section which indicates that there is a bug in the version of MySQL (4.1.13) that I have installed. Based on the final comment in the thread, I downloaded and installed the v5 beta.

That didn't work, unfortunately. I'm reasonably sure there must have been a step I missed somewhere before installing the beta as it resulted in major system instability (100% CPU use, sluggish performance, lack of responsiveness in the MySQL Administrator). So I uninstalled every MySQL instance, restarted the PC a couple of times during that process and re-installed 4.1.13 again.

Still this error when mt-load.cgi runs.

I'm actually stumped now. I need to retrace all steps again to make sure that there's not something I missed somwehere or did incorrectly at any stage in the overall installation, including checking into IIS. Trouble is, that's a left-brain approach whereas I'm definitely a right-brain kind of person ;)

So back to square one with no imminent solution. There has to be one - I just haven't found it yet.

[EDIT 31/7/05] Ok, reading the comprehensive MySQL Reference Manual, section 5.6.8 Causes of Access Denied Errors, has this explanation:

If you specify a hostname when trying to connect, but get an error message where the hostname is not shown or is an IP number, it means that the MySQL server got an error when trying to resolve the IP number of the client host to a name:

shell> mysqladmin -u root -pxxxx -h some-hostname ver
Access denied for user 'root'@'' (using password: YES)

This indicates a DNS problem. To fix it, execute mysqladmin flush-hosts to reset the internal DNS hostname cache.

I did the flush-hosts command and got this error:

Access denied for user 'ODBC'@' localhost' (using password: NO)

A bit more investigating needed. Getting closer, I think.

Comments

[Brad Choate]

Are you sure you have the right password in the mt-db-pass.cgi file? And username in mt.cfg ("DBUser")? This sounds like a simple authentication problem.

[Nevon]

Thanks Brad.

Yes, the password is correct and matches the right user name.

But I'm sure you're right that it's something re authentication. I just haven't been able to figure out what. Yet.

So I will do the Sherlock Holmes approach, step by step, eliminating things until whatever's left, no matter how improbable it seems, has to be the solution!