Can't select database

[tomw]

I have setup a MySQL database for a PHP script. Having entered the dbname, username and PW into the script setup, the script's install routine fails to create the required tables in the database. The script developer sent a MySQL version-test routine that returns 'Can't select database'. The versions of MySQL and PHP running both exceed the stated requirements of the script.

Any ideas where this failing?

[tomw]

yes...I have entered those as username_dbname, username_dbuser and PW (is username_ also needed for the password?

[cPanelDavidG]

I have setup a MySQL database for a PHP script. Having entered the dbname, username and PW into the script setup, the script's install routine fails to create the required tables in the database. The script developer sent a MySQL version-test routine that returns 'Can't select database'. The versions of MySQL and PHP running both exceed the stated requirements of the script.

Any ideas where this failing?

Are you using the full name of the database: username_dbname where username is your cPanel username?

[cPanelDavidG]

yes...I have entered those as username_dbname, username_dbuser and PW (is username_ also needed for the password?

Passwords do not require the username_ prefix.

Does the database user you are using has privileges to that database? You can verify this by clicking on the "MySQL Databases" icon in the cPanel interface and then clicking on the username to see what privileges they have.

[tomw]

The user I setup in the database has 'All Privileges'

[ckh]

Verify the user is assigned to the db. This is the most often skipped step when setting up a db.

Another thing to try is delete the user and manually add the user again and then assign the user to the db. I've experienced problems with the wizard before.

[tomw]

Yes - the user I created is assigned to the DB. Also have deleted that user and recreated several times with no success.

[cPanelDavidG]

Yes - the user I created is assigned to the DB. Also have deleted that user and recreated several times with no success.

You may want to have our technical analysts take a look at this as this seems very abnormal. You can contact our technical analysts at: http://tickets.cPanel.net/submit

[NancyD]

try to check the connection of the your database from the PHP script....their might me a problem between that I also experienced that kind of problem..