Database error
-
Hi,
I can connect to my database using PHPMyAdmin, I can see all the tables and eveything work fine.
But I’ve got this message “Error establishing a database connection” when I’m trying to connect to this my website: https://paullehmanndesign.com/
I’ve checked many times my wp-config.php file and the username, Database name and hostname are correct.
The same problem occur with https://paullehmanndesign.com/wp-admin/
I’ve checked my MySQL Server using this code:
<?php
$link = mysql_connect(‘localhost’, ‘root’, ‘password’);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}
echo ‘Connected successfully’;
mysql_close($link);
?>and it works.
So I really don’t know what to do to fix the issue.
Thank you for your help
The page I need help with: [log in to see the link]
-
Please find below the lines of my wp-config.php file:
<?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(‘WP_CACHE’, true); //Added by WP-Cache Manager
define( ‘WPCACHEHOME’, ‘/home/paullehmqt/www/wp-content/plugins/wp-super-cache/’ ); //Added by WP-Cache Manager
define(‘DB_NAME’, ‘xxxxx’);/** MySQL database username */
define(‘DB_USER’, ‘xxxx’);/** MySQL database password */
define(‘DB_PASSWORD’, ‘xxxxxxxxx’);/** MySQL hostname */
define(‘DB_HOST’, ‘xxxxx.mysql.db’);/** 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’, ”);[redacted]
Thanks,
I’ve changed the name of my .htaccess file to .htaccess.bak
but it still doesn’t work
Any idea what else could it be please ?
<?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('WP_CACHE', true); //Added by WP-Cache Manager define( 'WPCACHEHOME', '/home/paullehmqt/www/wp-content/plugins/wp-super-cache/' ); //Added by WP-Cache Manager define('DB_NAME', 'xxx'); /** MySQL database username */ define('DB_USER', 'xxx'); /** MySQL database password */ define('DB_PASSWORD', ‘XXXXX’); /** MySQL hostname */ define('DB_HOST', ‘mysql55-264.perso’); /** 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', ''); [redacted]If you *only* edited wp-config.php, then the error is there. Look closely at the line you edited and the lines right above and below it.
Looking at lines like
define('DB_PASSWORD', ‘XXXXX’);, it seems to me that the first string is delimited by a'as is proper, but the second is delimited by’which seems to be a different character.
The topic ‘Database error’ is closed to new replies.