• Hi all

    I have just installed WAMP as I wish to edit some of my WordPress sites in Dreamweaver CS6, but I keep getting the same error “Error establishing a database connection”
    I have followed several tutorials on setting up and installing WAMP and I’m sure its correctly installed.
    I have also checked and double checked the wp-config.php:
    This is my wp-config.php

    <?php
    /**
    * The base configurations of the WordPress.
    *
    * This file has the following configurations: MySQL settings, Table Prefix,
    * Secret Keys, WordPress Language, and ABSPATH. You can find more information
    * by visiting {@link https://codex.www.ads-software.com/Editing_wp-config.php Editing
    * wp-config.php} Codex page. You can get the MySQL settings from your web host.
    *
    * This file is used by the wp-config.php creation script during the
    * installation. You don’t have to use the web site, you can just copy this file
    * to “wp-config.php” and fill in the values.
    *
    * @package WordPress
    */

    // ** MySQL settings – You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define(‘DB_NAME’, ‘test’);

    /** MySQL database username */
    define(‘DB_USER’, ‘root’);

    /** MySQL database password */
    define(‘DB_PASSWORD’, ‘admin’);

    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);

    /** Database Charset to use in creating database tables. */
    define(‘DB_CHARSET’, ‘utf8’);

    /** The Database Collate type. Don’t change this if in doubt. */
    define(‘DB_COLLATE’, ”);

    /**#@+
    * Authentication Unique Keys and Salts.
    *
    * Change these to different unique phrases!
    * You can generate these using the {@link https://api.www.ads-software.com/secret-key/1.1/salt/ www.ads-software.com secret-key service}
    * You can change these at any point in time to invalidate all existing cookies. This will force all users to have to log in again.
    *
    * @since 2.6.0
    */
    define(‘AUTH_KEY’, ‘put your unique phrase here’);
    define(‘SECURE_AUTH_KEY’, ‘put your unique phrase here’);
    define(‘LOGGED_IN_KEY’, ‘put your unique phrase here’);
    define(‘NONCE_KEY’, ‘put your unique phrase here’);
    define(‘AUTH_SALT’, ‘put your unique phrase here’);
    define(‘SECURE_AUTH_SALT’, ‘put your unique phrase here’);
    define(‘LOGGED_IN_SALT’, ‘put your unique phrase here’);
    define(‘NONCE_SALT’, ‘put your unique phrase here’);

    /**#@-*/

    /**
    * WordPress Database Table prefix.
    *
    * You can have multiple installations in one database if you give each a unique
    * prefix. Only numbers, letters, and underscores please!
    */
    $table_prefix = ‘wp_’;

    /**
    * WordPress Localized Language, defaults to English.
    *
    * Change this to localize WordPress. A corresponding MO file for the chosen
    * language must be installed to wp-content/languages. For example, install
    * de_DE.mo to wp-content/languages and set WPLANG to ‘de_DE’ to enable German
    * language support.
    */
    define(‘WPLANG’, ”);

    /**
    * For developers: WordPress debugging mode.
    *
    * Change this to true to enable the display of notices during development.
    * It is strongly recommended that plugin and theme developers use WP_DEBUG
    * in their development environments.
    */
    define(‘WP_DEBUG’, false);

    /* That’s all, stop editing! Happy blogging. */

    /** Absolute path to the WordPress directory. */
    if ( !defined(‘ABSPATH’) )
    define(‘ABSPATH’, dirname(__FILE__) . ‘/’);

    /** Sets up WordPress vars and included files. */
    require_once(ABSPATH . ‘wp-settings.php’);

    I have also tried using a different MySQL host name, instead of
    ‘localhost’ I have tried 127.0.0.1.
    This still didn’t work.
    I’m also sure that the WAMP SERVER is running

    SO WHAT AM I DOING WRONG?

Viewing 2 replies - 1 through 2 (of 2 total)
  • OK – looks like your Apache server is pointing to your WordPress folder OK otherwise you wouldn’t get that message.

    That means your php.ini and apache configs are correct.

    This means that the problem is either a wp-config.php or a MySQL one.

    Your wp-config.php seems OK as the DBNAME/USER/PASS/HOST all seem defined.

    So, I would think that the problem lies with the MySQL DB.

    I know it sounds daft, but just check on the DBNAME/USER/PASS and make sure you have them 100%.

    Also – make sure that your user root has been given FULL privileges to access the MySQL DB in whatever tool you use (phpmyadmin etc)

    If I were to place a bet, I would guess this is what you forgot to do.

    As per the message, “Error establishing a database connection”, usually means one of two things:
    1. Database server is down (not operating)
    2. You have wrong information in your wp-config.php–either the DB_HOST, DB_USER, DB_PASSWORD, or DB_NAME is incorrect.

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