Viewing Thread:
"Error establishing a database connection"

I've set up a MYSQL database as i eventually want to change my domain to a wordpress site. I want to try the wordpress site in a sub-directory, i.e. www.domain.com/blog. Im getting an error 'Error establishing a database connection' after i uploaded the wordpress folder and contents and went to www.domain.com/blog/wp-admin/login.php. I checked the wp-config file and it seems to be setup correctly, but perhaps i've done it wrong, is it different when on Freeola? I tried localhost and mysql.freeola.net, neither works. Whats gone wrong?

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

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

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

/** MySQL hostname */
define('DB_HOST', 'mysql.freeola.net');

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

I've experienced exactly the same issues over a frustrating half a day trying various things including reading this forum.

I finally resolved the ERROR message and failure to install Wordpress issues by going back to the Freeola "How To" and foliowing it EXACTLY as written rather than trying to install it by change the wp-configure-sample in a text editor route.

I think that method really is for those who actually understand PHP.

It still doesn't work. Its set to localhost, i used a newly downloaded wordpress file/folder, re-uploaded. Still the same problem. What else could it be?

Your database username shows you are using our VIP hosting. On this service the MySQL is local to the server so change the hostname from mysql.freeola.net to localhost or 127.0.0.1 and it should then be fine. mysql.freeola.net is our standalone MySQL service mainly used by customers on our free hosting.

Hi and welcome to the forums!

I've just had a quick look while I'm having a quick cuppa/rest from other things :¬)

My config file shows:

/** MySQL hostname */
define('DB_HOST', 'mysql.freeola.net');

I've just updated to 3.9.1. from 3.5.2 - and edited a page and everything seems to be fine.

I would re-check things or start again from scratch which can work better if you can't see the error.

When I installed WordPress the first time I followed Freeola's installation guide. This worked flawlessly for me and was my first MySQL project.

NB. I'm using standard Hosting/MySQL.

[s]Hmmm...[/s]

I've set up a MYSQL database as i eventually want to change my domain to a wordpress site. I want to try the wordpress site in a sub-directory, i.e. www.domain.com/blog. Im getting an error 'Error establishing a database connection' after i uploaded the wordpress folder and contents and went to www.domain.com/blog/wp-admin/login.php. I checked the wp-config file and it seems to be setup correctly, but perhaps i've done it wrong, is it different when on Freeola? I tried localhost and mysql.freeola.net, neither works. Whats gone wrong?

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

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

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

/** MySQL hostname */
define('DB_HOST', 'mysql.freeola.net');

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