can connect to database server but not the database

  • Resolved nemmesis

    (@nemmesis)


    19 years ago

    I’ve just uploaded my database and content backups to my new web host and am now getting 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 ******* 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_*******. Could that be the problem?”

    Now I’ve checked the db name in the php config against the db name in MySQL and they are correct so i can’t figure what the problem is. Any ideas?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Chris_K

    (@handysolo)

    does the user you specified in the wp-config.asp exist in the new database and have the appropriate permissions to your wordpress db in mysql?

    Looks like you haven’t connected the User to the db.
    If you use Cpanel, you need the ‘Really Important Bit’
    https://www.tamba2.org.uk/wordpress/cpanel/

    Thread Starter nemmesis

    (@nemmesis)

    Yep. I’ve checked and double checked that. it does exist and permissions are set to (All).

    Thread Starter nemmesis

    (@nemmesis)

    Thanks everyone. I’ve got it sorted. My new hosts system is very different to the one I’ve been using so the interface was confusing me. I missed a step.

    Thanks all for your patience.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘can connect to database server but not the database’ is closed to new replies.