Have you just been the victim of a hack on 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

how to change name base data wordpress 1

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 not, you can always get it from the “wp-config.php” file at the root of your WordPress installation.

Recovery-of-the-base-of-data

After having retrieved the name of your database, which should be able to match the list of databases in your installation on the administration tool " PhpMyAdmin ».

Discover 5 WordPress plugins to clean your website database

name-based data de

After clicking on the name of your database, you must click on the " operations ". On this new page, you need to 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 " Execute ". A window will ask you to confirm your action. After that, the database will have a new name.

If you suspect your database is the cause of your website slowness, find out How to optimize a database with one click on WordPress

Please note: : at the moment your blog is unavailable. WordPress cannot access the database. It is now time to change the name of the database in the file " wp-config.php ».

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

2. How to modify 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 " 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 you provide a username that is difficult 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 the privileges of the SQL user are. But in order not to complicate your life, I will ask you this time to choose all the privileges, by clicking on " Check all ».

Discover How to fix problems with the database and WordPress files

Please note: : you must make sure that all the boxes are checked. Also make sure to keep the username and password somewhere.

selection-of-privileges

Once done, click on " Execute " lower.

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

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

Please note: : Be sure to keep the changes between the quotes.

This process is not very delicate, a priori if you follow all the instructions to the letter, 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 appearance and to optimize the handling of your blog or website.

Here we offer you some premium WordPress plugins and themes that will help you do that.

1. Mega Menu Monster

Mega Menu Monster is a WordPress Plugin premium which will allow you to add mega menu to your pages on WordPress. Even if its use is much more suited to header menus, the fact remains that this plugin also allows you to use it at the footer.mega menu monster wordpress

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

Download | Demo | Web hosting

2. The Grid

The Grid is a WordPress Plugin grid premium that allows you to showcase all types of posts in a fully customizable and responsive grid system. It is perfectly suited for displaying your blog, portfolio, e-commerce products, or any kind of WordPress post types.The Grid Grid Responsive WordPress Plugin

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 100% responsive touch slider. You can filter any kind of grid in this touch slider which is just unique. The plugin can be easily integrated into a WordPress theme and with a personalized style…

Download | Demo | Web hosting

3. Portfolio Designer

Portfolio Designer is another great premium option if you want to create a portfolio or an image gallery. Just install this plugin and use the options included to create your portfolio.Portfolio Designer WordPress portfolio plugin

Choose a grid, a slider or justify the layout, add a pagination, load your images manually or automatically, add title links, borders, shadows and custom colors and finally choose from more than 50 effects image and hover.

The created portfolio will be fully compatible with all browsers and mobile devices.

Download | Demo | Web hosting

Recommended Resources

Find out about other recommended resources to help you build and manage 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 it, don't 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 suggestions in the dedicated section.

...