Actually, neither of those are the problem I don't think, having experienced this myself, the problem is either I don't think jwhance gave full access permissions to that database for the "photopost" user:
Touché! I am pretty sure though it is the second issue with the password... I don't understand it (not familiar enough with MySQL) but it worked for me when I was having the same errors... I guess it is a SQL 4.1 and older client API issue...which is also a PHP 4.3.10 issue which is compiled with an older MySQL client API.
I cannot connect to the PhotoPost MySQL server. [host:$host][mysql_user:$mysql_user][mysql_password:$mysql_password]. Check your config-inc.php for the correct settings and rerun.
I am sure that you have checked the password and still it doesn't work
Under Windows try WINMYSQLADMIN and make my.ini file
Search Windows directory to my.ini and what you see is a password who I bett you did'nt know '
Place this in user and pass in config-ini and YEP its works. Seems WHICH user installed MySql....Administrator or User with Admin priveleges Very strange
Thank you, that article you mentioned specifically mentions the password fix as a possible solution. So in fact, that was exactly the problem... and I listed what exactly the solution was, which is modifying your user password to the older hash algorithim. Apparently you can also modify the mysql server install to include the older hash, but given your inexperience with MySQL and my own, changing the password of your account to the old style seems the easiest.