99.99% chance that you configure wordpress with wrong database details.
make sure you are using correct database details in wp-config.php file
/** The name of the database for WordPress */
define('DB_NAME', 'database_name_here');
/** MySQL database username */
define('DB_USER', 'username_here');
/** MySQL database password */
define('DB_PASSWORD', 'password_here');
/** MySQL hostname */
define('DB_HOST', 'localhost');
some possibilities are listed here based on my experience:
-
May be you didn’t use any prefix with database name or user name, which are added by default when we create them on online server.
-
May be using wrong server details. mostly we use localhost but sometimes
database server may be use from outside. -
May be user not assign to database.
Hope this helps you. All the best 😉
Related Posts:
- Moving minor updates between local and live sites – just database?
- Problem migrating to localhost
- How to transfer from localHost to live but use the already existing database on the server?
- Restoring .sql backup results in “Error establishing a database connection”
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Database synchronization between dev/staging and production
- Multiple developers / editors working on a site in progress
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- Fastest way (least amount of steps) to locally import a remote database using WP-CLI
- Solution for database version control and deployment?
- How to migrate a HTTPS WordPress installation to localhost?
- How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
- Ways of managing staging and production wordpress sites?
- Migrating data between local and development server
- Best way to import users, post and categories from an external database
- Syncing local content with development / staging sites
- Organizing WP Pages based on old website database
- Presentation vs Content in WP DB-Tables
- Connect to remote database using Localhost install
- Best way to move live site local
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- Migrate a Non WordPress database to wordpress [closed]
- Connect to live db whilst working locally
- What actions affect files, DB, or both?
- Weird issue with database migration and SSL links
- How to fix unchanged URLs in Database after running serialized search and replace script?
- Merging WordPress posts from different databases
- Migrating database / content of non-CMS site to WordPress
- How do I reset a self-hosted WordPress URL?
- I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
- Export all content from wordpress
- Import live site to local setup without access to live site
- Moving online website to MAMP or dumb idea?
- Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
- Connect to a remote database for wordpress in my own hosting server
- Difficulty importing my live site to local
- How to move the WordPress site Layout from test site to Production site?
- Merging two databases without borking it
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
- Trouble Migrating all data blog from WordPress.com to WordPress.org
- Copying database tables to new database
- Migrating from PDO using SQLite to clean new install using MySQL
- Migration: Copying database content to a different server
- Change WordPress URL in sql file via Terminal
- Changing between Local Host DB to Production DB and in reverse
- Strange characters added to the database
- After database migration, theme mods don’t show [closed]
- WordPress url transformation script
- Design problems when exporting remote database for local development
- Image link issues after importing a database backup to my local web server
- Installing local to live WP into subdirectory
- Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
- Cloning blog to localhost via WAMP
- echo site_url() returns a different value than what is in the database siteurl field
- Recovery – Restore Database after moving folder location locally
- Migrate Users From laravel to wordpress
- /wp-admin not accessible after migrating to local host (no plugin issue)
- How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
- How to fix Uploaded to this post option to see group of images uploaded to a post?
- How do you enable scripts on a WordPress installation in Softaculous?
- WordPress site migration – locked out of admin area
- Malware in old website – how to migrate?
- WP website showing blank page after moving from subdomain to main domain
- WordPress Migration – Issue with admin panel changes
- Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
- Search and Replace in Windows XAMPP site
- How to edit posts/pages without making the change live?
- Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
- After Migration From dev, Only my Links to the Homepage Still Redirect to dev
- Cloned site not connecting to database – MAMP
- Locally installing wordpress. Database problem
- I cannot change anything in my wordpress database from within wordpress?
- Local Content different from Remote Content
- Media library images “missing” after migrating them using SQL
- How can I work on a database along side a client?
- import (migration) user database to wp-users
- Database question while Migrating from one domain to another on same WebHost [Bluehost]
- Moving database from WP 2.6 to 3.5 problem
- Importing Concrete5 content to WordPress
- Theme Options – localhost to new url
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- Can I connect WordPress website with an external database?
- Transient RSS feeds in wp_options not removed automatically?
- Database location in WordPress
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- Change SQL get_results to search for posts with custom term in custom taxonomy
- Add search Value to wp_list_table pagination
- I want to run different WordPress websites under the same database
- I have a table I created, how do I make a form for a user to filter the data?
- Multiple wp_options tables to share content across installs
- Is there a smart way to obtain a list of only some selected user meta data?
- WordPress Database – wp_usermeta and the correct number of session_tokens rows
- How do I update a WordPress wp_postmeta meta_value that contains many options
- DB access blocked when initializing WP externally
- Site does not work right, pages not showing up, even for root admin
- WordPress: Interact with Database Query Data and Login
- Uploading to WordPress Database