Title: “Database Connection Error” upon install in Apache VirtualHost document root
Last modified: August 21, 2016

---

# “Database Connection Error” upon install in Apache VirtualHost document root

 *  Resolved [cjhockey35](https://wordpress.org/support/users/cjhockey35/)
 * (@cjhockey35)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/)
 * I have apache virtualhosts up and confirmed working. I want to install wordpress
   for one of the vhosts, so I unpacked all the wordpress files in the document 
   root for that vhost. I proceeded to follow the WordPress installation instructions.
   Now I am getting a database connection error upon going to to the install.php.
   I created the DB and WordPress user from phpMyAdmin.Here is my wp-config.php:
 *     ```
       <?php
           /**
            * The base configurations of the WordPress.
            *
            * This file has the following configurations: MySQL settings, Table Prefix,
            * Secret Keys, WordPress Language, and ABSPATH. You can find more information
            * by visiting {@link http://codex.wordpress.org/Editing_wp-config.php Editing
            * wp-config.php} Codex page. You can get the MySQL settings from your web host.
            *
            * This file is used by the wp-config.php creation script during the
            * installation. You don't have to use the web site, you can just copy this file
            * to "wp-config.php" and fill in the values.
            *
            * @package WordPress
            */
   
           // ** MySQL settings - You can get this info from your web host ** //
           /** The name of the database for WordPress */
           define('DB_NAME', 'notmyrealDBname');
   
           /** MySQL database username */
           define('DB_USER', 'l*******e');
   
           /** MySQL database password */
           define('DB_PASSWORD', '*********');
   
           /** 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_';
   
           /**
            * WordPress Localized Language, defaults to English.
            *
            * Change this to localize WordPress. A corresponding MO file for the chosen
            * language must be installed to wp-content/languages. For example, install
            * de_DE.mo to wp-content/languages and set WPLANG to 'de_DE' to enable German
            * language support.
            */
           define('WPLANG', '');
   
           /**
            * 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.
            */
           define('WP_DEBUG', false);
   
           /* That's all, stop editing! Happy blogging. */
   
           /** 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');
       ```
   
 * _[Moderator Note: Please post code & markup between backticks or use the code
   button. Your posted code may now have been permanently damaged by the forum’s
   parser.]_
 * So I am new to MySql but I did troubleshoot as much as I could. I used SET to
   make a new passwd for my WordPress DB user. Still no dice. I confirmed mysql 
   is running. I double checked passwords and spelling. I tried to login to mysql
   using the WordPress DB user, but I got:
 *  ERROR 1045 (28000): Access denied for user ‘l********e’@’localhost’ (using password:
   YES)
 * I think this may be because my WordPress DB user has no global privileges, but
   I honestly do not know since today is basically my first day using mysql ever.
 * The only thing I can think of is that ‘localhost’ isn’t the correct DB hostname
   due to apache vhosts, but everyone says it should still be. Oh and its worth 
   noting that in phpMyAdmin, my WordPress user’s “host” in user overview was ‘%’
   until I changed it to ‘localhost'(I tried setting the wp-config.php DB host to‘%’
   before changing.

Viewing 10 replies - 1 through 10 (of 10 total)

 *  Thread Starter [cjhockey35](https://wordpress.org/support/users/cjhockey35/)
 * (@cjhockey35)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620369)
 * Oh and one more thing, does the DB name have to have wordpress in it? Mine doesnt,
   I highly doubt this maters, just want to confirm.
 *  Thread Starter [cjhockey35](https://wordpress.org/support/users/cjhockey35/)
 * (@cjhockey35)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620370)
 * Tried opening up permissions in /var/www/* where all my sites are, didnt help.
   chown to www-data also nothing
 *  [davidpetersonharvey](https://wordpress.org/support/users/davidpetersonharvey/)
 * (@davidpetersonharvey)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620480)
 * Do you have root shell access? You can run mysql to check on the user settings
   and set them, just to make sure.
 * Digital Ocean has instructions for setting up on their VPS doing almost the entire
   installation from the command line for Ubuntu. Perhaps their instructions concerning
   mysql will help?
 * [https://www.digitalocean.com/community/articles/how-to-install-wordpress-on-ubuntu-12-04](https://www.digitalocean.com/community/articles/how-to-install-wordpress-on-ubuntu-12-04)
 *  [davidpetersonharvey](https://wordpress.org/support/users/davidpetersonharvey/)
 * (@davidpetersonharvey)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620481)
 * Oh, the name does not have to have “wordpress” in it. I will usually use some
   variation just so I can quickly identify it on the site when working from the
   command line or phpmyadmin.
 *  [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620488)
 * The main thing that I notice form your post is that you don’t mentoin granting
   privilidges for the user on your database. That’s an extra step that needs to
   be done. You did mention globl privilidges, and I’d stay away from those as much
   as possible as they can be nasty if something goes wrong.
 *  Thread Starter [cjhockey35](https://wordpress.org/support/users/cjhockey35/)
 * (@cjhockey35)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620492)
 * I forgot to mention, but I did grant the wp user all permission to the wordpress
   database. Had no global privileges (left them all unchecked which was default)
 *  Thread Starter [cjhockey35](https://wordpress.org/support/users/cjhockey35/)
 * (@cjhockey35)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620493)
 * I’m going try from a clean slate and he’s the digital ocean guide and all command
   line. Hopefully this works. I’ll update you
 *  [davidpetersonharvey](https://wordpress.org/support/users/davidpetersonharvey/)
 * (@davidpetersonharvey)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620508)
 * Hoping for the best. I usually use their guide. Not only am I using their service,
   but I also prefer to do most of my work from the command line when possible.
 *  Thread Starter [cjhockey35](https://wordpress.org/support/users/cjhockey35/)
 * (@cjhockey35)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620587)
 * That worked! shouldve done it like that in the first place. Thanks to all of 
   you
 *  [anuj kumar](https://wordpress.org/support/users/anuj0990/)
 * (@anuj0990)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620589)
 * please help to store all data in one directory like [http://www.99th.co.in/13/sitemap.xml](http://www.99th.co.in/13/sitemap.xml)
   [http://www.99th.co.in/14/sitemap.xml](http://www.99th.co.in/14/sitemap.xml) 
   [http://www.99th.co.in/15/sitemap.xml](http://www.99th.co.in/15/sitemap.xml) 
   i want to all pages to in [http://www.99th.co.in/13/sitemap.xml](http://www.99th.co.in/13/sitemap.xml)

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘“Database Connection Error” upon install in Apache VirtualHost document
root’ is closed to new replies.

## Tags

 * [apache](https://wordpress.org/support/topic-tag/apache/)
 * [connection error](https://wordpress.org/support/topic-tag/connection-error/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/)
 * 10 replies
 * 4 participants
 * Last reply from: [anuj kumar](https://wordpress.org/support/users/anuj0990/)
 * Last activity: [12 years, 2 months ago](https://wordpress.org/support/topic/database-connection-error-upon-install-in-apache-virtualhost-document-root/#post-4620589)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics