Support » Installing WordPress » Error establishing a database connection

  • hello every 1
    i always got this erorr msg

    “This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost.

    Are you sure you have the ?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running? “

    I’m sur that i have the correct username and password and typed the correct hostname and the datebase is running 😀
    so where is the proplem
    i laso sometimes can’t get step 2

    I tryed to use word press in local host and it’s worked well
    but when i tryed it in my site i can’t :S so are the proplem from the cpanel ?

Viewing 15 replies - 1 through 15 (of 36 total)
  • I just had the same problem on my home machine.

    I doubt my problem was the same as yours — it turned out that my version of PHP (4.x) didn’t get along with my new version of MySQL. I upgraded to PHP5, and it worked.

    I was able to diagnose my problem by writing a really simple PHP script that tried to connect to the database, and looking at the specific error.

    (If the developers read this, I’d suggest including the specfic error message on the “can’t connect” page. The argument against it is probably that it would just confuse people. But if you see that page, you’re going to be confused anyway.)

    Anyway, I used this to get a more specific error message — replace the connection parameters with what you’re using on your server, put this in a file called something.php, and pull it up in your browser.

    <html>
    <head><title>test</title></head>
    <body>

    <?php

    $link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
    or die('Could not connect: ' . mysql_error());

    ?>

    </body>
    </html>

    Thank you – this helped me track down my problem – which was to enter at the mysql prompt

    >SET PASSWORD FOR ‘user’@’some_host’ = OLD_PASSWORD(‘mypass’);

    This seems to be a very common problem.

    I’m getting the same error message, attempting to access my site to run the installer script. I ran the php script above (thanks!), and this is what it reports.

    Could not connect: Unknown MySQL server host ‘mysql_host’ (3).

    I’m using TextDrive, is this something I need to contact them about, or have I not set my wp-config.php file properly?

    see post:

    http://wordpress.org/support/topic.php?id=26796

    I’m set up, and thanks for all the really rapid help, this forum rocks.

    Hello there,
    This is my first post and I’m a complete newbie to this. I am having the same problem and was wondering if someone could expound on DaveMH’s post above, about entering

    >SET PASSWORD FOR ‘user’@’some_host’ = OLD_PASSWORD(‘mypass’);

    at the “msql prompt”. Is that within the wp-config.php file…or where? Thanks in advance for any help!

    No, no. Don’t put anything like that into config file!
    What is exctly your problem?

    I won’t. It’s when I bring up the installation page in my browser, I get the error message that it can’t connect to the database with localhost. I can log in to phpMyAdmin through my Network Solutions account, using the same username and password that I have in the config file. Thanks for your quick reply!

    Those (username and pw) are not necessarily the same! For phpMyadmin usually you use the same as for your site administration. The username and pw for the database itself might be different. Was the database created by you or by your host? (I am not familiar with NS, my host offers CPanel to access my site admin.) If it was created by your host, they should provide you with the necessary info you have to put in the config file.

    I just created it today through thier “database manager”. I did get on the phone with NS tech support, and I do have the right username and password. What I am wondering is about the part where it asks, “are you sure the database server is running”. When I log into phpMyadmin, in the process list it has my ID, user and host, but under database it says “none”. Could that mean something?

    OK, then create a database named whatever you want, and if it’s done, put its name in the config file.

    That is what I did, but I am hung up on step 5. I get the error message at the beginning of this thread when I go to http://www.mysite.com/wp-admin/install.php

    In the phpMyadmin on left menubar in the dropdown menu can you see the name of the database you’ve created?

    Yes

    SO, in your config.php file (which you renamed from config-sample!!!) you have something like this?

    <?php
    // ** MySQL settings ** //
    define('DB_NAME', 'name_you-see_in_phpmyadmin'); // The name of the database
    define('DB_USER', 'your_usernam'); // Your MySQL username
    define('DB_PASSWORD', 'your_pw'); // ...and password
    define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

    If everything is correct, then you probably are in the remaining 1% 🙂 Ask your host.

    Alas, I did and it is indeed ‘localhost’. 🙂 And the rest of the stuff is all correct. I have no clue what is up. I will cruise around support some more and see if I find anything. One thing is, when I created the database earlier, I made the name of the database and my mySQL user name the same. Would that throw something off? Pardon my ignorance on all this… I really appriciate your time and don’t mean to get tedious!!!

Viewing 15 replies - 1 through 15 (of 36 total)
  • The topic ‘Error establishing a database connection’ is closed to new replies.