Solved

Renaming of WordPress Database

Posted on 2016-10-27
2
35 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 500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Now that you've installed WordPress 2.9 (http://www.experts-exchange.com/articles/Web_Development/Blogs/WordPress/WordPress-2-9-What-to-Expect-When-Upgrading-to-WordPress-2-9.html?) on your site, you need to install some plugins to get the most out …
WordPress is constantly evolving, and with each evolution appears to get better and better.  One of the big drawbacks prior to version 3 was that there was no way to be able to set up a custom menu from the backend. The Old Way Adding menus is…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
This video teaches users how to migrate an existing Wordpress website to a new domain.

766 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