?
Solved

Renaming of WordPress Database

Posted on 2016-10-27
2
Medium Priority
?
63 Views
Last Modified: 2016-11-01
Hi All

I want to rename the database and username of a WordPress site.  Although I will backup first I want to make sure it's done right.  Am I right by saying this can be done in 3 steps.

1) Rename the database in the My SQL section of the hosting package
2) Assign a user to the database
3) Change these lines to the correct DB name in wp-config.php

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

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

Open in new window


I want to do this as I am adding more and more sites and some of the naming conventions are not very good and want to keep track of what relates to each-other.

Thank you in advance for your assistance
0
Comment
Question by:IM&T SRFT
2 Comments
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 2000 total points
ID: 41862754
That should be all you need to do to ensure WP continues to work.
0
 

Author Closing Comment

by:IM&T SRFT
ID: 41868152
Thank you, I shall do this tonight!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Transferring a wordpress site from a host or local dev server to another host can be a pain. So I've included my steps on how I have accomplished this task. Steps include an assumption that you have Cpanel access or Ftp access.. If you do not hav…
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question