• About Us
  • Privacy & Policy
  • Contact
The Magazine Times
  • Home
  • News
    • All
    • Business
    Understanding the Importance of Setting Goals

    Understanding the Importance of Setting Goals

    Save A Lot Of Money On Regular Car Care

    What Is Power Steering And How Does It Work?

    Bakery Boxes

    How Custom Printed Bakery Boxes Are Best for Presenting Donuts

    Groundworks Teignmouth

    Groundworks and Block Paving Services at Affordable Prices

    Safe And Reliable Transport To And From The City

    Safe And Reliable Transport To And From The City

    Do “We Buy Houses” Buy Old Houses?

    Do “We Buy Houses” Buy Old Houses?

    Trending Tags

  • Tech
    • All
    • Apps
    • Gadget
    • Mobile
    • Startup
    WB6EKZwDZ70-HD

    8 Reasons Emails Bounce

    what does NGL mean

    What does “NGL” Mean, and How do you Use it?

    Email marketing secrets

    Why does Email Marketing is so important for Small Business

    5 Ways from which Gaming Industry generate revenue

    5 Ways from which Gaming Industry generate revenue

    Test Electronic Components

    Test Electronic Components

    Yahoo mail login

    How to Fix Yahoo Mail Login Problems?

    Trending Tags

  • Entertainment
    • All
    • Gaming
    • Sports
    5 Ways from which Gaming Industry generate revenue

    5 Ways from which Gaming Industry generate revenue

    How Can I Increase My Instagram Followers?

    Watch Ni Main Sass Kutni Punjbai Movie

    Where to Watch Ni Main Sass Kutni Punjbai Movie Online

    Diablo

    Everything About Diablo

    Download Hero of Nation Chandra Shekhar Azad

    Know Where to Download Hero of Nation Chandra Shekhar Azad full movie

    Lost Ark

    Lost Ark regains its position as the most popular massively multiplayer online role-playing game

  • Lifestyle
    • All
    • Fashion
    • Food
    • Health & Fitness
    • Travel
    Wax Strips

    What Is Meant By The Best Use Of Wax Strips?

    Minecraft

    How to Fix Bow in Minecraft?

    LOSE WEIGHT

    HOW TO LOSE WEIGHT WITHOUT FAILING?

    Safe And Reliable Transport To And From The City

    Safe And Reliable Transport To And From The City

    Women's Shapewear

    Best Women’s Shapewear: Comfort & Soft

    Chinese Dishes

    5 Chinese Dishes That You Should Definitely Try

    Trending Tags

  • Review
    Adminlinked.Com: Is It Real or Fake?

    Adminlinked .Com: Is It Real or Fake?

    Yayoins Review

    Yayoins Review: Is Yayoins legit or Not?

    Is Feogi Legit

    Is Feogi Legit – Get an Honest Review About Feogi.com

  • Celebrity
  • Digital Marketing
  • Education
No Result
View All Result
  • Home
  • News
    • All
    • Business
    Understanding the Importance of Setting Goals

    Understanding the Importance of Setting Goals

    Save A Lot Of Money On Regular Car Care

    What Is Power Steering And How Does It Work?

    Bakery Boxes

    How Custom Printed Bakery Boxes Are Best for Presenting Donuts

    Groundworks Teignmouth

    Groundworks and Block Paving Services at Affordable Prices

    Safe And Reliable Transport To And From The City

    Safe And Reliable Transport To And From The City

    Do “We Buy Houses” Buy Old Houses?

    Do “We Buy Houses” Buy Old Houses?

    Trending Tags

  • Tech
    • All
    • Apps
    • Gadget
    • Mobile
    • Startup
    WB6EKZwDZ70-HD

    8 Reasons Emails Bounce

    what does NGL mean

    What does “NGL” Mean, and How do you Use it?

    Email marketing secrets

    Why does Email Marketing is so important for Small Business

    5 Ways from which Gaming Industry generate revenue

    5 Ways from which Gaming Industry generate revenue

    Test Electronic Components

    Test Electronic Components

    Yahoo mail login

    How to Fix Yahoo Mail Login Problems?

    Trending Tags

  • Entertainment
    • All
    • Gaming
    • Sports
    5 Ways from which Gaming Industry generate revenue

    5 Ways from which Gaming Industry generate revenue

    How Can I Increase My Instagram Followers?

    Watch Ni Main Sass Kutni Punjbai Movie

    Where to Watch Ni Main Sass Kutni Punjbai Movie Online

    Diablo

    Everything About Diablo

    Download Hero of Nation Chandra Shekhar Azad

    Know Where to Download Hero of Nation Chandra Shekhar Azad full movie

    Lost Ark

    Lost Ark regains its position as the most popular massively multiplayer online role-playing game

  • Lifestyle
    • All
    • Fashion
    • Food
    • Health & Fitness
    • Travel
    Wax Strips

    What Is Meant By The Best Use Of Wax Strips?

    Minecraft

    How to Fix Bow in Minecraft?

    LOSE WEIGHT

    HOW TO LOSE WEIGHT WITHOUT FAILING?

    Safe And Reliable Transport To And From The City

    Safe And Reliable Transport To And From The City

    Women's Shapewear

    Best Women’s Shapewear: Comfort & Soft

    Chinese Dishes

    5 Chinese Dishes That You Should Definitely Try

    Trending Tags

  • Review
    Adminlinked.Com: Is It Real or Fake?

    Adminlinked .Com: Is It Real or Fake?

    Yayoins Review

    Yayoins Review: Is Yayoins legit or Not?

    Is Feogi Legit

    Is Feogi Legit – Get an Honest Review About Feogi.com

  • Celebrity
  • Digital Marketing
  • Education
No Result
View All Result
The Magazine Times
No Result
View All Result
Home News Business

How to change the prefix of WordPress tables

ackelyadam by ackelyadam
April 28, 2022
in Business
0
How to change the prefix of WordPress tables
0
SHARES
6
VIEWS
Share on FacebookShare on Twitter

The WordPress database is made up of tables, the tables all have the same prefix that is set during the WordPress installation.

In some cases it may be necessary to change the prefix of the tables, especially if it is the default one (wp_, wordpress_, etc.) which does not represent the maximum security. Let’s see how to change the prefix in 6 simple steps.

1: backup your database

This operation will modify the WordPress database so the first thing to do to be safe is to save the backup.

2: edit the wp-config.php file

In the WordPress root you find the configuration file “wp-config.php”. Search for the line:

$ table_prefix = ‘wp_’;

and change it to a new more secure prefix:

$ table_prefix = ‘example123_’;

Save the file.

3: Change the name of the database tables

Navigate to the phpMyAdmin panel and select your WordPress database. Click on the “SQL” menu and enter the command to rename all the tables. The process is to be performed for each table.

Whenever you paste a command line into the SQL window, click GO and check on the left column that the name is updated. Continue until all WordPress tables are renamed.

4: edit the wp_options field

Now you need to edit the example123_options options table (originally wp_options ).

Click on the link with the table name and then click on the “Browse” menu. You will see all the data stored in this table. Look at the “option_name” column and rename from wp_user_roles to example123_user_roles. To modify the string just click on the edit button (pencil) on the same line.

The wp_user_roles line may not appear on the first options page, keep looking for it otherwise you won’t be able to login.

5: edit the wp_usermeta field

As a last modification rename the field example123_usermeta (originally wp_usermeta). Do not leave out any data.

In phpMyAdmin select the example123_usermeta field and click the browse menu.

Change each value under the “meta_key” column, change the prefix from the old “wp_” to the new “example123_”, the number of data to change may vary from site to site:

To find out how many records you need to change, just run a query in SQL:

Click on the search link, enter these conditions (meta_key like ‘wp_%’), and click the GO button.

6: test the website

Check the site by browsing and logging in.

Alternatives

If you don’t want to get your hands dirty you can use the WP Prefix Changer plugin .

Previous Post

URLs Match.eu SEO copywriting tool

Next Post

A Marketers Guide To Google Reviews Widget

ackelyadam

ackelyadam

Next Post
A Marketers Guide To Google Reviews Widget

A Marketers Guide To Google Reviews Widget

Leave a Reply Cancel reply

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

Stay Connected test

  • Trending
  • Comments
  • Latest
A-Lovely-Crypto-Wallet-Web-3.0-Dapp-Browser

A Lovely Crypto Wallet & Web 3.0 Dapp Browser

May 11, 2022
Paula Dietz

Paula Dietz (Dennis Rader’s Ex-wife) – Bio, Wiki, Age, Death

September 7, 2021
What is Hanahaki Disease

What is Hanahaki Disease? – Is it Reality or a Myth?

September 7, 2021
Is Feogi Legit

Is Feogi Legit – Get an Honest Review About Feogi.com

October 21, 2021
How to Make a Pakistani Dress Cut and Sew at Home

How to Make a Pakistani Dress Cut and Sew at Home

1
WB6EKZwDZ70-HD

8 Reasons Emails Bounce

0
The Top 7 Tile Trends we Watched in 2021

The Top 7 Tile Trends we Watched in 2021

0
kitchen

Tips To Maintain The Perfect Kitchen

0
WB6EKZwDZ70-HD

8 Reasons Emails Bounce

May 19, 2022
Types of Plumbing Pipes

Types of Plumbing Pipes

May 19, 2022

5 Benefits Of A Pest Free Home

May 19, 2022

4 Pest Control Issues And Their Answers

May 19, 2022

Recent News

WB6EKZwDZ70-HD

8 Reasons Emails Bounce

May 19, 2022
5
Types of Plumbing Pipes

Types of Plumbing Pipes

May 19, 2022
4

5 Benefits Of A Pest Free Home

May 19, 2022
5

4 Pest Control Issues And Their Answers

May 19, 2022
6
The Magazine Times

Here at The Magazine Times, we share the latest news and helpful guides to our visitors. So, Stay Connected with us for the quality informational blogs.

Follow Us

Browse by Category

  • Apps
  • Business
  • Celebrity
  • Digital Marketing
  • Education
  • Entertainment
  • Fashion
  • Food
  • Gadget
  • Gaming
  • Health & Fitness
  • Home Improvement
  • Lifestyle
  • Mobile
  • News
  • Review
  • Sports
  • Startup
  • Tech
  • Travel
  • Uncategorized

Recent News

WB6EKZwDZ70-HD

8 Reasons Emails Bounce

May 19, 2022
Types of Plumbing Pipes

Types of Plumbing Pipes

May 19, 2022
  • About Us
  • Privacy & Policy
  • Contact

© The Magazine Times Copyright 2021. All Rights Reserved.

No Result
View All Result

© The Magazine Times Copyright 2021. All Rights Reserved.