New theme…WSoD…Can’t select database…WTF

  • Resolved joblake326

    (@joblake326)


    8 years, 1 month ago

    I have a WP site that has been working fine for years. The other day, I installed a new theme that caused the white screen of death. I did all the stuff that’s recommended: disable plugins and got rid of the bad theme. Still couldn’t get into site–no way, no how. Eventually, after mucking around for a day, I was successful at getting rid of the white screen. Now I have the “Can’t select database…” message. I’ve looked at the wp-config.php file and it says:

    // ** MySQL settings – You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define(‘DB_NAME’, ‘blog’);

    /** MySQL database username */
    define(‘DB_USER’, ‘xxx’);

    /** MySQL database password */
    define(‘DB_PASSWORD’, ‘xxx$’);

    /** MySQL hostname */
    define(‘DB_HOST’, ‘mysql’);

    “blog” is correct but I have no clue what that is to the right of ‘DB USER’ nor ‘DB PASSWORD”. Are they encrypted versions of username/password?

    I’m sure this is an easy fix but after 2 days, I’m really, really tired.
    Help.
    Anyone…anyone?
    Bueller?

    [moderator note: ID and password redacted]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Those are the userid and password for your database.

    Note: I edited them to remove them from your post. Please change them ASAP as they were public for a while.

    You can change the ID/password from your host’s control panel. Please contact your host if you need instructions. Also ask them if “mysql” is the proper host name.

    Thread Starter joblake326

    (@joblake326)

    Thanks Steve.
    I understand that those 2 strings are being used to fill the variables DB PASSWORD and DB_USER but neither of them are recognizable. They are so randomized that I think that they are an encryption of the real things, and that’s why I didn’t have a problem posting them.
    I’m pretty sure that mysql is the host name since the message says that I am connecting to the database server and that username and password are good.
    So with all that said, any thoughts?
    Thanks,
    John

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    No, the id and passwords in wp-config.php are plain text, not encrypted.

    You say “Can’t select database…” ” Where are you seeing that?

    Thread Starter joblake326

    (@joblake326)

    This is the entire 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 blog database.

    Are you sure it exists?
    Does the user yscr_bbGgog have permission to use the blog database?
    On some systems the name of your database is prefixed with your username, so it would be like username_blog. Could that be the problem?

    I have never seen that user name

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    It’s telling you that the database name is incorrect. Check the database name using phpmyadmin or from your hosting control panel.

    Thread Starter joblake326

    (@joblake326)

    so you’re saying that “blog” is not the name of my database?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    I think that’s what WordPress is saying.

    Check the database name using phpmyadmin or from your hosting control panel.

    Thread Starter joblake326

    (@joblake326)

    Hi Steve,
    I’m getting nowhere in a hurry. Let me ask you this:
    If I do a fresh install of WP in an empty directory, can I then replace that newly created database with a backup db from my dead site?

    Or am I talking crazy?
    -John

    Thread Starter joblake326

    (@joblake326)

    I got it fixed. Thanks!
    : )

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘New theme…WSoD…Can’t select database…WTF’ is closed to new replies.