How to Resolve “Error Establishing a Database Connection” on WordPress XAMPP Localhost for Google App Engine

2 Views

Following Google App Engine’s instructions for creating a local WordPress development platform, I created the database and initial user using the instruction’s MySQL direction: 

CREATE DATABASE IF NOT EXISTS wordpress_db;
CREATE USER 'wp_user'@'localhost' IDENTIFIED BY 'wp_password';
GRANT ALL PRIVILEGES ON wordpress_db.* TO 'wp_user'@'localhost';

After running it without errors reported, MySQL subsequently reported back:

Read More
CREATE DATABASE IF NOT EXISTS wordpress_db;# 1 row affected.

CREATE USER 'wp_user'@'localhost' IDENTIFIED BY 'wp_password';# MySQL returned an empty result set (i.e. zero rows).

GRANT ALL PRIVILEGES ON wordpress_db.* TO 'wp_user'@'localhost';# MySQL returned an empty result set (i.e. zero rows).

While the command line runs dev_appserver.py, I try reaching the WordPress app and get instead:

Error establishing a database connection

I’ve removed and recreated the database (wordpress_db) and user (wp_user) without reaching the WP app.

Any suggestion how to resolve this is appreciated.

Thanks, this is my App Engine log:

2013-11-26 17:40:25 Running command: “[‘C:Program FilesPython27python.exe’, u’C:Program FilesGooglegoogle_appenginedev_appserver.py’, ‘–skip_sdk_update_check=yes’, ‘–port=8080’, ‘–admin_port=8000′, u’C:Documents and SettingsUserMy DocumentsCatalyxCatalyx-GoogleAppEngineCatalyx’]”
2013-11-26 17:40:26 (Process exited with code -1073741515)

Post Views: 2

Related posts

Leave a Reply

3 comments

  1. As you have mentioned you are following googles own instructions…

    then in the section titled …
    Step 4. Create your wp-config.php configuration file

    where the instructions state that you should replace the existing lines with the following:

    /** The name of the database for WordPress */
define('DB_NAME', '**wordpress_db**');

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

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

    You should enter those lines without the ** either side of the words like so…

    /** The name of the database for WordPress */
define('DB_NAME', 'wordpress_db');

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

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

    When you hit the default root url for your local app – normally localhost:8080 you may get some odd redirects, so instead go direct to the local WordPress install url…

    http://localhost:8082/wp-admin/install.php

    You should then get the nice WordPress install page that you were expecting

  2. This happens to me and I have a very ‘good’ evening with it. So hopefully someone can found this problem earlier…

    I am trying to replicate the server wordpress on localhost. After replacing the actual URL with localhost, thing works perfectly. Except one thing, the newly created page is always in “Error Establishing a Database Connection”.

    Let me put in sequence why this problem happened.

    1. on local pc I already have an old wordpress directory wp/
    2. on server my wordpress was placed under wp/
    3. when i copy the package to my local pc, i placed it to wp2/ (remember wp/ already taken?)

    So who’s the culprit? it’s the .htaccess 

    RewriteBase /wp/

    So it pointing to another database used by wp, which is of course resulting in error!
    The fix is easy, just change it to wp2!

    RewriteBase /wp2/

    Voila! Cheers and the evening suddenly become beautiful again! 🙂

  3. To fix this problem try those fixes :

    1. Open wp-config.php, check line DB_USER, DB_PASSWORD, DB_HOST, DB_NAME. Make sure the values is same with mysql access.

    2. If you use Dedicated server or VPS hosting, try to restart your mysql server by typing :
      -service mysql restart
      or
      -service mysql start
      but if you use shared hosting, ignore this step!

    3. if all the previous fixes can not fix it, so it’s a server-side problem! it is not your error! so let the hosting company fix this error for you because it is their error!
      contact them or give them a day or so and they will solve this error and the problem will disappear automatically.
      you can also check this video for the error establishing database connection fixes