How to edit wp-config file in WordPress?

0
590
How to Edit wp-config.php File in WordPress
edit wp-config.php file for database details in wordpress

Hi, Welcome to the tutorial. Lets checkout how to edit wp-config file in wordpress to change or update your database details

Pre-requsite

1- cPanel Access, this is your webhosting dashboard where your website files are hosted.

2- Make a backup of your file

3- Basic knowlege of php or any other programming language to help you understand what needs changing and how ? If you are not an expert dont worry, below is a video tutorial to help guide non technical audiences.

Video Tutorial

 

What are the common use cases for editing this file

1- updating your database and user details

2- wordpress error establishing database connection

Example

Below, I have shared a screenshot sample of wp-config.php file, that will help you understand what is inside this file or what the contents of this file looks like ?

wp-login file
wp-config.php file
How to edit WordPress wp-config.php file in cPanel
How to edit WordPress wp-config.php file in cPanel

Editing wp-config

Lets, get to the business and start editting our file. At this point, I assume you have your file opened in the editor. Please follow instructions below –

Note: MySQL settings – You can get this info from your cPanel or web developer

1- Code below allows you to change your wordpress websites database to your new database name

define(‘DB_NAME’, ‘myOldDatabaseName‘);

just update the last part, to with the new name-

define(‘DB_NAME’, ‘myNewDatabaseName‘);

and thats it.

2- Similarly change MySQL database username
define(‘DB_USER’, ‘test_user’);

3- Update to the latest MySQL database password
define(‘DB_PASSWORD’, ‘myPassword123’);

4- MySQL hostname (this line and rest of the file stays unchanged)
define(‘DB_HOST’, ‘localhost’);

Hope this helped, please leave your thoughts in comments below.

 

SHARE
Previous articleHow to create Database for WordPress ?
Next articleMyProtein 35% Off Discount Code | 2018
Navjot is a Hobby Blogger from Ireland, and loves to create content to help people. He makes time on weekends to work on this blog. And has a full time position at Yahoo as Technical Solutions Consultant, which he loves and thrives at. His Skills include in-depth knowledge of SEO, Javascript, Advertising, HTML and Java.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.