try echoing the MySQL error message in your or die statement
PHP Code:
or die ("MySQL crapped out whinging:".mysql_error()." error code:".mysql_error);
also you need to make certain your script/installation is displayign errors
PHP Code:
ini_set('display_errors','On')
error_reporting(E_ALL);
or
PHP Code:
error_reporting(-1);
its almost certainly going to be a problem with the permissions that were GRANTed to that user. check da manual for the correct GRANT syntax.
you may find it easier to GRANT permissions using MySQL Administrator availabel fromt eh MySQL website as part of the MySQL GUI tools.#
the PHP manual is usually a pretty good source for such issues