• Resolved veliapola

    (@veliapola)


    I have finally reached the wordpress screen wp-admin/install but am getting an error message that my database can’t be reached. I have double checked my user name, password, database name on my server end… also checked out the config.php file for errors… do I have to do something from the WordPress end of the database?

Viewing 12 replies - 1 through 12 (of 12 total)
  • Thread Starter veliapola

    (@veliapola)

    yahoo! Nevermind, after more fiddling, I’m in!!!

    So, please, veliapola, tell me what you did to conquer the error message. I’m getting the same thing.
    Thanks —
    Ruth Ann

    Which error message are you getting? – because there is more than one. (Just to make it clear: people seldom have “the same” issue…)

    Thread Starter veliapola

    (@veliapola)

    Ruthannf: I had mistakenly changed the text at the END of each line in the config.php file… you need to change the text INSIDE the quotes (more in the middle of each line of text, look there, you’ll see it). Sorry I can’t remember where I saw the example that clued me in. I am so not a techie but it’s coming together for me.

    Hi, sorry I wasn’t more explicit. And, it seems that my error, while reading the same, did not have the same fix. Here’s where I stand: I have edited the wp-config file; user is X and password is XX. I have edited the MySql database and user is X and password is XX. My cPanel is v. 10, and MySQL is 4.1.21 “standard”. So the login and password are the same in both MySQL in cPanel and wp-admin.

    When I try to go to my blogpage I get the following error:

    ~~~~~
    Error establishing a database connection
    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. This could mean your host’s database server is down.

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?
    If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.
    ~~~~~

    And this is either by directly addressing it, or by using the “View Site” link in the wp-admin program.

    I certainly would appreciate any help you can offer. I like the blogging and find WordPress pretty nice (except I have done something wrong and can’t troubleshoot it myself).

    And I’m sorry, I really don’t want to have someone build it for me, as I want to have the knowledge, so I can put one up for my family, etc. So I don’t want to have one of your people build the blog for me. This seems so straightforward, I know it’s something really dumb.

    Thanks —

    Ruth Ann

    Sometimes depending on host your username and database name will have your “user” with the host setup appended to the database info, like so: user_databaseusername, user_databasename….

    Don’t worry, we don’t want to build your blog ??
    However, if cPanel – read this:
    https://www.tamba2.org.uk/wordpress/cpanel/
    and pay special attention to The Really Important Bit – that’s what is missed by most users…

    Wow. That tutorial is really great.

    However, before and after reading this tutorial, my database name, user name and password for cPanel/MySQL database and wp-config were and are the same. Both have db name insteorg_wordpress and user name insteorg_admin. In fact, the passwords also match.

    ???????????????????????????

    ;-<

    Ruth Ann

    Wrong wording and you mislead people… ??

    The username/pw combo for cPanel cannot be “the same” as for the database.
    On my site if I have the login for cPanel “moshu” – the user for the database will be “moshu_whatever”. And the DB name will be “moshu_firstdatabase”. [all fictional examples]

    and the password for getting into my cPanel is absolutely NOT the same as the password for the DB.

    And for all my WP installs I have user “admin” as everybody” and a totally different pw for each.

    You need to use in the wp-config.php file the DB-username and DB-name that you see in the cPanel + the pw you selected when creating the DB.

    And you still did not report back whether you performed the action described in the REally Importan Bit = add user to database!

    Hi moshu —

    I thought that saying that the video was a good one meant that I had gone through it.

    My MySQL looks a little different (because I’ve gone through the installation process already?) and has the two strings of text for Perl and PHP:

    ~~~~~~
    MySQL Account Maintenance

    ——————————————————————————–

    Current Databases:
    insteorg_wordpress
    Users in wordpress
    insteorg_admin (Privileges: ALL PRIVILEGES)

    Connection Strings
    Perl $dbh = DBI->connect(“DBI:mysql:insteorg_wordpress:localhost”,”insteorg_admin”,”<PASSWORD HERE>”);
    PHP $dbh=mysql_connect (“localhost”, “insteorg_admin”, “<PASSWORD HERE>”) or die (‘I cannot connect to the database because: ‘ . mysql_error());
    mysql_select_db (“insteorg_wordpress”);

    New Database:

    ——————————————————————————–

    Current Users:
    insteorg_admin
    ~~~~~

    And it does show “local host”, so that’s right.

    So, if it tells me this much:

    ~~~~~
    Current Databases:
    insteorg_wordpress
    Users in wordpress
    insteorg_admin (Privileges: ALL PRIVILEGES)
    ~~~~~

    And I have the following in my wp-config file:

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

    I THINK I’ve done everything in the video. Including the Important part. But I still get the same error when I try to run mysite.org/wp-admin.

    Thanks for helping — I greatly appreciate it.

    Ruth Ann
    P.S.
    I’ll be in a long meeting for about the next 4-5 hours. I’ll be able to recheck this following that.

    Based on what you posted above – if you get the quoted error, the only thing to check should be the password!
    The password is the one assigned to the DB user by you (or whoever created the user).
    What I’d try in a case like this:
    1. Create a new DB user with the password (write it down)
    2. Add the new user to the DB
    3. Put the new user/pw in the config file
    4. Give it another try for install

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Can’t run install script’ is closed to new replies.