Home/ Questions/Q 224
Answered
Fiwazo
  • 1
Pundit
Asked: 2022-01-19T11:37:56+05:30 In:

Error establishing a database connection

  • 1
Error establishing a database connection

Hi

I try to run WordPress on my MacBook and keep getting an error establishing a database connection. I try to write database name, username, password, and leave database host as localhost and leave table prefix as wp_ and seems can’t make a connection to the database. When I install mamp didn’t give me any error.

database issuewordpress
Share
Leave an answer

Leave an answer

Browse

2 Answers

  1. New Member

    This can happen when you’ve modified or entered your database details incorrectly, such as:

    • Your database host.
    • Database username.
    • Database password.

    Alternatively, your database could be unresponsive or corrupted.

    To fix this common WordPress issue, you should first see if you get the same error on your website’s front and back end (wp-admin).

    If you get a different error on the wp-admin page of your website, such as “One or more database tables are unavailable. The database may need to be repaired”, you need to repair your database.

    Repairing your database is pretty simple. FTP into your website and add the following line of code into your wp-config.php file just before the ‘That’s all, stop editing!’ line:

    define('WP_ALLOW_REPAIR', true);

    Now save the changes, re-upload the file to your server, and visit this page:

    http://www.yoursite.com/wp-admin/maint/repair.php

When you’ve finished repairing your database, remove the line from your wp-config.php file.
    • 1
  2. Best Answer
    New Member

    Ignore the mydbname, myusername and mypassword. I didn’t want to write my credentials. Just change your database and password or database user name.

    <?php
/**
 * The base configuration for WordPress
 *
 * The wp-config.php creation script uses this file during the
 * installation. You don't have to use the web site, you can
 * copy this file to "wp-config.php" and fill in the values.
 *
 * This file contains the following configurations:
 *
 * * MySQL settings
 * * Secret keys
 * * Database table prefix
 * * ABSPATH
 *
 * @link https://codex.wordpress.org/Editing_wp-config.php
 *
 * @package WordPress
 */

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define( 'DB_NAME', 'mydbname' );

/** MySQL database username */
define( 'DB_USER', 'myusername' );

/** MySQL database password */
define( 'DB_PASSWORD', 'mypassword' );

/** 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.wordpress.org/secret-key/1.1/salt/ WordPress.org 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_';

/**
 * 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.
 *
 * For information on other constants that can be used for debugging,
 * visit the Codex.
 *
 * @link https://codex.wordpress.org/Debugging_in_WordPress
 */
define( 'WP_DEBUG', false );

/* That's all, stop editing! Happy publishing. */

/** 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' );
    • 1