I'm trying to install WP for a non-profit and things are working like they should. In the PHP My Admin it said I couldn't create a new database. But in some documentation provided to me by the non-profit, it mentioned something called Fantastico that said it would install WordPress 2.1.2 to the site. It created a new db and installed the files. Then I uploaded the 2.2.2 files and overwrote what the Fantastico site installed. I then went to the /wp-admin/upgrade.php and got the following error message.
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the eliotc2_wrdp1 database.
* Are you sure it exists?
* On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?
I checked the PHP My Admin and it shows that the database exists, so I've no idea where to go from here. Thoughts?