I am quite the newcomer to MySQL and WordPress (and apache and blogging all at once, eep!) and while after reading the docs for all of the above and perusing the support forums I still seem to have this basic problem.
I created a database and user both via the MySQL command line and MySQL Administrator as descibred here (http://codex.wordpress.org/Installing_WordPress) among other places. Should be simple.
But whatever I seem to use as the wp-config.php data, including "root" I cannot seem to get past this error. I am guessing that I have an improper database setup, as the config file is straightforward. No typos like missing single quotes, so it appears to have to be either wrong info or bad database setup.
I'm testign this all on winXP sp2, apache 2.0.52, php4.3.1, and WP 1.2.2.
Any help for my confusion is appreciated. Thanks!