Trouble with Database

  • I had my webhost make a MySQL database for me(as then, I hadn’t the access to make my own), and she gave a username/password for accessing the phpMyAdmin interface.

    So basically, I used the name of the database, the username/pawword for the phpMyAdmin login, and localhost as the info I was to put in the wp-config.php file.

    So I uploaded everything to the correct address, and I went to open the install.php file in my browser, and it just shows me the “Error establishing a database connection” page.

    I’m getting unsure that the login info for the phpMyAdmin is what I should use in the wp-config file.

    Also, the MySQL database I have up right now has no tables in it. Do I need any? The instructions really don’t go into any detail about it.

    My host is using phpMyAdmin 2.5.1, MySQL 3.23.56, and I chose 2.0.9 because it was the newest compatible release I could find.

    Can anyone offer some pointers as to what I’m doing wrong?
    It would be greatly appreciated.

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

  • One (or more) of those four values in wp-config.php is probably wrong, or the database server itself is down.

    Since you used the username/password to access the database via phpMyAdmin then it would seem either the DB_NAME or DB_HOST is wrong–both those should be visible in phpMyAdmin.

    Also 2.0.10 is the latest release that will run under MySQl 3.23.56. It (2.0.10) is on the archive page, just not where you will expect it ??

    * nevermind, michaelH beat me to it *

    Thread Starter lockedge

    (@lockedge)

    Well, my DB_HOST value is ‘localhost’ , which is correct. I know that. My database’s name should be correct as well.

    Like, I clicked on the “databases” link on the panel and it shows the one(and only) database there, called blog_db. So that’s what I used. And it’s ok for the database to have no tables in it before installation?

    I wouldn’t think the server itself would be down. That wouldn’t make much sense, but then again it wouldn’t surprise me since I had to pry what I have now from their teeth.

    Check your wp-config.php file for spurious spaces inside the ‘ marks around each of your definitions.

    ‘ username’ is wrong
    ‘username’ is correct

    I’ve seen one host that used the FTP user and password to access the database via phpMyAdmin but when using a package such as WordPress the username and password are something altogether different…just something else to consider (confuse).

    also some hosts have 1 password for getting into phpMyAdmin, and then a separate user/password for each database with it.

    Like,
    Login = Admin
    password = Admin

    Database1
    Login = DatabaseUser1
    PW = DatabasePW1

    If you use cPanel from your host, there’s a page that lists all your databases, and who the Users are for each DB. Some hosts like my new host, have 1 “User” who is the Admin, but each db they make has a different “User” in charge of it. If so, you can add access for the Admin User to each of your db’s, then you could use that login/password.

    Thread Starter lockedge

    (@lockedge)

    I triple checked my wp-config file and all the ‘ are placed correctly.
    Now I checked out the Process listing for my database, and there’s only a Kill procedure going on.
    Does that mean in order for me to use this database, I need to make a new process that states a user name and whatnot?

    You might want to discuss that with your webhostess and maybe have her reboot that server.

    Thread Starter lockedge

    (@lockedge)

    Will do. Just to make sure, this info is correct, right?

    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘klomp_db’); // The name of the database
    define(‘DB_USER’, ‘rxrxr’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘rxrxrxrx’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

    Thanks for your help so far, it’s greatly appreciated!

    Only you (or you host) can really answer yes to that question.

    But the structure of that file looks okay.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Trouble with Database’ is closed to new replies.