WPBeginner

Beginner's Guide for WordPress

  • Blog
    • Beginners Guide
    • News
    • Opinion
    • Showcase
    • Themes
    • Tutorials
    • WordPress Plugins
  • Start Here
    • How to Start a Blog
    • Create a Website
    • Start an Online Store
    • Best Website Builder
    • Email Marketing
    • WordPress Hosting
    • Business Name Ideas
  • Deals
    • Bluehost Coupon
    • SiteGround Coupon
    • WP Engine Coupon
    • HostGator Coupon
    • Domain.com Coupon
    • Constant Contact
    • View All Deals »
  • Glossary
  • Videos
  • Products
X
☰
Beginner's Guide for WordPress / Start your WordPress Blog in minutes
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
Recommended
WordPress Plugins
View all Guides

WPBeginner» Blog» Beginners Guide» Beginner’s Guide to WordPress Database Management with phpMyAdmin

Beginner’s Guide to WordPress Database Management with phpMyAdmin

Last updated on September 23rd, 2019 by Editorial Staff
485 Shares
Share
Tweet
Share
Pin
Free WordPress Video Tutorials on YouTube by WPBeginner
Beginner’s Guide to WordPress Database Management with phpMyAdmin

WordPress is written using PHP as its scripting language and MySQL as its database management system. In order to use WordPress, you don’t really need to learn either of them.

However, a very basic understanding of the two could help you troubleshoot problems as well as increase your understanding of how WordPress works (behind the scenes).

In this article, we will explain how WordPress uses the database including an intro to default WordPress database tables.

We will also show you how to manage a WordPress database using phpMyAdmin which will include creating database backups, optimizing the WordPress database, and more.

How to manage WordPress database using phpMyAdmin

This is a comprehensive guide on WordPress database management, so we have added a table of contents for easier navigation:

  • What is a database and how WordPress uses it?
  • What is phpMyAdmin?
  • How to access phpMyAdmin
  • Understanding WordPress database tables
  • Managing WordPress database via phpMyAdmin
  • Creating a WordPress database backup using phpMyAdmin
  • Creating a WordPress backup using a plugin
  • Importing WordPress database using phpMyAdmin
  • Optimizing your WordPress database using phpMyAdmin
  • Fixing WordPress issues using phpMyAdmin
  • Reset WordPress password using phpMyAdmin
  • Adding a new WordPress admin user via phpMyAdmin
  • Changing a WordPress username using phpMyAdmin
  • Other useful phpMyAdmin tricks
  • Securing your WordPress database

What is a Database and How WordPress Uses it?

A database is a system of storing and fetching data in an organized way. Database allows software to manage data in a programmable way.

For example: WordPress uses PHP (programming language) to store and retrieve data from the database.

The information stored in a WordPress database includes posts, pages, comments, categories, tags, custom fields, users, and other WordPress settings. We will elaborate on this later in the tutorial when we cover all WordPress database tables.

When you first install WordPress, it asks you to provide a database name, host, username, and password. This information is stored in the configuration file called wp-config.php.

WordPress database information

During the installation, WordPress uses the information you provide about the database to create tables and store default installation data inside those tables.

After the installation, WordPress runs queries to this database to dynamically generate HTML pages for your website or blog.

This is what makes WordPress extremely powerful because you don’t have to create a new .html file for each page that you want to create. WordPress handles everything dynamically.

Where is my WordPress database stored?

WordPress uses MySQL as its database management system, which is a software installed on your WordPress hosting server. Your WordPress database is also stored on the same server.

This location however is not accessible on most shared hosting environments. However, if you are on a VPS hosting plan or a dedicated server, then you can use command line tools to locate the database.

Most often it is located at the following path:

/var/lib/mysql/your_database_name

However, this could differ from one hosting provider to another.

It is important to keep in mind that you don’t really need to access the database file itself. You can use other tools like phpMyAdmin to manage your database.

What is phpMyAdmin?

PhpMyAdmin is a web-based software that allows you to manage MySQL databases using your web browser. It offers an easy to use interface that allows you to run MySQL commands and database operations.

You can also use it to browse and edit database tables, rows, and fields. It also allows you to import, export, or delete all data inside a database.

How to Access PhpMyAdmin?

PhpMyAdmin comes pre-installed with all top WordPress hosting companies. You can find it under the Databases section of your hosting account’s cPanel dashboard. Below is an example screenshot from Bluehost control panel:

phpMyAdmin in cPanel

Depending on your hosting provider, your cPanel interface may look different than the above screenshot. You would still be able to find phpMyAdmin icon under the databases section.

Clicking on it will open the phpMyAdmin interface where you can select your WordPress database from the left column. After, that phpMyAdmin will display all tables in your WordPress database.

PhpMyAdmin dashboard

Let’s take a look at the WordPress database tables.

Understanding WordPress Database Tables

Each WordPress installation has 12 default tables in the database. Each database table contains data for different sections, features, and functionality of WordPress.

Looking at the structure of these tables, you can easily understand where different parts of your website are stored. Currently, a default WordPress installation creates the following tables:

Note: wp_ before each table name is the database prefix you choose during the installation. It can be different if you changed it at the time of installation.

wp_commentmeta : This table contains meta information about comments posted on a WordPress website. The table has four fields meta_id, comment_id, meta_key, and meta_value. Each meta_id is related to a comment_id. One example of comment meta information stored is the status of comment (approved, pending, trash, etc).

wp_comments : As the name suggests this table contains your WordPress comments. It contains comment author name, url, email, comment, etc.

wp_links : To manage blogrolls create by earlier versions of WordPress or the Link Manager plugin.

wp_options : This table contains most of your WordPress site-wide settings such as: site url, admin email, default category, posts per page, time format, and much much more. The options table is also used by numerous WordPress plugins to store plugin settings.

wp_postmeta : This table contains meta information about your WordPress posts, pages, and custom post types. Example of post meta information would be which template to use to display a page, custom fields, etc. Some plugins would also use this table to store plugin data such as WordPress SEO information.

wp_posts : The name says posts but actually this table contains all post types or should we say content types. This table contains all your posts, pages, revisions, and custom post types.

wp_termmeta : This table allows developers to store custom metadata for terms under their custom taxonomies. For example, WooCommerce uses it to store metadata for product attributes and categories.

wp_terms : WordPress has a powerful taxonomy system that allows you to organize your content. Individual taxonomy items are called terms, and they are stored in this table. For example, your WordPress categories and tags are taxonomies, and each category / tag inside them is a term.

wp_term_relationships : This table manages relationship of WordPress post types with terms in wp_terms table. For example this is the table that helps WordPress determine post X is in Y category.

wp_term_taxonomy : This table defines taxonomies for terms defined in wp_terms table. For example, if you have a term “WordPress Tutorials“, then this table contains the data that says it is associated with a taxonomy called category. In short, this table has the data that helps WordPress differentiate between which term is a category, which is a tag, etc.

wp_usermeta : Contains meta information about registered users on your website.

wp_users : Contains user information like username, password, user email, etc.

Managing WordPress Database using phpMyAdmin

Your WordPress database contains important WordPress settings, all your blog posts, pages, comments, and more. You need to be extremely careful when using phpMyAdmin, or you may end up accidentally deleting important data.

As a precaution, you should always create a complete database backup. This would allow you to restore your database the way it was before.

Let’s take a look at how to easily create a WordPress database backup.

Creating a WordPress Database Backup using phpMyAdmin

To create a backup of your WordPress database from phpMyAdmin, click on your WordPress Database. On the top menu, click on the Export tab.

Export WordPress database

In newer versions of phpMyAdmin, it will ask you for an export method. The quick method will export your database in a .sql file. In the custom method, it will provide you with more options and ability to download backup in compressed zip or gzip archive.

We recommend using the custom method and choosing zip as the compression method. The custom method also allows you to exclude tables from the database.

Let’s say if you used a plugin that created a database table, and you are no longer using that plugin, then you can choose to exclude that table from the backup if you want.

Compression method

Your exported database file can be imported back into a different or the same database using phpMyAdmin’s import tab.

Creating a WordPress Backup using a Plugin

Keeping regular backups of your WordPress site is the best thing you can do for your WordPress security. While the WordPress database contains the majority of your site information, it still lacks several fairly important elements such as template files, images, uploads, etc.

All your images are stored in the uploads folder in your /wp-content/ directory. Even though the database has the information which image is attached to a post, it is useless if the image folder doesn’t have those files.

Often beginners think that the database backup is all that they need. It is NOT true. You need to have a full site backup that includes your themes, plugins, and images.

While most hosting companies claim they have daily backups, we recommend that you keep backups yourself just in case.

Note: If you are on a managed WordPress hosting solution like WPEngine, then they do create daily backups.

For the majority of us who are not on WPEngine, you should use a WordPress backup plugin to set up automated WordPress backups on your site.

Importing a WordPress Database Backup via phpMyAdmin

PhpMyAdmin also allows you to easily import your WordPress database. Simply launch phpMyAdmin and then select your WordPress database.

Next, you need to click on the ‘Import’ link from the top menu.

Import database via phpMyAdmin

On the next screen, click on the Choose file button and then select your database backup file you downloaded earlier.

PhpMyAdmin will now process your backup file upload and import it into your WordPress database. Once finished, you will see a success message.

Database imported successfully

Optimizing your WordPress Database in phpMyAdmin

After using WordPress for a while, your database becomes fragmented. There are memory overheads which increase your overall database size and query execution time.

MySQL comes with a simple command that allows you to optimize your database. Simply go to phpMyAdmin and click on your WordPress database. This will show you a list of your WordPress tables.

Click on the check All link below the tables. Next to it, there is a “With Selected” drop down, you need to click on it and choose Optimize table.

Optimize WordPress database tables

This will optimize your WordPress database by defragmenting selected tables. It will make your WordPress queries run a little faster and slightly reduce the size of your database.

Fixing WordPress Issues using PhpMyAdmin

As we mentioned earlier, phpMyAdmin is a handy tool for troubleshooting and fixing some common WordPress errors and issues.

Let’s check out some common WordPress issues that can be easily fixed using phpMyAdmin.

Reset WordPress Password Using PhpMyAdmin

If you forgot your WordPress admin password and cannot recover it via lost password email, then this method allows you to quickly reset WordPress password.

First, launch the phpMyAdmin and select your WordPress database. This will display your WordPress database tables where you need to browse next to wp_users table.

Browse user table

Note: Table names in your WordPress database may have a different table prefix than the one we are showing in our screenshot.

You will now see the rows in your WordPress users table. Go ahead and click on the edit button next to the username where you want to change the password.

Edit user

PhpMyAdmin will show you a form with all the user information fields.

You will need to delete the value in the user_pass field and replace it with your new password. Under the function column, select MD5 from the drop-down menu and click on the Go button.

Change user password

Your password will be encrypted using the MD5 hash and then it will be stored in the database.

Congratulations! You have successfully changed your WordPress password using phpMyAdmin.

Now some of you may be wondering why did we select the MD5 hash to encrypt the password.

In the older version, WordPress used MD5 hash to encrypt passwords. Since WordPress 2.5, it started using stronger encryption technologies. However, WordPress still recognizes MD5 to provide backward compatibility.

As soon as you log in using a password string stored as an MD5 hash, WordPress recognizes it and changes it using the newer encryption algorithms.

Adding a New Admin User to WordPress using PhpMyAdmin

Let’s suppose you have access to the WordPress database but not the WordPress admin area. While you can change the admin user password, it will prevent the other admin user from using their account.

An easier solution would be to add a new admin user via phpMyAdmin.

First, you need to launch the phpMyAdmin and then select your WordPress database. This will show your WordPress database tables where you need to click on the ‘Browse’ link next to wp_users table.

Browse user table

phpMyAdmin will now show you the rows inside the wp_users table. Go ahead and click on the ‘Insert’ link from the menu on the top.

Insert new row in WordPress users table

This will bring up a form that you need to fill up to add a new user to your WordPress site.

Fill user form

Here is how you need to fill each field in this form.

  • ID – You can ignore this one as this is automatically generated.
  • user_login – This will be your WordPress username that you’ll use to login.
  • user_pass – This is your WordPress password you need to enter the password and select MD5 in the function column.
  • user_nicename – This is the URL friendly username you can use the as your login.
  • user_email – Enter a valid email address as you may need it to recieve password reset and WordPress notification emails.
  • user_url – Add your website URL or you can leave it blank.
  • user_registered – You need to select the CURRENT_TIME in the function column to automatically insert current time here.
  • user_activation_key – You can leave this field blank as well it is used to approve user registeration.
  • user_status – You can leave this field blank as well.
  • display_name – You can enter the user’s full name as you want to be displayed on the articles. You can also leave it blank.

After filling in the form, click on the Go button to insert it into your WordPress database. PhpMyAdmin will now run the MySQL query to insert the data.

We have added the user, but that user does not have an administrator user role on your WordPress site. This value is saved in another table called wp_usermeta.

Before we can make this user an administrator, we will need to find the user ID. Simply click on the ‘Browse’ link next to wp_users table and you will see a row containing your newly added user with their user ID.

Find user ID

Note down the user ID as you’ll need it in the next step.

Now, let’s open the wp_usermeta table by clicking on the Browse link next to it.

Browsing wp_usermeta table

Next, you need to click on the Insert link at the top to add a new row to the table.

Insert new row to usermeta table

You’ll now see a form to enter a new row. This is where you’ll tell WordPress that the user you created earlier has the administrator user role.

Adding administrator user role via usermeta

Here is how you’ll fill in this form.

  • umeta_id – You need to leave it blank as it is automatically filled in.
  • user_id – Enter the user ID you copied earlier.
  • meta_key – You need to enter wp_capabilities in this field. However, you may need to replace wp_ if your WordPress table names use a different prefix.
  • meta_value – You need to enter the following serialized value:
    a:1:{s:13:"administrator";s:1:"1";}

Finally, click on the Go button to save your changes.

Next, we need to add another row to define the user level. Click on the Insert link on the top menu to add another row to the usermeta table.

Adding the user level meta field

Here is how you’ll fill in this form.

  • umeta_id – You need to leave it blank as it is automatically filled in.
  • user_id – Enter the user ID for your newly added user.
  • meta_key – You need to enter wp_user_level in this field. However, you may need to replace wp_ if your WordPress table names use a different prefix.
  • meta_value – Here you need to enter 10 as the user level value.

Don’t forget to click on the Go button to insert the data.

That’s all, you can now visit the WordPress admin area and log in with your newly added admin user.

Change a WordPress Username via PhpMyAdmin

You may have noticed that while WordPress allow you to change user’s full name or nickname, it does not allow you to change the username.

Now a lot of users end up choosing usernames during the installation that they may later want to change. Here is how you can do this via phpMyAdmin.

Note: there is an easier way to change WordPress username using a plugin.

First, you need to launch the phpMyAdmin from your hosting account’s cPanel dashboard. After that, you need to select your WordPress database.

PhpMyAdmin will show your WordPress database tables. You need to click on the ‘Browse’ link next to wp_users table.

Browse user table

This table will now list all the registered users on your website. Click on the edit link next to the username that you want to change.

Edit user data via phpMyadmin

PhpMyAdmin will now show you the user data. You need to locate the user_login field and change the value to the username you want to use.

Change WordPress username in phpMyAdmin

Don’t forget to click on the Go button to save your changes. You can now visit your website and login with your new username.

Other Useful PhpMyAdmin Tricks

Your WordPress database is the engine behind your website. With phpMyAdmin you can tweak settings to improve performance, fix issues, or simply change things that cannot be changed from inside WordPress admin area.

Following are just a few more tricks you can use with phpMyAdmin.

  • Deactivate all WordPress plugins
  • Change WordPress theme via phpMyAdmin
  • Duplicate WordPress database via phpMyAdmin
  • Find and replace text in WordPress database

Securing your WordPress Database

Before we get into this, we want to emphasize that every site can be hacked. However, there are certain measures you can take to make it a little harder.

First thing that you can do to is to change WordPress database prefix. This can significantly reduce the chances of SQL injection attacks on your WordPress database because often hackers target sites in masses where they are targeting the default wp_ table prefix.

You should always choose a strong username and password for your MySQL user. This will make it difficult for someone to get access to your WordPress database.

For WordPress security, we strongly recommend that you use Sucuri. It is the best WordPress security plugin that would catch any attempts at MySQL injection even before it reaches your website.

We hope that this guide helped you learn WordPress database management and how to use phpMyAdmin.

If you are the sort of person who likes to learn how things work behind the scenes, then you would love our guides on how WordPress actually works and how WordPress plugins work.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

485 Shares
Share
Tweet
Share
Pin
Popular on WPBeginner Right Now!
  • Revealed: Why Building an Email List is so Important Today (6 Reasons)

    Revealed: Why Building an Email List is so Important Today (6 Reasons)

  • Google Analytics in WordPress

    How to Install Google Analytics in WordPress for Beginners

  • Checklist

    Checklist: 15 Things You MUST DO Before Changing WordPress Themes

  • How to Properly Move Your Blog from WordPress.com to WordPress.org

About the Editorial Staff

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Trusted by over 1.3 million readers worldwide.

The Ultimate WordPress Toolkit

105 Comments

Leave a Reply
  1. Nadine says:
    Nov 19, 2020 at 10:34 am

    Hi!

    Thanks you so much for this tutorial!!! it was really help full!

    Reply
    • WPBeginner Support says:
      Nov 20, 2020 at 10:10 am

      Glad our guide was helpful :)

      Reply
  2. Abdul says:
    Nov 17, 2020 at 12:37 pm

    Article is well explanatory and concise. Thank you.

    Reply
    • WPBeginner Support says:
      Nov 17, 2020 at 12:44 pm

      You’re welcome :)

      Reply
  3. Kelvin says:
    Sep 10, 2020 at 5:05 pm

    Am having problem with the login pageusername how it connect with database

    Reply
    • WPBeginner Support says:
      Sep 11, 2020 at 11:03 am

      For any issues with your database, you would want to reach out to your hosting provider and they should be able to assist.

      Reply
  4. Kevin says:
    Aug 13, 2020 at 12:59 am

    A good introduction thank you.

    I have several WP sites and several databases.
    How can I tell which database belongs to which site?

    Reply
    • WPBeginner Support says:
      Aug 13, 2020 at 10:49 am

      The wp-config file for each site and that would specify which database they are using. You can see our guide on the wp-config file below:

      https://www.wpbeginner.com/glossary/wp-config-php/

      Reply
  5. Salman says:
    May 3, 2020 at 6:35 pm

    Perfect… I want to learn

    Reply
    • WPBeginner Support says:
      May 5, 2020 at 10:21 am

      Glad our article can be a good starting point :)

      Reply
  6. Pam Sheets says:
    Jan 12, 2020 at 10:26 pm

    Awesome! Very well explained quick and to the point.

    Thank you,

    Reply
    • WPBeginner Support says:
      Jan 13, 2020 at 11:46 am

      You’re welcome, glad you liked our article :)

      Reply
  7. Dubravka says:
    Oct 17, 2019 at 11:04 am

    Very clear and really good article.

    Reply
    • WPBeginner Support says:
      Oct 17, 2019 at 1:27 pm

      Thank you :)

      Reply
  8. Aviral says:
    Sep 26, 2019 at 8:54 am

    Very nice article :)

    Reply
    • WPBeginner Support says:
      Sep 26, 2019 at 11:47 am

      Thank you :)

      Reply
  9. Vimal Rathod says:
    Sep 24, 2019 at 9:06 am

    You write well I learned a lot from this blog. My question was answered but I also got the information I needed

    Reply
    • WPBeginner Support says:
      Sep 24, 2019 at 9:45 am

      Glad our content has been helpful :)

      Reply
  10. ajay says:
    Aug 10, 2019 at 2:53 pm

    I have two totally separate WP websites setup. Different domains, different databases. I manage both of them and they are both hosted on a dedicated server. I am trying to include some basic content that requires just a tad more than an RSS feed. I need to pull data from SITE-1 and display it on SITE-2

    Reply
    • WPBeginner Support says:
      Aug 12, 2019 at 10:36 am

      If it is a post or page you can go under Tools>Export on the site with the content to select the specific content you want to be transferred and then use Tools>Import on the site to bring in the content

      Reply
  11. Dr Eddy says:
    Jul 15, 2019 at 4:09 am

    I need more help how to create, a website via word press and how to Host it
    Any help..

    Reply
    • WPBeginner Support says:
      Jul 15, 2019 at 12:47 pm

      We have a guide you can follow here: https://www.wpbeginner.com/guides/

      Reply
  12. Wadhi says:
    Jun 24, 2019 at 6:03 pm

    do i need to learn back end development if i use WordPress. I mean aren’t there some plugins which can help me create a website with front-end and back end system. I want a food delivery website

    Reply
    • WPBeginner Support says:
      Jun 25, 2019 at 11:50 am

      You do not need to learn development to run a WordPress site. Some plugins will give you that kind of editing power but not all of those plugins are needed.

      Reply
  13. George says:
    May 11, 2019 at 6:15 am

    when i clink on new post, this is what i see; Sorry, that didn’t work.
    Please try again or come back later.
    504 Error. Gateway Timeout.
    please help

    Reply
    • WPBeginner Support says:
      May 13, 2019 at 1:08 pm

      For the 504 error, you would want to take a look at our article here: https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-504-gateway-timeout-error-in-wordpress/

      Reply
  14. Steve Hanzek says:
    May 2, 2019 at 11:52 am

    I’m looking to create a website that would allow bands and venues to maintain their schedules, and a visitor to select a date and see all the bands playing on that date, and all the venues with bands playing on that date.
    I’m proficient with the SQL (mySQL) needed to do the querying, just want to find out if WordPress will let me create custom pages based on the results of a query?
    Thanks

    Reply
    • WPBeginner Support says:
      May 3, 2019 at 10:23 am

      WordPress will allow that, for an example plugin that already allows you to search you can take a look at our article here: https://www.wpbeginner.com/plugins/how-to-let-users-filter-posts-and-pages-in-wordpress/

      Reply
  15. Kelsei says:
    Apr 2, 2019 at 12:40 pm

    I am new at a job and just taking over the website. However, I am reaching the Error Establishing Database Connection on the website itself and the login page. The email they used to originally sign up for the website has been deactivated due to her no longer working here. I have searched the files and cannot find the WP files I am seeing being mentioned above. I am unsure what my next steps should be. Any ideas?

    Reply
    • WPBeginner Support says:
      Apr 3, 2019 at 10:36 am

      For the error establishing database connection, you would want to take a look at our article here: https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/
      If you reach out to your hosting provider they should be able to assist with swapping the email address to your new email

      Reply
  16. Sharwari says:
    Mar 15, 2019 at 9:17 am

    Hi my database is automatically created! Can I Rename the database?

    Reply
    • WPBeginner Support says:
      Mar 19, 2019 at 11:21 am

      Yes, you can, you would want to follow our guide on how to do this here: https://www.wpbeginner.com/wp-tutorials/how-to-change-the-wordpress-database-prefix-to-improve-security/

      Reply
  17. Yinka says:
    Mar 15, 2019 at 6:42 am

    Hi,

    I recently moved by hosting and it affected the frontend of my website which displays “Error Establishing a Database Connection”. So I created a database.

    The website contents are in the public_html folder in my cPanel File Manager.

    How and where do I move these contents to the database in order to display my actual website?

    Thanks.

    Reply
    • WPBeginner Support says:
      Mar 18, 2019 at 4:09 pm

      Rather than moving your content, you would want to take a look at solving the error using our article here: https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/

      Reply
  18. Kerrie Taylor says:
    Mar 13, 2019 at 11:33 pm

    Hi, I cannot get WordPress to reset my password. How would I go about doing it using this way?
    Thanks

    Reply
    • WPBeginner Support says:
      Mar 14, 2019 at 10:41 am

      You would log in to your hosting provider to find your phpMyAdmin, depending on the host there are a few places it could be located.

      Reply
  19. Miza says:
    Feb 26, 2019 at 1:34 am

    Hi, I need help on this.

    I’m planning to utilize database to create a system that can be accessed only by our company staff in wordpress.

    May I know from where i should started ?

    Reply
    • WPBeginner Support says:
      Feb 26, 2019 at 1:27 pm

      If you’re wanting to create an intranet you could take a look at: https://www.wpbeginner.com/wp-tutorials/how-to-create-a-wordpress-intranet-for-your-organization/

      Reply
      • Miza says:
        Mar 7, 2019 at 1:03 am

        How about for existing wordpress? just want to implement system that can be used by our staff only. i mean i want to create a page (basically a service report in our company website – wordpress) that can only be accessed by our staff

        Reply
        • WPBeginner Support says:
          Mar 7, 2019 at 11:12 am

          If it is only one page you could use the method in: https://www.wpbeginner.com/plugins/how-to-share-private-posts-with-user-groups-in-wordpress/

  20. Mich says:
    Feb 21, 2019 at 8:48 pm

    Hi,

    I recently created a few WordPress sites and I did it through one click WordPress installation in cPanel. What I wanted to know is, “Should I change my WordPress database name and database user name?” Is it something easily hackable if I’m already using a free security plugin like Wordfence?

    Thanks!

    Reply
    • WPBeginner Support says:
      Feb 22, 2019 at 11:34 am

      Most hosting providers’ one-click installations change the database prefix for you to help with that. It is not something that by default is easily hackable and security plugins help even more

      Reply
  21. Joachim says:
    Feb 14, 2019 at 2:48 pm

    This is great. But what if i create a custom site on wordpress and input a form validation input. Is the data going to be automatically stored in the wp_database?

    Reply
    • WPBeginner Support says:
      Feb 15, 2019 at 10:02 am

      You would need to set up in your form to store the information, it would not be automatic.

      Reply
  22. John Certalic says:
    Dec 30, 2018 at 10:14 pm

    Is it possible to get this information in an email rather than a tweet? It would be more easily accessible for me in an email for future reference. I appreciate all you do for newbies like me. Thank you.

    Reply
    • WPBeginner Support says:
      Dec 31, 2018 at 2:33 pm

      While we don’t have the entire article in our newsletter emails, we’ll be sure to take a look into possibilities.

      Reply
  23. polo says:
    Dec 15, 2018 at 6:35 am

    Hello Sir, I have hosted my website with someone which has not given me inbuild features of myphp admin.So how to download it on my desktop plz guide .is there othere software required with myphp to download it.

    Reply
    • WPBeginner Support says:
      Dec 17, 2018 at 7:42 pm

      Hi Polo,

      You can access phpMyAdmin from your web hosting account. If you have access to your web hosting account, then you can login there and under the databases section you’ll find phpMyAdmin icon.

      Reply
  24. Rajat Pandey says:
    Oct 23, 2018 at 2:02 pm

    Very Informative Thank You

    Reply
  25. Ayush singh says:
    Jun 4, 2018 at 8:04 am

    i have a result table in database and i want to fetch the result of the student by registration number.
    i m not getting solution to where to code in the wordpress site….and how to see result of the student by registration number.

    Reply
    • Prakash says:
      Jan 1, 2019 at 5:34 am

      Use wp_user table

      Reply
  26. Zziwa Daniel says:
    Apr 13, 2018 at 12:20 pm

    Thank you so much for the tutorial, its powerful
    however I have a question;

    I have a database that I have created with workbench and I have imported it to phpmyadmin. however I want to connect with wordpress so that when I submit data through wordpress I can be able to view it in phpmyadmin and I can view it again in wordpress interface that I have created

    Reply
  27. Ibrahim says:
    Feb 16, 2018 at 3:01 pm

    Your tutorials has been helpful.

    based on a previous tutorial on installing wordpress on PC, I followed the tutorial and it was successful. i developed a website for diabetes association of Nigeria which iam a member too. But my challenge now is how to add registration form for new members to register online and how to get donation online in the website. i need your help please.

    Reply
    • WPBeginner Support says:
      Feb 19, 2018 at 10:57 am

      Hi Ibrahim,

      Please see our tutorial on how to create a custom user registration form in WordPress. As for donations, we are not sure which payment providers you will be using to collect donations. Here is our tutorial on how to accept online donations in WordPress

      Reply
  28. Hemant says:
    Nov 20, 2017 at 8:43 am

    Is it possible to migrate WordPress database to newly developed web applications?

    Reply
  29. Ian de Guzman says:
    Nov 14, 2017 at 9:20 pm

    Where can i upload the website I made and that can be accessed offline. Thank you in advance.

    Reply
    • WPBeginner Support says:
      Nov 16, 2017 at 5:42 am

      hi Ian,

      If it is a WordPress website, then see our guide on how to move a local site to a live server. You will need a WordPress hosting account for that.

      Reply
    • FirdausShukor says:
      Jan 5, 2018 at 3:03 am

      To make your wordpress website can be accessed offline you can use xampp as a local server and you can install wordpress inside htdocs folder in xampp installation folder.

      Reply
  30. Siva says:
    Sep 23, 2017 at 7:16 am

    Thanks a lot.it gave me some clear vision.

    Reply
  31. Andreas says:
    Sep 15, 2017 at 1:37 am

    What if i want to import wordpress menus? Where in the database are the menus stored?

    Reply
  32. Pooja Raval says:
    Aug 2, 2017 at 6:51 am

    thanks…it helps a lot to understand it a bit better..

    Reply
  33. Laura Panait says:
    Mar 23, 2017 at 6:46 am

    Very helpful tutorial, thank you, it actually worked.

    Reply
  34. Divo says:
    Dec 22, 2016 at 11:30 pm

    Please where does wordpress store page information. How can I change a page title from the database?

    Reply
  35. Prerna Rathod says:
    Nov 22, 2016 at 7:50 am

    I use contact form 7 for feedback purposes and i store that data in database but now i want that particular data by URL like (abc.com/feedback/5) so it will show the data of id no 5 how i do this in wordpress?

    Reply
  36. Mirjana says:
    Nov 6, 2016 at 5:36 pm

    Hello,

    I`m planing to make some wp website with registration for specific users ( I have a non profit organisation that has more than 2000 members.) Now, I have the list of them (members) in my Access db with all informations needed. My question is, is it possible to connect this access db with wp db? If yes, how to do that?
    Also, every member has a unique ID in my db, which is also a number for the membership card they have. If before mentioned is possible, could I make a field in registration form, beside Username&Pass, that would request that ID number which would be checked from db and if correct, make a registration, if false, deny it?
    Hope you understand me cause my englesh is not so grate…
    Thanks in advance

    Reply
    • Ayomide says:
      Aug 30, 2017 at 6:04 am

      I’m having the same problem, please did you figure out a solution?? If you did please, get back to me.

      Reply
  37. Matthew says:
    Aug 31, 2016 at 3:45 am

    Hello, I am preparing to launch my first wordpress blog site under my first website. Testing and learning the blog setup I am wondering how the email stuff is working. I created a comment in response to a post and ticked the email me a notification when posts are done option. And when I made another post I received an email notification. Looking in the tables using phpmyadmin I can see the email address I entered with the comment stored in wp1_comments but cannot see where/how the fact is stored that an email should be sent to that address when a new post is made.

    Thank you

    Reply
  38. Saud Khan says:
    Aug 29, 2016 at 5:09 pm

    Hi,

    Can you please help me that how can I view my blog database because they are not visible anywhere.

    snaps attached

    Reply
  39. Murali says:
    May 23, 2016 at 7:36 am

    Hi,
    I run Certification Services like food certificate, ISI Certificate and etc.,.
    I have simple wordpress website (self hosted),

    Now, I plan to create Page for my clients to get current status about their Application.

    Once they enter (1) Application No. (2) Date of Birth / Mobile number, if match details it will display application status else show error message (like not match given details).

    Kindly suggest me which plugin / method suite for my requirement.

    Thanks

    Reply
  40. Tom says:
    May 20, 2016 at 1:33 pm

    Hello :)
    I need some help, because I don’t understand something:
    I register a WP website… and install WooCommerce in it. (I use XAMPP localhost on C partition)
    So I have a clear WP+WooCommerce site which I’d like to use to create other WP sites too.
    So I copy all the WP files from C… to another partition, let’s say D partition
    and I also export its database by phpMyAdmin. Now I have a copy of the WP site and its database on D partition.
    But what if I’d like to use the copied WP+WooCommerce site (pattern) I’ve created?
    It is still contains the same e-mail address and password I used when I registrated on the official site of WP right? So how can I modify that?
    I’d like to create a new website (with different admin e-mail and password) but using the same WP+WooCommerce site (pattern) I’ve created before.

    Reply
  41. Penelope says:
    Apr 13, 2016 at 10:09 am

    When I did a database backup and followed the custom options. (following these steps: )

    When I hit GO, a file goes to my downloads folder and does nothing. the file is empty. What could I be doing wrong?

    Reply
  42. Richard says:
    Mar 3, 2016 at 2:00 pm

    Thank you for the great explanation of how WordPress interfaces to MySQL. Question: We have some blogs our site that are displaying a blank page. The blogs with blank pages have the same information as those that are working properly. I’ve used phpMyadmin to examine the tables and all looks well. Which table does WordPress use to begin the page generation?

    Reply
    • WPBeginner Support says:
      Mar 4, 2016 at 12:47 am

      It seems like a plugin or theme issue. To find out what’s causing the issue, deactivate all plugins on your site and then switch to a default theme like Twenty Sixteen.

      Reply
  43. roj says:
    Dec 26, 2015 at 11:12 am

    The video was a little superfluous to the more descriptive written explanation of this article AND, as with many of your videos the narrator speaks too quickly and is thus difficult to understand if you don’t speak American. – even to me as a native English speaker!

    Reply
  44. Anik says:
    Apr 24, 2015 at 3:46 pm

    how should i connect the in-build search form with my database to see the search results…

    Reply
  45. WPBeginner Staff says:
    Dec 21, 2014 at 7:53 pm

    In wp_comments table you will find comment_author_email and comment_author_IP fields. Note that the wp_ prefix in the comments table may differ in your database.

    You can also find comment author email and IP information inside WordPress admin area.

    Reply
  46. IdolHanz says:
    Dec 21, 2014 at 12:46 pm

    Which part of the database management system in phpMyAdmin shows a commenter’s IP address and email address?

    Reply
  47. WPBeginner Staff says:
    Nov 2, 2014 at 10:21 pm

    phpMyAdmin is not a database management system. It is a utility that allows you to manage your database in a web based graphical user interface.

    Your actual database resides on your MySQL database server. Any utility that wants to manage, backup, or make changes to your database will need your database username and password to do so.

    BackupBuddy works as a WordPress plugin and your database username and password are already stored in your WordPress configuration file. So it can automatically connect to your database without explicitly asking for your username and password.

    Reply
  48. Nazim says:
    Nov 2, 2014 at 10:01 am

    Is it necessary for any plugin/ tool to access to myphpadmin to backup database.. If not then how backupbuddy creates database backups…

    Is backupbuddy require username and password of myphpadmin to access to database…

    I am newbie and confused. If you know then please let me know…

    Reply
  49. Bernhardt Le Mechant says:
    Sep 7, 2014 at 12:39 am

    I just wanted to say…thanks…good article! (i was wondering how all this worked).

    Reply
  50. Kenjie Suarez says:
    Aug 9, 2014 at 4:22 am

    Hi, I would like to know if it’s okay to delete this table I found along with the default ones: wp-sml. I don’t even know what this is for. Thank you so much for your article and support.

    Reply
« 1 2

Leave a Reply Cancel reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

Over 1,320,000+ Readers

Get fresh content from WPBeginner

Featured WordPress Plugin
SeedProd Logo
SeedProd
Create beautiful custom landing pages - Drag & drop builder. Learn More »
How to Start a Blog How to Start a Blog
I need help with ...
Starting a
Blog
WordPress
Performance
WordPress
Security
WordPress
SEO
WordPress
Errors
Building an
Online Store
Useful WordPress Guides
    • 7 Best WordPress Backup Plugins Compared (Pros and Cons)
    • How to Fix the Error Establishing a Database Connection in WordPress
    • Why You Need a CDN for your WordPress Blog? [Infographic]
    • 30 Legit Ways to Make Money Online Blogging with WordPress
    • Self Hosted WordPress.org vs. Free WordPress.com [Infograph]
    • Free Recording: WordPress Workshop for Beginners
    • 24 Must Have WordPress Plugins for Business Websites
    • How to Properly Move Your Blog from WordPress.com to WordPress.org
    • 5 Best Contact Form Plugins for WordPress Compared
    • Which is the Best WordPress Popup Plugin? (Comparison)
    • Best WooCommerce Hosting in 2021 (Comparison)
    • How to Fix the Internal Server Error in WordPress
    • How to Install WordPress - Complete WordPress Installation Tutorial
    • Why You Should Start Building an Email List Right Away
    • How to Properly Move WordPress to a New Domain Without Losing SEO
    • How to Choose the Best WordPress Hosting for Your Website
    • How to Choose the Best Blogging Platform (Comparison)
    • WordPress Tutorials - 200+ Step by Step WordPress Tutorials
    • 5 Best WordPress Ecommerce Plugins Compared
    • 5 Best WordPress Membership Plugins (Compared)
    • 7 Best Email Marketing Services for Small Business (2021)
    • How to Choose the Best Domain Registrar (Compared)
    • The Truth About Shared WordPress Web Hosting
    • When Do You Really Need Managed WordPress Hosting?
    • 5 Best Drag and Drop WordPress Page Builders Compared
    • How to Switch from Blogger to WordPress without Losing Google Rankings
    • How to Properly Switch From Wix to WordPress (Step by Step)
    • How to Properly Move from Weebly to WordPress (Step by Step)
    • Do You Really Need a VPS? Best WordPress VPS Hosting Compared
    • How to Properly Move from Squarespace to WordPress
    • How to Register a Domain Name (+ tip to get it for FREE)
    • HostGator Review - An Honest Look at Speed & Uptime (2021)
    • SiteGround Reviews from 4464 Users & Our Experts (2021)
    • Bluehost Review from Real Users + Performance Stats (2021)
    • How Much Does It Really Cost to Build a WordPress Website?
    • How to Create an Email Newsletter the RIGHT WAY (Step by Step)
    • Free Business Name Generator (A.I Powered)
    • How to Create a Free Business Email Address in 5 Minutes (Step by Step)
    • How to Install Google Analytics in WordPress for Beginners
    • How to Move WordPress to a New Host or Server With No Downtime
    • Why is WordPress Free? What are the Costs? What is the Catch?
    • How to Make a Website in 2021 – Step by Step Guide
Deals & Coupons (view all)
LiveChat logo
LiveChat Inc Coupon
Get a 30 day free trial and 30% OFF LiveChat, one of the best live chat service providers for WordPress users.
LearnDash
LearnDash Coupon
Get the lowest price on the best learning management system (LMS) plugin for WordPress.
Featured In
About WPBeginner®

WPBeginner is a free WordPress resource site for Beginners. WPBeginner was founded in July 2009 by Syed Balkhi. The main goal of this site is to provide quality tips, tricks, hacks, and other WordPress resources that allows WordPress beginners to improve their site(s).

Join our team: We are Hiring!

Site Links
  • About Us
  • Contact Us
  • FTC Disclosure
  • Privacy Policy
  • Terms of Service
  • Free Blog Setup
  • Free Business Tools
  • Growth Fund
Our Sites
  • OptinMonster
  • MonsterInsights
  • WPForms
  • SeedProd
  • Nameboy
  • RafflePress
  • Smash Balloon
  • AIOSEO

Copyright © 2009 - 2021 WPBeginner LLC. All Rights Reserved. WPBeginner® is a registered trademark.

Managed by Awesome Motive | WordPress hosting by SiteGround | WordPress Security by Sucuri.