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.
So last week on a trip to London, I bought an 