• Resolved akhilp

    (@akhilp)


    I have uploaded wp. And filled wp-config.php. But when I enter https://dailytricks.co.cc/wp-admin/install.php , a message “Error establishing a database connection” displays. Database name,username and password….all are correct. I suspect “DB_CHARSET, DB_HOST, DB_COLLATE ” as the culprits. I use hostbot.com as my webhost.

    Please help me.

Viewing 10 replies - 1 through 10 (of 10 total)
  • MichaelH

    (@michaelh)

    The DB_CHARSET and DB_COLLATE will not cause that problem.

    Likely it is the DB_HOST, DB_USER, DB_PASSWORD or DB_NAME. If you don’t know the DB_HOST check with your hosting company.

    Thread Starter akhilp

    (@akhilp)

    Hello, Please tell me about other possible reasons for this problems. I will also contact my webhost.

    But….
    I have another site hosted on the same webhost, for which on clicking subdirectories will give 404-not found page.
    eg: vidblades.co.cc/join

    For that, DB_Host is ‘localhost’.

    MichaelH

    (@michaelh)

    Well then ‘localhost’ seems to be the correct value for DB_HOST. I would make sure your DB_NAME, DB_USER, and DB_PASSWORD, are correct, and that the DB_USER has full privileges for that database (DB_NAME).

    Of course the database server could be down…but most times it is something incorrectly specified in wp-config.php or the database user doesn’t have the proper rights.

    Thread Starter akhilp

    (@akhilp)

    I deleted the first DB and DB user that I have created and the created another DB and DB user. But the problem is still there…

    Samuel B

    (@samboll)

    are you using 000webhost?
    if so, the db host is NOT localhost

    Thread Starter akhilp

    (@akhilp)

    I am using “hostbot” as my webhost.

    MichaelH

    (@michaelh)

    1. Create your database.

    2. Create your user.

    3. Assign privileges for your user to that database.

    Assuming your login name with hostbot is akhilp and you want a database called wpdb, your DB_NAME will be akhilp_wpdb. If you create a user call wpuser, then your DB_USER will be akhilp_wpuser.

    Thread Starter akhilp

    (@akhilp)

    Yes i understand. I know that. I am sure that what I entered are correct.

    MichaelH

    (@michaelh)

    Okay, I created a hostbot account. My login is forummike.

    Created a database, created a database user, assigned all privileges to that database for that user.

    Setup wp-config.php as:

    define('DB_NAME', 'forummike_wpdb');
    define('DB_USER', 'forummike_wpdbuser');
    define('DB_PASSWORD', 'xxxx');
    define('DB_HOST', 'localhost');

    Successfully installed WordPress 2.6.3.

    MichaelH

    (@michaelh)

    Just as a note, I also upgraded that installation to the WordPress 2.7 beta manually following the directions at Upgrading WordPress Extended.

    But, the auto upgrade feature in 2.7 DOES NOT work on this host, even if you provide the FTP information. Also 2.7 plugin installation process doesn’t work so plugins need to be installed the old way.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Error connecting database’ is closed to new replies.