The Usual Error – Please Help Me!

  • I know several others have posted about this same problem, but I’m having a hard time following the answers because I am so new at this. I’m a MT refugee…have pity on me.
    Ok, so it looks to me like everything in my config file is perfect, but it’s still not working! Arrrgh! I get the “Error establishing a database connection!” thing –
    Here’s what I have:
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘arrrrgh’); // The name of the database
    define(‘DB_USER’, ‘arrrrgh’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘passwordishere’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
    // Change the prefix if you want to have multiple blogs in a single database.
    $table_prefix = ‘wp1’; // example: ‘wp_’ or ‘b2’ or ‘mylogin_’
    I was hoping to do two wp blogs so that’s why I changed the table prefix. Localhost is correct, and I went into cpanel to ensure that the username and database were hooked up. Then I got this:
    Users in wp
    bruce (Privileges: ALL PRIVILEGES)
    Connection Strings
    Perl $dbh = DBI->connect(“DBI:mysql:wp:localhost”,”bruce”,”<PASSWORD HERE>”);
    PHP $dbh=mysql_connect (“localhost”, “bruce”, “<PASSWORD HERE>”) or die (‘I cannot connect to the database because: ‘ . mysql_error());
    mysql_select_db (“wp”);

    Pardon me, but wtf is this? I don’t know if that’s a good thing or a bad thing.
    Five-minute installation? Try five hours! Ugh…help! What am I missing?

Viewing 6 replies - 1 through 6 (of 6 total)

  • try clicking the “Add user to the database” button in the mysql interface if you haven’t done so. then try again. worked for me

    Thread Starter Anonymous

    Yeah I tried that already; the user has all privileges, and it’s still not working. Thanks anyway, though.

    I am still having the same proble. If you find an answer please let me know.

    Thread Starter Anonymous

    Still have not solved the mystery. Tonight I noticed, however, that my control panel gives me a “connection string” for PHP.
    $dbh=mysql_connect (“localhost”, “user_user”, “<PASSWORD HERE>”) or die (‘I cannot connect to the database because: ‘ . mysql_error());
    mysql_select_db (“user_wp”);
    Is there somewhere I can put this in the wp-config so that it can connect to the database (right now it is not)? Would that help?

    Thread Starter Anonymous

    Ok, I have solved the problem a stupid way, but it worked…
    My host has a fantastico autoinstaller, so I used that to get an old version installed, then I sent over the new 1.2 files (careful to save wp-config.php that the autoinstaller created), then ran upgrade.php.
    Five weeks (not minutes) later, it works! Whoopee!

    Twinmama, can you see what the wp-config.php says now, and share it? What made it work now?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘The Usual Error – Please Help Me!’ is closed to new replies.