Skip to Main Content

How to change the name of the WordPress database

Divi: the easiest WordPress theme to use

Divi: The best WordPress theme of all time!

With over 600.000 downloads, Divi is the most popular WordPress theme in the world. It is complete, easy to use and comes with more than 62 free templates. [Recommended]

Have you just been hacked by your WordPress website?

You need to change everything on your WordPress blog. This change will affect all access keys, but also the name of the database of your WordPress installation.

If you have never installed WordPress, discover How to install a WordPress blog in 7 steps et How to search, install and activate a WordPress theme on your blog

But in this tutorial, I'll show you how to change the name of your WordPress database.

1. Access your PhpMyAdmin

It is a database management tool provided by most web hosts; so you'll find it on your "CPanel". The first step will be to change the name of your database on this tool.

Do you remember the name of your database? If it is not, you can always recover it in the "wp-config.php" file at the root of your WordPress installation.

Recovery-of-the-base-of-data

After getting the name of your database, which should be able to match the database list of your installation on the admin tool " PhpMyAdmin ».

Discover 5 WordPress plugins to clean the database of your website

name-based data de

After clicking on the name of your database, you must click on the tab « operations ". On this new page, you must register the new name of your database in the section " Rename the database as follows ».

In this example, we renamed the database " wp_bdd_nouveau ". Once done, click on " perform ". A window will ask you to confirm your action. After that, the database will have a new name.

If you suspect your database is causing the slowdown of your website discover How to optimize a database in one click on WordPress

Remark : At the moment, your blog is unavailable. WordPress can not access the database. It is now time to change the name of the database in the file " wp-config.php ».

Are you looking for the best WordPress themes and plugins?

Download the best plugins and WordPress themes on Envato and easily create your website. Already more than 49.720.000 downloads. [EXCLUSIVE]

new-name-of-the-base-of-data

2. How to change the user assignment

At most web hosts, all databases are usually assigned to users. After editing the database, no more users will be assigned to the databaseit is therefore essential to reassign a user to this database.

You must click on the tab « privileges To access the SQL user privileges configuration interface.

Consult How to duplicate a WordPress database with phpMyAdmin to protect the latter

tab-privileges

Then click on New user ", A new window will open.

New user

On this window, you will be able to provide:

  • A name (make sure to provide a username not easy to find)
  • The customer concerned (default is "%" for all clients)
  • The password (You can click on the button Generate »Below to create a complex password)

interface-and-add-and-a-user

Below, in the section " Global Privileges You can define what are the privileges of the SQL user. But to avoid complicating your life, I will ask you this time to choose all the privileges, by clicking on " Check all ».

Discover How to fix problems related to the database and WordPress files

Remark You must make sure that all the boxes are checked. Also be sure to keep the username and password somewhere.

selection-of-privileges

Once done, click on " perform " lower.

Open the file now wp-config.php And change the name and password of the user.

wp-modifiation-of-the-base-of-data

Easily create your website with Elementor

Elementor allows you to easily create any website design with a professional look. Stop paying expensive for what you can do yourself. [Free]

Remark : Be sure to keep the changes between the quotes.

This process is not very difficult, so if you follow all the instructions exactly, no problem should arise. However, I will ask you to make a backup of your database, to prevent the irremediable.

Discover also some themes and premium WordPress plugins

You can use other themes and WordPress plugins to give a modern look and optimize the grip of your blog or website.

We offer here some plugins and premium WordPress themes that will help you do that.

1. Mega Menu Monster

Mega Menu Monster is a WordPress plugin that will allow you to add mega menu to your pages on WordPress. Even if use is much more adapted to the menus of the header, it remains that this plugin also allows you to use it on the footer.

Among its features we find among others: the support of all modern browsers, responsive on all devices, the layout hcustomizable (Background, colors, fonts) and many others.

Download | Demo | Web Hosting

2. The Grid

The Grid is a premium grid WordPress plugin that allows you to present all types of publications in a fully customizable and responsive grid system. It is perfect for displaying your blog, portfolio, e-commerce products or any kind of WordPress publications.

This plugin supports the following file formats: standard, video, audio, gallery, link, quote. The possibilities are endless and can be easily controlled with a powerful control panel.

The Grid is one of the most advanced grid plugins on WordPress and also the only one with a responsive touch slider at 100%. You can filter any type of grid in this touch slider, which is simply unique. The plugin can be easily integrated into a WordPress theme and with a custom style ...

Download | Demo | Web Hosting

2. Massive Dynamic

Massive Dynamic is a multipurpose WordPress theme that, despite its age, does not give up. Besides, he is is becoming one of the most popular premium WordPress themes you can buy today.

With the interface of this manufacturer, you can customize your own layouts, which would not be possible with a standard installation of WordPress. It also incorporates many useful elements that can be added to your page layouts, each of which can also be customized in several ways.

While Massive Dynamic focuses on allowing you to design your own website with its page building tool, it offers impressive 37 demos that cover a wide range of projects. There is also a good selection of eCommerce demos for the creation of Online shops.

Easily create your Online Store

Download free WooCommerce, the best e-commerce plugins to sell your physical and digital products on WordPress. [FREE]

Download | Demo | Web Hosting

Recommended Resources

Discover other recommended resources that will accompany you in creating and managing your website.

Conclusion

Here is ! That's it for this tutorial. We hope this article will help you change the name of the database. If you liked, do not hesitate to share with your friends on your favorite social networks.

However, you will also be able to consult our resources, if you need more elements to carry out your projects of creation of Internet sites, by consulting our guide on the WordPress blog creation.

But in the meantime, tell us about your comments and and suggestions in the dedicated section.

...

This article features 2 comments
  1. Hello when I modify the wp-config file to change the database,
    I go on my wordpress and I do refresh,
    then he proposes me to install wordpress (whereas I had already installed it at the beginning),
    what to do?

    1. This means that there are errors in the information on the database. Check the identifiers, but also the empty spaces ...

Leave a comment

Your email address will not be published. Required fields are marked with *

This site uses Akismet to reduce unwanted. Learn more about how your comments data is used.

Cool WordPress Themes that I found on
And there are more 50 000 themes and models to choose from!

Back To Top
15 shares
Share14
tweet
Save1
WhatsApp