asked on

Connect MySql database to wordpress site

I'm trying to move my WordPress site to a different server. I am moving it from a windows server 2008 iis 7.5 to a windows server 2012 iis 8.5. I've already installed WordPress and that worked fine. I am at the point where I have moved the MySQL database. I exported the database with phpMyMadmin and Backwpup from the old server. I imported the database fine. It shows up in mysql workbench but I don't know how to connect it to my instance of wordpress.

I edited these lines of my wp-config.php
define('DB_NAME', 'wordpress939');

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

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

/** MySQL hostname */
define('DB_HOST', 'localhost');

But when I go to the site I get:
Error connecting to database

When I go the admin panel I get a error:
Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?

If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

I don't know what to do to get it to work.

SOLUTION

David Sankovsky

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cdlciddit

ASKER

Hello @ David Sankovsky. Thank your for the response. I am still getting the same error. I did what you said. I changed the wp-config.php file in the root directory of the site. I changed it to match the credentials you sent. Here is what my wp-config.php file looks like now.

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

/** MySQL database username */
define('DB_USER', 'wordpressuser263@localhost');

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

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

define('WP_ALLOW_REPAIR', true);

ASKER CERTIFIED SOLUTION

Tomas Helgi Johannsson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial