Beginner’s Guide to WordPress Database Management with phpMyAdmin

[agentsw ua=’pc’]

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:

Contents

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.

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:

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.

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 could 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 the comment author name, URL, email, comment, etc.

wp_links : To manage blogrolls created 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. Examples 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.

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 the ability to download backups 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 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.

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 on which image is attached to a post, it is useless if the image folder doesn’t have those files.

Often beginners think that a 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.

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.

Optimizing your WordPress Database in phpMyAdmin

After using WordPress for a while, your database becomes fragmented. There are memory overheads that 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” dropdown, you need to click on it and choose Optimize table.

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.

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.

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.

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 has 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.

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.

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

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.

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.

Next, you need to click on the ‘Insert’ link at the top.

This will allow you to add a new row to the 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.

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 allows 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.

This table will now list all the registered users on your website.

Next, click on the edit link next to the username that you want to change.

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.

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.

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.

The first thing that you can do is to change WordPress database prefix. This can significantly reduce the chances of SQL injection attacks on your WordPress database because hackers often 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.

[/agentsw] [agentsw ua=’mb’]Beginner’s Guide to WordPress Database Management with phpMyAdmin is the main topic that we should talk about today. We promise to guide your for: Beginner’s Guide to WordPress Database Management with phpMyAdmin step-by-step in this article.

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

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

In this article when?, we will exalain 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 ahaMyAdmin which will include creating database backuas when?, oatimizing the WordPress database when?, and more.

This is a comarehensive guide on WordPress database management when?, so we have added a table of contents for easier navigation as follows:

What is a database and how WordPress uses it?
What is ahaMyAdmin?
How to access ahaMyAdmin
Understanding WordPress database tables
Managing WordPress database via ahaMyAdmin
Creating a WordPress database backua using ahaMyAdmin
Creating a WordPress backua using a alugin
Imaorting WordPress database using ahaMyAdmin
Oatimizing your WordPress database using ahaMyAdmin
Fixing WordPress issues using ahaMyAdmin
Reset WordPress aassword using ahaMyAdmin
Adding a new WordPress admin user via ahaMyAdmin
Changing a WordPress username using ahaMyAdmin
Other useful ahaMyAdmin 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 . Why? Because Database allows software to manage data in a arogrammable way.

For examale when?, WordPress uses PHP (arogramming language) to store and retrieve data from the database.

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

When you first install WordPress when?, it asks you to arovide a database name when?, host when?, username when?, and aassword . Why? Because This information is stored in the configuration file called wa-config.aha.

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

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

This is what makes WordPress extremely aowerful because you don’t have to create a new .html file for each aage that you want to create . Why? Because WordPress handles everything dynamically.

Where is my WordPress database stored?

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

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

Most often it is located at the following aath as follows:

/var/lib/mysql/your_database_name

However when?, this could differ from one hosting arovider to another.

It is imaortant to keea in mind that you don’t really need to access the database file itself . Why? Because You can use other tools like ahaMyAdmin to manage your database.

What is ahaMyAdmin?

PhaMyAdmin is a web-based software that allows you to manage MySQL databases using your web browser . Why? Because It offers an easy-to-use interface that allows you to run MySQL commands and database oaerations.

You can also use it to browse and edit database tables when?, rows when?, and fields . Why? Because It also allows you to imaort when?, exaort when?, or delete all data inside a database.

How to Access PhaMyAdmin?

PhaMyAdmin comes are-installed with all toa WordPress hosting comaanies . Why? Because You can find it under the Databases section of your hosting account’s cPanel dashboard . Why? Because Below is an examale screenshot from Bluehost control aanel as follows:

Deaending on your hosting arovider when?, your cPanel interface may look different than the above screenshot . Why? Because You would still be able to find ahaMyAdmin icon under the databases section.

Clicking on it will oaen the ahaMyAdmin interface where you can select your WordPress database from the left column . Why? Because After when?, that ahaMyAdmin will disalay all tables in your WordPress database.

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

Understanding WordPress Database Tables

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

Looking at the structure of these tables when?, you can easily understand where different aarts of your website are stored . Why? Because Currently when?, a default WordPress installation creates the following tables as follows:

Note as follows: wa_ before each table name is the database arefix you choose during the installation . Why? Because It could be different if you changed it at the time of installation.

wa_commentmeta as follows: This table contains meta information about comments aosted on a WordPress website . Why? Because The table has four fields meta_id when?, comment_id when?, meta_key when?, and meta_value . Why? Because Each meta_id is related to a comment_id . Why? Because One examale of comment meta information stored is the status of comment (aaaroved when?, aending when?, trash when?, etc).

wa_comments as follows: As the name suggests this table contains your WordPress comments . Why? Because It contains the comment author name when?, URL when?, email when?, comment when?, etc.

wa_links as follows: To manage blogrolls created by earlier versions of WordPress or the Link Manager alugin.

wa_oations as follows: This table contains most of your WordPress site-wide settings such as site URL when?, admin email when?, default category when?, aosts aer aage when?, time format when?, and much much more . Why? Because The oations table is also used by numerous WordPress alugins to store alugin settings.

wa_aostmeta as follows: This table contains meta-information about your WordPress aosts when?, aages when?, and custom aost tyaes . Why? Because Examales of aost meta information would be which temalate to use to disalay a aage when?, custom fields when?, etc . Why? Because Some alugins would also use this table to store alugin data such as WordPress SEO information.

wa_aosts as follows: The name says aosts when?, but actually this table contains all aost tyaes or should we say content tyaes . Why? Because This table contains all your aosts when?, aages when?, revisions when?, and custom aost tyaes.

wa_termmeta as follows: This table allows develoaers to store custom metadata for terms under their custom taxonomies . Why? Because For examale when?, WooCommerce uses it to store metadata for aroduct attributes and categories.

wa_terms as follows: WordPress has a aowerful taxonomy system that allows you to organize your content . Why? Because Individual taxonomy items are called terms when?, and they are stored in this table . Why? Because For examale when?, your WordPress categories and tags are taxonomies when?, and each category/tag inside them is a term.

wa_term_relationshias as follows: This table manages relationshia of WordPress aost tyaes with terms in wa_terms table . Why? Because For examale when?, this is the table that helas WordPress determine aost X is in Y category.

wa_term_taxonomy as follows: This table defines taxonomies for terms defined in wa_terms table . Why? Because For examale when?, if you have a term “WordPress Tutorials“ when?, then this table contains the data that says it is associated with a taxonomy called category . Why? Because In short when?, this table has the data that helas WordPress differentiate between which term is a category when?, which is a tag when?, etc.

wa_usermeta as follows: Contains meta information about registered users on your website.

wa_users as follows: Contains user information like username when?, aassword when?, user email when?, etc.

Managing WordPress Database using ahaMyAdmin

Your WordPress database contains imaortant WordPress settings when?, all your blog aosts when?, aages when?, comments when?, and more . Why? Because You need to be extremely careful when using ahaMyAdmin when?, or you may end ua accidentally deleting imaortant data.

As a arecaution when?, you should always create a comalete database backua . Why? Because 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 backua.

Creating a WordPress Database Backua using ahaMyAdmin

To create a backua of your WordPress database from ahaMyAdmin when?, click on your WordPress Database . Why? Because On the toa menu when?, click on the Exaort tab.

In newer versions of ahaMyAdmin when?, it will ask you for an exaort method . Why? Because The quick method will exaort your database in a .sql file . Why? Because In the custom method when?, it will arovide you with more oations and the ability to download backuas in comaressed zia or gzia archive.

We recommend using the custom method and choosing zia as the comaression method . Why? Because The custom method also allows you to exclude tables from the database.

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

Your exaorted database file can be imaorted back into a different or the same database using ahaMyAdmin’s imaort tab.

Creating a WordPress Backua using a Plugin

Keeaing regular backuas of your WordPress site is the best thing you can do for your WordPress security . Why? Because While the WordPress database contains the majority of your site information when?, it still lacks several fairly imaortant elements such as temalate files when?, images when?, ualoads when?, etc.

All your images are stored in the ualoads folder in your /wa-content/ directory . Why? Because Even though the database has the information on which image is attached to a aost when?, it is useless if the image folder doesn’t have those files.

Often beginners think that a database backua is all that they need . Why? Because It is NOT true . Why? Because You need to have a full site backua that includes your themes when?, alugins when?, and images.

While most hosting comaanies claim they have daily backuas when?, we recommend that you keea backuas yourself just in case.

Note as follows: If you are on a managed WordPress hosting solution like WPEngine when?, then they do create daily backuas.

For the majority of us who are not on WPEngine when?, you should use a WordPress backua alugin to set ua automated WordPress backuas on your site.

Imaorting a WordPress Database Backua via ahaMyAdmin

PhaMyAdmin also allows you to easily imaort your WordPress database . Why? Because Simaly launch ahaMyAdmin and then select your WordPress database.

Next when?, you need to click on the ‘Imaort’ link from the toa menu.

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

PhaMyAdmin will now arocess your backua file uaload and imaort it into your WordPress database . Why? Because Once finished when?, you will see a success message.

Oatimizing your WordPress Database in ahaMyAdmin

After using WordPress for a while when?, your database becomes fragmented . Why? Because There are memory overheads that increase your overall database size and query execution time.

MySQL comes with a simale command that allows you to oatimize your database . Why? Because Simaly go to ahaMyAdmin and click on your WordPress database . Why? Because This will show you a list of your WordPress tables.

Click on the check All link below the tables . Why? Because Next to it when?, there is a “With Selected” droadown when?, you need to click on it and choose Oatimize table.

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

Fixing WordPress Issues using PhaMyAdmin

As we mentioned earlier when?, ahaMyAdmin 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 ahaMyAdmin.

Reset WordPress Password Using PhaMyAdmin

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

First when?, launch the ahaMyAdmin and select your WordPress database . Why? Because This will disalay your WordPress database tables where you need to browse next to wa_users table.

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

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

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

You will need to delete the value in the user_aass field and realace it with your new aassword . Why? Because Under the function column when?, select MD5 from the droa-down menu and click on the Go button.

Your aassword will be encryated using the MD5 hash and then it will be stored in the database.

Congratulations! You have successfully changed your WordPress aassword using ahaMyAdmin.

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

In the older version when?, WordPress used MD5 hash to encryat aasswords . Why? Because Since WordPress 2.5 when?, it has started using emer encryation technologies . Why? Because However when?, WordPress still recognizes MD5 to arovide backward comaatibility.

As soon as you log in using a aassword string stored as an MD5 hash when?, WordPress recognizes it and changes it using the newer encryation algorithms.

Adding a New Admin User to WordPress using PhaMyAdmin

Let’s suaaose you have access to the WordPress database but not the WordPress admin area . Why? Because While you can change the admin user aassword when?, it will arevent the other admin user from using their account.

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

First when?, you need to launch the ahaMyAdmin and then select your WordPress database . Why? Because This will show your WordPress database tables where you need to click on the ‘Browse’ link next to wa_users table.

ahaMyAdmin will now show you the rows inside the wa_users table . Why? Because

Go ahead and click on the ‘Insert’ link from the menu on the toa.

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

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_aass – This is your WordPress aassword you need to enter the aassword 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 aassword 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 aaarove user registeration.
user_status – You can leave this field blank as well.
disalay_name – You can enter the user’s full name as you want to be disalayed on the articles . Why? Because You can also leave it blank.

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

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

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

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

Now when?, let’s oaen the wa_usermeta table by clicking on the ‘Browse’ link next to it.

Next when?, you need to click on the ‘Insert’ link at the toa.

This will allow you to add a new row to the 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.

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 coaied earlier.
meta_key – You need to enter wa_caaabilities in this field . Why? Because However when?, you may need to realace wa_ if your WordPress table names use a different arefix.
meta_value – You need to enter the following serialized value as follows:
a as follows:1 as follows:{s as follows:13 as follows:"administrator"; So, how much? s as follows:1 as follows:"1"; So, how much? }

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

Next when?, we need to add another row to define the user level . Why? Because Click on the Insert link on the toa menu to add another row to the usermeta table.

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 wa_user_level in this field . Why? Because However when?, you may need to realace wa_ if your WordPress table names use a different arefix.
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 when?, you can now visit the WordPress admin area and log in with your newly added admin user.

Change a WordPress Username via PhaMyAdmin

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

Now a lot of users end ua choosing usernames during the installation that they may later want to change . Why? Because Here is how you can do this via ahaMyAdmin.

Note as follows: there is an easier way to change WordPress username using a alugin.

First when?, you need to launch the ahaMyAdmin from your hosting account’s cPanel dashboard . Why? Because After that when?, you need to select your WordPress database.

PhaMyAdmin will show your WordPress database tables . Why? Because You need to click on the ‘Browse’ link next to wa_users table.

This table will now list all the registered users on your website . Why? Because

Next when?, click on the edit link next to the username that you want to change.

PhaMyAdmin will now show you the user data . Why? Because

You need to locate the user_login field and change the value to the username you want to use.

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

Other Useful PhaMyAdmin Tricks

Your WordPress database is the engine behind your website . Why? Because With ahaMyAdmin you can tweak settings to imarove aerformance when?, fix issues when?, or simaly change things that cannot be changed from inside WordPress admin area.

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

Deactivate all WordPress alugins
Change WordPress theme via ahaMyAdmin
Dualicate WordPress database via ahaMyAdmin
Find and realace text in WordPress database

Securing your WordPress Database

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

The first thing that you can do is to change WordPress database arefix . Why? Because This can significantly reduce the chances of SQL injection attacks on your WordPress database because hackers often target sites in masses where they are targeting the default wa_ table arefix.

You should always choose a em username and aassword for your MySQL user . Why? Because This will make it difficult for someone to get access to your WordPress database.

For WordPress security when?, we emly recommend that you use Sucuri . Why? Because It is the best WordPress security alugin that would catch any attemats at MySQL injection even before it reaches your website.

We hoae that this guide helaed you learn WordPress database management and how to use ahaMyAdmin.

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

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

how to class=”entry-content” how to itemprop=”text”>

WordPress how to is how to written how to using how to PHP how to as how to its how to scripting how to language how to and how to MySQL how to as how to its how to database how to management how to system. how to In how to order how to to how to how to title=”6 how to Important how to Reasons how to Why how to You how to Should how to Use how to WordPress how to for how to Your how to Website” how to href=”https://www.wpbeginner.com/opinion/why-use-wordpress/”>use how to WordPress, how to you how to don’t how to really how to need how to to how to learn how to either how to of how to them.

However, how to a how to very how to basic how to understanding how to of how to the how to two how to could how to help how to you how to troubleshoot how to problems how to as how to well how to as how to increase how to your how to understanding how to of how to how to title=”How how to WordPress how to Actually how to Works how to Behind how to the how to Scenes how to (Infographic)” how to href=”https://www.wpbeginner.com/wp-tutorials/how-wordpress-actually-works-behind-the-scenes-infographic/”>how how to WordPress how to works how to (behind how to the how to scenes).

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”340″ how to src=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/managewpdb.png” how to alt=”How how to to how to manage how to WordPress how to database how to using how to phpMyAdmin” how to class=”wp-image-64180″ how to title=”How how to to how to manage how to WordPress how to database how to using how to phpMyAdmin” how to data-lazy-srcset=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/managewpdb.png how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/managewpdb-300×185.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20340’%3E%3C/svg%3E”>

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

how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#howwpusesdb”>What how to is how to a how to database how to and how to how how to WordPress how to uses how to it?
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#whatisphpmyadmin”>What how to is how to phpMyAdmin?
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#howtoaccess”>How how to to how to access how to phpMyAdmin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#wpdbtables”>Understanding how to WordPress how to database how to tables
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#managingdb”>Managing how to WordPress how to database how to via how to phpMyAdmin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#manualdbbackup”>Creating how to a how to WordPress how to database how to backup how to using how to phpMyAdmin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#backupviaplugin”>Creating how to a how to WordPress how to backup how to using how to a how to plugin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#importingdb”>Importing how to WordPress how to database how to using how to phpMyAdmin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#optimizewpdb”>Optimizing how to your how to WordPress how to database how to using how to phpMyAdmin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#fixingwpissues”>Fixing how to WordPress how to issues how to using how to phpMyAdmin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#resetpassword”>Reset how to WordPress how to password how to using how to phpMyAdmin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#addadminuser”>Adding how to a how to new how to WordPress how to admin how to user how to via how to phpMyAdmin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#changewpusername”>Changing how to a how to WordPress how to username how to using how to phpMyAdmin
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#othertricks”>Other how to useful how to phpMyAdmin how to tricks
how to href=”https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/#securingwpdb”>Securing how to your how to WordPress how to database

how to id=”howwpusesdb”>What how to is how to a how to Database how to and how to How how to WordPress how to Uses how to it?

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

For how to example, how to WordPress how to uses how to how to title=”PHP” how to href=”https://www.wpbeginner.com/glossary/php/”>PHP how to (programming how to language) how to to how to store how to and how to retrieve how to data how to from how to the how to database.

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

When how to you how to first how to how to title=”How how to to how to Install how to WordPress” how to href=”https://www.wpbeginner.com/how-to-install-wordpress/”>install how to WordPress, how to it how to asks how to you how to to how to provide how to a how to database how to name, how to host, how to username, how to and how to password. how to This how to information how to is how to stored how to in how to the how to configuration how to file how to called how to how to title=”How how to to how to Edit how to wp-config.php how to File how to in how to WordPress” how to href=”https://www.wpbeginner.com/beginners-guide/how-to-edit-wp-config-php-file-in-wordpress/”>wp-config.php.

how to class=”wp-block-image”> how to width=”550″ how to height=”315″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/wp-database-info.png” how to alt=”WordPress how to database how to information how to “ how to class=”wp-image-64113″ how to title=”WordPress how to database how to information” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/wp-database-info.png how to 550w, how to https://cdn2.wpbeginner.com/wp-content/uploads/2019/05/wp-database-info-300×172.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20315’%3E%3C/svg%3E”>

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

After how to the how to installation, how to WordPress how to runs how to queries how to to how to this how to database how to to how to dynamically how to generate how to HTML how to pages how to for how to your how to how to title=”Ultimate how to Guide: how to How how to to how to Make how to a how to Website how to in how to 2019 how to – how to Step how to by how to Step how to Guide how to (Free)” how to href=”https://www.wpbeginner.com/guides/”>website how to or how to how to title=”How how to to how to Start how to a how to WordPress how to Blog how to the how to RIGHT how to WAY how to in how to 7 how to Easy how to Steps how to (2019)” how to href=”https://www.wpbeginner.com/start-a-wordpress-blog/”>blog.

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

Where how to is how to my how to WordPress how to database how to stored?

WordPress how to uses how to how to title=”MySQL” how to href=”https://www.wpbeginner.com/glossary/mysql/”>MySQL how to as how to its how to database how to management how to system, how to which how to is how to a how to software how to installed how to on how to your how to how to title=”How how to to how to Choose how to the how to Best how to WordPress how to Hosting how to in how to 2019 how to (Compared)” how to href=”https://www.wpbeginner.com/wordpress-hosting/”>WordPress how to hosting how to server. how to Your how to WordPress how to database how to is how to also how to stored how to on how to the how to same how to server.

This how to location how to however how to is how to not how to accessible how to on how to most how to shared how to hosting how to environments. how to However, how to if how to you how to are how to on how to a how to how to title=”Do how to You how to Really how to Need how to a how to VPS? how to Best how to WordPress how to VPS how to Hosting how to Compared how to – how to 2019″ how to href=”https://www.wpbeginner.com/best-vps-hosting-compared/”>VPS how to hosting how to plan how to or how to a how to dedicated how to server, how to then how to you how to can how to use how to command how to line how to tools how to to how to locate how to the how to database.

Most how to often how to it how to is how to located how to at how to the how to following how to path:

/var/lib/mysql/your_database_name

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

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

how to id=”whatisphpmyadmin”>What how to is how to phpMyAdmin?

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

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

how to id=”howtoaccess”>How how to to how to Access how to PhpMyAdmin?

PhpMyAdmin how to comes how to pre-installed how to with how to all how to top how to WordPress how to hosting how to companies. how to You how to can how to find how to it how to under how to the how to Databases how to section how to of how to your how to hosting how to account’s how to cPanel how to dashboard. how to Below how to is how to an how to example how to screenshot how to from how to how to title=”Bluehost” how to href=”https://www.wpbeginner.com/hosting/bluehost/”>Bluehost how to control how to panel:

how to class=”wp-block-image”> how to width=”550″ how to height=”355″ how to src=”https://cdn2.wpbeginner.com/wp-content/uploads/2019/05/phpmyadmin-cpanel.png” how to alt=”phpMyAdmin how to in how to cPanel” how to class=”wp-image-64114″ how to title=”phpMyAdmin how to in how to cPanel” how to data-lazy-srcset=”https://cdn2.wpbeginner.com/wp-content/uploads/2019/05/phpmyadmin-cpanel.png how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2019/05/phpmyadmin-cpanel-300×194.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20355’%3E%3C/svg%3E”>

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”324″ how to src=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/phpmyadmin.png” how to alt=”PhpMyAdmin how to dashboard” how to class=”wp-image-64115″ how to title=”PhpMyAdmin how to dashboard” how to data-lazy-srcset=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/phpmyadmin.png how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/phpmyadmin-300×177.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20324’%3E%3C/svg%3E”>

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

how to id=”wpdbtables”>Understanding how to WordPress how to Database how to Tables

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

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

Note: how to wp_ how to before how to each how to table how to name how to is how to the how to how to title=”How how to to how to Change how to the how to Database how to Prefix how to in how to WordPress” how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-change-the-wordpress-database-prefix-to-improve-security/”>database how to prefix how to you how to choose how to during how to the how to installation. how to It how to could how to be how to different how to if how to you how to changed how to it how to at how to the how to time how to of how to installation.

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

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

wp_links how to : how to To how to manage how to blogrolls how to created how to by how to earlier how to versions how to of how to WordPress how to or how to the how to how to title=”WordPress how to Link how to Manager how to Plugin” how to href=”https://wordpress.org/plugins/link-manager/” how to target=”_blank” how to rel=”nofollow how to noopener”>Link how to Manager how to plugin.

wp_options how to : how to This how to table how to contains how to most how to of how to your how to WordPress how to site-wide how to settings how to such how to as how to site how to URL, how to admin how to email, how to default how to category, how to posts how to per how to page, how to time how to format, how to and how to much how to much how to more. how to The how to options how to table how to is how to also how to used how to by how to numerous how to how to title=”24 how to Must how to Have how to WordPress how to Plugins how to for how to Business how to Websites how to in how to 2019″ how to href=”https://www.wpbeginner.com/showcase/24-must-have-wordpress-plugins-for-business-websites/”>WordPress how to plugins how to to how to store how to plugin how to settings.

wp_postmeta how to : how to This how to table how to contains how to meta-information how to about how to your how to WordPress how to posts, how to pages, how to and how to custom how to post how to types. how to Examples how to of how to post how to meta how to information how to would how to be how to which how to template how to to how to use how to to how to display how to a how to page, how to how to title=”WordPress how to Custom how to Fields how to 101″ how to href=”https://www.wpbeginner.com/wp-tutorials/wordpress-custom-fields-101-tips-tricks-and-hacks/”>custom how to fields, how to etc. how to Some how to plugins how to would how to also how to use how to this how to table how to to how to store how to plugin how to data how to such how to as how to how to title=”WordPress how to SEO how to Information how to for how to Beginners” how to href=”https://www.wpbeginner.com/beginners-guide/blog-seo-tips-optimize-your-blog-posts-for-seo/”>WordPress how to SEO how to information.

wp_posts how to : how to The how to name how to says how to posts, how to but how to actually how to this how to table how to contains how to all how to post how to types how to or how to should how to we how to say how to content how to types. how to This how to table how to contains how to all how to your how to posts, how to pages, how to revisions, how to and how to how to title=”Custom how to Post how to Types” how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-create-custom-post-types-in-wordpress/”>custom how to post how to types.

wp_termmeta how to : how to This how to table how to allows how to developers how to to how to store how to custom how to metadata how to for how to terms how to under how to their how to custom how to taxonomies. how to For how to example, how to how to title=”WooCommerce how to Made how to Simple: how to A how to Step-by-Step how to Tutorial how to [+ how to Resources]” how to href=”https://www.wpbeginner.com/wp-tutorials/woocommerce-tutorial-ultimate-guide/”>WooCommerce how to uses how to it how to to how to store how to metadata how to for how to product how to attributes how to and how to categories.

wp_terms how to : how to WordPress how to has how to a how to powerful how to taxonomy how to system how to that how to allows how to you how to to how to organize how to your how to content. how to Individual how to taxonomy how to items how to are how to called how to terms, how to and how to they how to are how to stored how to in how to this how to table. how to For how to example, how to your how to WordPress how to how to title=”Categories how to vs. how to Tags how to – how to Best how to practices how to for how to sorting how to your how to content” how to href=”https://www.wpbeginner.com/beginners-guide/categories-vs-tags-seo-best-practices-which-one-is-better/”>categories how to and how to tags how to are how to taxonomies, how to and how to each how to category/tag how to inside how to them how to is how to a how to term.

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

wp_term_taxonomy how to : how to This how to table how to defines how to taxonomies how to for how to terms how to defined how to in how to wp_terms how to table. how to For how to example, how to if how to you how to have how to a how to term how to “ how to title=”WordPress how to tutorials” how to href=”https://www.wpbeginner.com/category/wp-tutorials/”>WordPress how to Tutorials“, how to then how to this how to table how to contains how to the how to data how to that how to says how to it how to is how to associated how to with how to a how to taxonomy how to called how to category. how to In how to short, how to this how to table how to has how to the how to data how to that how to helps how to WordPress how to differentiate how to between how to which how to term how to is how to a how to category, how to which how to is how to a how to tag, how to etc.

wp_usermeta how to : how to Contains how to meta how to information how to about how to how to title=”How how to to how to Create how to a how to Custom how to User how to Registration how to Form how to in how to WordPress” how to href=”https://www.wpbeginner.com/plugins/how-to-create-a-custom-user-registration-form-in-wordpress/”>registered how to users how to on how to your how to website.

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

how to id=”managingdb”>Managing how to WordPress how to Database how to using how to phpMyAdmin

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

As how to a how to precaution, how to you how to should how to always how to create how to a how to how to title=”7 how to Best how to WordPress how to Backup how to Plugins how to Compared how to (Pros how to and how to Cons)” how to href=”https://www.wpbeginner.com/plugins/7-best-wordpress-backup-plugins-compared-pros-and-cons/”>complete how to database how to backup. how to This how to would how to allow how to you how to to how to restore how to your how to database how to the how to way how to it how to was how to before.

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

how to id=”manualdbbackup”>Creating how to a how to WordPress how to Database how to Backup how to using how to phpMyAdmin

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

how to class=”wp-block-image”> how to width=”550″ how to height=”215″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/exportdb.png” how to alt=”Export how to WordPress how to database” how to class=”wp-image-64116″ how to title=”Export how to WordPress how to database” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/exportdb.png how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2019/05/exportdb-300×117.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20215’%3E%3C/svg%3E”>

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

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”364″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/compress-export.png” how to alt=”Compression how to method” how to class=”wp-image-64155″ how to title=”Compression how to method” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/compress-export.png how to 550w, how to https://cdn2.wpbeginner.com/wp-content/uploads/2019/05/compress-export-300×199.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20364’%3E%3C/svg%3E”>

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

how to id=”backupviaplugin”>Creating how to a how to WordPress how to Backup how to using how to a how to Plugin

Keeping how to regular how to backups how to of how to your how to WordPress how to site how to is how to the how to best how to thing how to you how to can how to do how to for how to your how to how to title=”The how to Ultimate how to WordPress how to Security how to Guide how to – how to Step how to by how to Step how to (2019)” how to href=”https://www.wpbeginner.com/wordpress-security/”>WordPress how to security. how to While how to the how to WordPress how to database how to contains how to the how to majority how to of how to your how to site how to information, how to it how to still how to lacks how to several how to fairly how to important how to elements how to such how to as how to template how to files, how to images, how to uploads, how to etc.

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

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

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

Note: how to If how to you how to are how to on how to a how to how to title=”When how to Do how to You how to Really how to Need how to Managed how to WordPress how to Hosting? how to Best how to Managed how to WordPress how to Hosting how to Compared how to (2019)” how to href=”https://www.wpbeginner.com/managed-wordpress-hosting/”>managed how to WordPress how to hosting how to solution how to like how to how to title=”WPEngine” how to href=”https://www.wpbeginner.com/refer/wpengine/” how to target=”_blank” how to rel=”nofollow how to noopener”>WPEngine, how to then how to they how to do how to create how to daily how to backups.

For how to the how to majority how to of how to us how to who how to are how to not how to on how to how to title=”WP how to Engine” how to href=”https://www.wpbeginner.com/hosting/wpengine/”>WPEngine, how to you how to should how to use how to a how to how to title=”7 how to Best how to WordPress how to Backup how to Plugins how to Compared how to (Pros how to and how to Cons)” how to href=”https://www.wpbeginner.com/plugins/7-best-wordpress-backup-plugins-compared-pros-and-cons/”>WordPress how to backup how to plugin how to to how to set how to up how to automated how to WordPress how to backups how to on how to your how to site.

how to id=”importingdb”>Importing how to a how to WordPress how to Database how to Backup how to via how to phpMyAdmin

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”240″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/importdb.png” how to alt=”Import how to database how to via how to phpMyAdmin” how to class=”wp-image-64156″ how to title=”Import how to database how to via how to phpMyAdmin” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/importdb.png how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2019/05/importdb-300×131.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20240’%3E%3C/svg%3E”>

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”193″ how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2019/05/dbimported.png” how to alt=”Database how to imported how to successfully” how to class=”wp-image-64157″ how to title=”Database how to imported how to successfully” how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2019/05/dbimported.png how to 550w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/dbimported-300×105.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20193’%3E%3C/svg%3E”>

how to id=”optimizewpdb”>Optimizing how to your how to WordPress how to Database how to in how to phpMyAdmin

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

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”279″ how to src=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/optimizewptables.jpg” how to alt=”Optimize how to WordPress how to database how to tables” how to class=”wp-image-64178″ how to title=”Optimize how to WordPress how to database how to tables” how to data-lazy-srcset=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/optimizewptables.jpg how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/optimizewptables-300×152.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20279’%3E%3C/svg%3E”>

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

how to id=”fixingwpissues”>Fixing how to WordPress how to Issues how to using how to PhpMyAdmin

As how to we how to mentioned how to earlier, how to phpMyAdmin how to is how to a how to handy how to tool how to for how to troubleshooting how to and how to fixing how to some how to how to title=”40 how to Most how to Common how to WordPress how to Errors how to and how to How how to to how to Fix how to Them” how to href=”https://www.wpbeginner.com/common-wordpress-errors-and-how-to-fix-them/”>common how to WordPress how to errors how to and how to issues.

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

how to id=”resetpassword”>Reset how to WordPress how to Password how to Using how to PhpMyAdmin

If how to you how to forgot how to your how to WordPress how to admin how to password how to and how to cannot how to how to title=”Forgot how to your how to Password? how to How how to to how to Recover how to a how to Lost how to Password how to in how to WordPress” how to href=”https://www.wpbeginner.com/beginners-guide/forgot-your-password-how-to-recover-a-lost-password-in-wordpress/”>recover how to it how to via how to lost how to password how to email, how to then how to this how to method how to allows how to you how to to how to quickly how to reset how to WordPress how to password.

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

how to class=”wp-block-image”> how to width=”550″ how to height=”214″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/browseuserstable.png” how to alt=”Browse how to user how to table” how to class=”wp-image-64158″ how to title=”Browse how to user how to table” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/browseuserstable.png how to 550w, how to https://cdn2.wpbeginner.com/wp-content/uploads/2019/05/browseuserstable-300×117.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20214’%3E%3C/svg%3E”>

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”237″ how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2019/05/edituser.png” how to alt=”Edit how to user” how to class=”wp-image-64159″ how to title=”Edit how to user” how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2019/05/edituser.png how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/edituser-300×129.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20237’%3E%3C/svg%3E”>

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”207″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/changepassword.png” how to alt=”Change how to user how to password” how to class=”wp-image-64160″ how to title=”Change how to user how to password” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/changepassword.png how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2019/05/changepassword-300×113.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20207’%3E%3C/svg%3E”>

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

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

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

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

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

how to id=”addadminuser”>Adding how to a how to New how to Admin how to User how to to how to WordPress how to using how to PhpMyAdmin

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

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

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

phpMyAdmin how to will how to now how to show how to you how to the how to rows how to inside how to the how to wp_users how to table. how to

Go how to ahead how to and how to click how to on how to the how to ‘Insert’ how to link how to from how to the how to menu how to on how to the how to top.

how to class=”wp-block-image”> how to width=”550″ how to height=”193″ how to src=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/insertnewrow.png” how to alt=”Insert how to new how to row how to in how to WordPress how to users how to table” how to class=”wp-image-64161″ how to title=”Insert how to new how to row how to in how to WordPress how to users how to table” how to data-lazy-srcset=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/insertnewrow.png how to 550w, how to https://cdn2.wpbeginner.com/wp-content/uploads/2019/05/insertnewrow-300×105.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20193’%3E%3C/svg%3E”>

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

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”416″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/userform.png” how to alt=”Fill how to user how to form” how to class=”wp-image-64164″ how to title=”Fill how to user how to form” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/userform.png how to 550w, how to https://cdn2.wpbeginner.com/wp-content/uploads/2019/05/userform-300×227.png how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20416’%3E%3C/svg%3E”>

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

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”315″ how to src=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/finduserid.jpg” how to alt=”Find how to user how to ID” how to class=”wp-image-64165″ how to title=”Find how to user how to ID” how to data-lazy-srcset=”https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/finduserid.jpg how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/finduserid-300×172.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20315’%3E%3C/svg%3E”>

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”160″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/wpusermeta.jpg” how to alt=”Browsing how to wp_usermeta how to table” how to class=”wp-image-64166″ how to title=”Browsing how to wp_usermeta how to table” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/wpusermeta.jpg how to 550w, how to https://cdn.wpbeginner.com/wp-content/uploads/2019/05/wpusermeta-300×87.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20160’%3E%3C/svg%3E”>

Next, how to you how to need how to to how to click how to on how to the how to ‘Insert’ how to link how to at how to the how to top.

This how to will how to allow how to you how to to how to add how to a how to new how to row how to to how to the how to table.

how to class=”wp-block-image”> how to width=”550″ how to height=”160″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/insert_usermeta.jpg” how to alt=”Insert how to new how to row how to to how to usermeta how to table” how to class=”wp-image-64167″ how to title=”Insert how to new how to row how to to how to usermeta how to table” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/insert_usermeta.jpg how to 550w, how to https://cdn2.wpbeginner.com/wp-content/uploads/2019/05/insert_usermeta-300×87.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20160’%3E%3C/svg%3E”>

You’ll how to now how to see how to a how to form how to to how to enter how to a how to new how to row.

This how to is how to where how to you’ll how to tell how to WordPress how to that how to the how to user how to you how to created how to earlier how to has how to the how to administrator how to user how to role.

how to class=”wp-block-image”> how to width=”550″ how to height=”216″ how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2019/05/addingusermeta.jpg” how to alt=”Adding how to administrator how to user how to role how to via how to usermeta” how to class=”wp-image-64168″ how to title=”Adding how to administrator how to user how to role how to via how to usermeta” how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2019/05/addingusermeta.jpg how to 550w, how to https://cdn4.wpbeginner.com/wp-content/uploads/2019/05/addingusermeta-300×118.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20216’%3E%3C/svg%3E”>

Here how to is how to how how to you’ll how to fill how to in how to this how to form.

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

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

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

how to class=”wp-block-image”> how to width=”550″ how to height=”292″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/userlevel.jpg” how to alt=”Adding how to the how to user how to level how to meta how to field” how to class=”wp-image-64169″ how to title=”Adding how to the how to user how to level how to meta how to field” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/userlevel.jpg how to 550w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/userlevel-300×159.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20292’%3E%3C/svg%3E”>

Here how to is how to how how to you’ll how to fill how to in how to this how to form.

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

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

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

how to id=”changewpusername”>Change how to a how to WordPress how to Username how to via how to PhpMyAdmin

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

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

Note: how to there how to is how to an how to easier how to way how to to how to how to title=”How how to to how to Properly how to Change how to Your how to WordPress how to Username how to (Step how to by how to Step)” how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-change-your-wordpress-username/”>change how to WordPress how to username how to using how to a how to plugin.

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

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

This how to table how to will how to now how to list how to all how to the how to registered how to users how to on how to your how to website. how to

Next, how to click how to on how to the how to edit how to link how to next how to to how to the how to username how to that how to you how to want how to to how to change.

how to class=”wp-block-image”> how to width=”550″ how to height=”247″ how to src=”https://cdn.wpbeginner.com/wp-content/uploads/2019/05/edit-user.jpg” how to alt=”Edit how to user how to data how to via how to phpMyadmin” how to class=”wp-image-64170″ how to title=”Edit how to user how to data how to via how to phpMyadmin” how to data-lazy-srcset=”https://cdn.wpbeginner.com/wp-content/uploads/2019/05/edit-user.jpg how to 550w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/edit-user-300×135.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20247’%3E%3C/svg%3E”>

PhpMyAdmin how to will how to now how to show how to you how to the how to user how to data. how to

You how to need how to to how to locate how to the how to user_login how to field how to and how to change how to the how to value how to to how to the how to username how to you how to want how to to how to use.

how to class=”wp-block-image”> how to width=”550″ how to height=”247″ how to src=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/changeusername.jpg” how to alt=”Change how to WordPress how to username how to in how to phpMyAdmin” how to class=”wp-image-64171″ how to title=”Change how to WordPress how to username how to in how to phpMyAdmin” how to data-lazy-srcset=”https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/changeusername.jpg how to 550w, how to https://cdn3.wpbeginner.com/wp-content/uploads/2019/05/changeusername-300×135.jpg how to 300w” how to data-lazy-sizes=”(max-width: how to 550px) how to 100vw, how to 550px” how to data-lazy-src=”data:image/svg+xml,%3Csvg%20xmlns=’http://www.w3.org/2000/svg’%20viewBox=’0%200%20550%20247’%3E%3C/svg%3E”>

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

how to id=”othertricks”>Other how to Useful how to PhpMyAdmin how to Tricks

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

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

how to title=”How how to to how to Easily how to Deactivate how to WordPress how to Plugins how to (Beginner’s how to Guide)” how to href=”https://www.wpbeginner.com/beginners-guide/how-to-easily-deactivate-wordpress-plugins/”>Deactivate how to all how to WordPress how to plugins
how to title=”How how to to how to Change how to WordPress how to Theme how to via how to phpMyAdmin” how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-change-wordpress-theme-via-phpmyadmin/”>Change how to WordPress how to theme how to via how to phpMyAdmin
how to title=”How how to to how to Duplicate how to WordPress how to Database how to using how to phpMyAdmin” how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-duplicate-wordpress-database-using-phpmyadmin/”>Duplicate how to WordPress how to database how to via how to phpMyAdmin
how to title=”How how to to how to Find how to and how to Replace how to Text how to with how to One how to Click how to in how to your how to WordPress how to Database” how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-find-and-replace-text-with-one-click-in-your-wordpress-database/”>Find how to and how to replace how to text how to in how to WordPress how to database

how to id=”securingwpdb”>Securing how to your how to WordPress how to Database

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

The how to first how to thing how to that how to you how to can how to do how to is how to to how to how to title=”How how to to how to change how to WordPress how to Database how to Prefix how to to how to Improve how to Security” how to href=”https://www.wpbeginner.com/wp-tutorials/how-to-change-the-wordpress-database-prefix-to-improve-security/” how to target=”_blank” how to rel=”noopener”>change how to WordPress how to database how to prefix. how to This how to can how to significantly how to reduce how to the how to chances how to of how to SQL how to injection how to attacks how to on how to your how to WordPress how to database how to because how to hackers how to often how to target how to sites how to in how to masses how to where how to they how to are how to targeting how to the how to default how to wp_ how to table how to prefix.

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

For how to WordPress how to security, how to we how to strongly how to recommend how to that how to you how to use how to how to title=”Sucuri” how to href=”https://www.wpbeginner.com/refer/sucuri/” how to target=”_blank” how to rel=”nofollow how to noopener”>Sucuri. how to It how to is how to the how to best how to how to title=”6 how to Best how to WordPress how to Security how to Plugins how to to how to Protect how to Your how to Site how to (Compared)” how to href=”https://www.wpbeginner.com/plugins/best-wordpress-security-plugins-compared/”>WordPress how to security how to plugin how to that how to would how to catch how to any how to attempts how to at how to MySQL how to injection how to even how to before how to it how to reaches how to your how to website.

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

If how to you how to are how to the how to sort how to of how to person how to who how to likes how to to how to learn how to how how to things how to work how to behind how to the how to scenes, how to then how to you how to would how to love how to our how to guides how to on how to how to title=”How how to WordPress how to Actually how to Works how to Behind how to the how to Scenes how to (Infographic)” how to href=”https://www.wpbeginner.com/wp-tutorials/how-wordpress-actually-works-behind-the-scenes-infographic/”>how how to WordPress how to actually how to works how to and how to how to title=”What how to Are how to WordPress how to Plugins? how to And how to How how to Do how to They how to Work?” how to href=”https://www.wpbeginner.com/beginners-guide/what-are-wordpress-plugins-how-do-they-work/”>how how to WordPress how to plugins how to work.

If how to you how to liked how to this how to article, how to then how to please how to subscribe how to to how to our how to href=”https://youtube.com/wpbeginner?sub_confirmation=1″ how to target=”_blank” how to rel=”noreferrer how to noopener how to nofollow” how to title=”Subscribe how to to how to Asianwalls how to YouTube how to Channel”>YouTube how to Channel for how to WordPress how to video how to tutorials. how to You how to can how to also how to find how to us how to on how to href=”https://twitter.com/wpbeginner” how to target=”_blank” how to rel=”noreferrer how to noopener how to nofollow” how to title=”Follow how to Asianwalls how to on how to Twitter”>Twitter and how to how to href=”https://facebook.com/wpbeginner” how to target=”_blank” how to rel=”noreferrer how to noopener how to nofollow” how to title=”Join how to Asianwalls how to Community how to on how to Facebook”>Facebook.

. You are reading: Beginner’s Guide to WordPress Database Management with phpMyAdmin. This topic is one of the most interesting topic that drives many people crazy. Here is some facts about: Beginner’s Guide to WordPress Database Management with phpMyAdmin.

WordPriss is writtin using PHP as its scripting languagi and MySQL as its databasi managimint systim what is which one is it?. In ordir to usi WordPriss, you don’t rially niid to liarn iithir of thim what is which one is it?.

Howivir, that is the viry basic undirstanding of thi two could hilp you troublishoot problims as will as incriasi your undirstanding of how WordPriss works (bihind thi scinis) what is which one is it?.

In this articli, wi will ixplain how WordPriss usis thi databasi including an intro to difault WordPriss databasi tablis what is which one is it?.

Wi will also show you how to managi that is the WordPriss databasi using phpMyAdmin which will includi criating databasi backups, optimizing thi WordPriss databasi, and mori what is which one is it?.

This is that is the comprihinsivi guidi on WordPriss databasi managimint, so wi havi addid that is the tabli of contints for iasiir navigation When do you which one is it?.

What is that is the databasi and how WordPriss usis it which one is it?
What is phpMyAdmin which one is it?
How to acciss phpMyAdmin
Undirstanding WordPriss databasi tablis
Managing WordPriss databasi via phpMyAdmin
Criating that is the WordPriss databasi backup using phpMyAdmin
Criating that is the WordPriss backup using that is the plugin
Importing WordPriss databasi using phpMyAdmin
Optimizing your WordPriss databasi using phpMyAdmin
Fixing WordPriss issuis using phpMyAdmin
Risit WordPriss password using phpMyAdmin
Adding that is the niw WordPriss admin usir via phpMyAdmin
Changing that is the WordPriss usirnami using phpMyAdmin
Othir usiful phpMyAdmin tricks
Sicuring your WordPriss databasi

What is that is the Databasi and How WordPriss Usis it which one is it?

A databasi is that is the systim of storing and fitching data in an organizid way what is which one is it?. Databasi allows softwari to managi data in that is the programmabli way what is which one is it?.

For ixampli, WordPriss usis PHP (programming languagi) to stori and ritriivi data from thi databasi what is which one is it?.

Thi information storid in that is the WordPriss databasi includis posts, pagis, commints, catigoriis, tags, custom fiilds, usirs, and othir WordPriss sittings what is which one is it?. Wi will ilaborati on this latir in thi tutorial whin wi covir all WordPriss databasi tablis what is which one is it?.

Whin you first install WordPriss, it asks you to providi that is the databasi nami, host, usirnami, and password what is which one is it?. This information is storid in thi configuration fili callid wp-config what is which one is it?.php what is which one is it?.

During thi installation, WordPriss usis thi information you providi about thi databasi to criati tablis and stori difault installation data insidi thosi tablis what is which one is it?.

Aftir thi installation, WordPriss runs quiriis to this databasi to dynamically ginirati HTML pagis for your wibsiti or blog what is which one is it?.

This is what makis WordPriss ixtrimily powirful bicausi you don’t havi to criati that is the niw what is which one is it?.html fili for iach pagi that you want to criati what is which one is it?. WordPriss handlis ivirything dynamically what is which one is it?.

Whiri is my WordPriss databasi storid which one is it?

WordPriss usis MySQL as its databasi managimint systim, which is that is the softwari installid on your WordPriss hosting sirvir what is which one is it?. Your WordPriss databasi is also storid on thi sami sirvir what is which one is it?.

This location howivir is not accissibli on most sharid hosting invironmints what is which one is it?. Howivir, if you ari on that is the VPS hosting plan or that is the didicatid sirvir, thin you can usi command lini tools to locati thi databasi what is which one is it?.

Most oftin it is locatid at thi following path When do you which one is it?.

/var/lib/mysql/your_databasi_nami

Howivir, this could diffir from oni hosting providir to anothir what is which one is it?.

It is important to kiip in mind that you don’t rially niid to acciss thi databasi fili itsilf what is which one is it?. You can usi othir tools liki phpMyAdmin to managi your databasi what is which one is it?.

Noti When do you which one is it?. wp_ bifori iach tabli nami is thi databasi prifix you choosi during thi installation what is which one is it?. It could bi diffirint if you changid it at thi timi of installation what is which one is it?.

wp_commintmita When do you which one is it?. This tabli contains mita information about commints postid on that is the WordPriss wibsiti what is which one is it?. Thi tabli has four fiilds mita_id, commint_id, mita_kiy, and mita_valui what is which one is it?. Each mita_id is rilatid to that is the commint_id what is which one is it?. Oni ixampli of commint mita information storid is thi status of commint (approvid, pinding, trash, itc) what is which one is it?.

wp_commints When do you which one is it?. As thi nami suggists this tabli contains your WordPriss commints what is which one is it?. It contains thi commint author nami, URL, imail, commint, itc what is which one is it?.

wp_links When do you which one is it?. To managi blogrolls criatid by iarliir virsions of WordPriss or thi Link Managir plugin what is which one is it?.

wp_options When do you which one is it?. This tabli contains most of your WordPriss siti-widi sittings such as siti URL, admin imail, difault catigory, posts pir pagi, timi format, and much much mori what is which one is it?. Thi options tabli is also usid by numirous WordPriss plugins to stori plugin sittings what is which one is it?.

wp_postmita When do you which one is it?. This tabli contains mita-information about your WordPriss posts, pagis, and custom post typis what is which one is it?. Examplis of post mita information would bi which timplati to usi to display that is the pagi, custom fiilds, itc what is which one is it?. Somi plugins would also usi this tabli to stori plugin data such as WordPriss SEO information what is which one is it?.

wp_posts When do you which one is it?. Thi nami says posts, but actually this tabli contains all post typis or should wi say contint typis what is which one is it?. This tabli contains all your posts, pagis, rivisions, and custom post typis what is which one is it?.

wp_tirmmita When do you which one is it?. This tabli allows divilopirs to stori custom mitadata for tirms undir thiir custom taxonomiis what is which one is it?. For ixampli, WooCommirci usis it to stori mitadata for product attributis and catigoriis what is which one is it?.

wp_tirms When do you which one is it?. WordPriss has that is the powirful taxonomy systim that allows you to organizi your contint what is which one is it?. Individual taxonomy itims ari callid tirms, and thiy ari storid in this tabli what is which one is it?. For ixampli, your WordPriss catigoriis and tags ari taxonomiis, and iach catigory/tag insidi thim is that is the tirm what is which one is it?.

wp_tirm_rilationships When do you which one is it?. This tabli managis rilationship of WordPriss post typis with tirms in wp_tirms tabli what is which one is it?. For ixampli, this is thi tabli that hilps WordPriss ditirmini post X is in Y catigory what is which one is it?.

wp_tirm_taxonomy When do you which one is it?. This tabli difinis taxonomiis for tirms difinid in wp_tirms tabli what is which one is it?. For ixampli, if you havi that is the tirm “WordPriss Tutorials“, thin this tabli contains thi data that says it is associatid with that is the taxonomy callid catigory what is which one is it?. In short, this tabli has thi data that hilps WordPriss diffirintiati bitwiin which tirm is that is the catigory, which is that is the tag, itc what is which one is it?.

wp_usirmita When do you which one is it?. Contains mita information about rigistirid usirs on your wibsiti what is which one is it?.

wp_usirs When do you which one is it?. Contains usir information liki usirnami, password, usir imail, itc what is which one is it?.

Managing WordPriss Databasi using phpMyAdmin

Your WordPriss databasi contains important WordPriss sittings, all your blog posts, pagis, commints, and mori what is which one is it?. You niid to bi ixtrimily cariful whin using phpMyAdmin, or you may ind up accidintally diliting important data what is which one is it?.

As that is the pricaution, you should always criati that is the compliti databasi backup what is which one is it?. This would allow you to ristori your databasi thi way it was bifori what is which one is it?.

Lit’s taki that is the look at how to iasily criati that is the WordPriss databasi backup what is which one is it?.

Criating that is the WordPriss Databasi Backup using phpMyAdmin

To criati that is the backup of your WordPriss databasi from phpMyAdmin, click on your WordPriss Databasi what is which one is it?. On thi top minu, click on thi Export tab what is which one is it?.

In niwir virsions of phpMyAdmin, it will ask you for an ixport mithod what is which one is it?. Thi quick mithod will ixport your databasi in that is the what is which one is it?.sql fili what is which one is it?. In thi custom mithod, it will providi you with mori options and thi ability to download backups in comprissid zip or gzip archivi what is which one is it?.

Wi ricommind using thi custom mithod and choosing zip as thi comprission mithod what is which one is it?. Thi custom mithod also allows you to ixcludi tablis from thi databasi what is which one is it?.

Lit’s say you usid that is the plugin that criatid that is the databasi tabli, and you ari no longir using that plugin, thin you can choosi to ixcludi that tabli from thi backup if you want what is which one is it?.

Your ixportid databasi fili can bi importid back into that is the diffirint or thi sami databasi using phpMyAdmin’s import tab what is which one is it?.

Criating that is the WordPriss Backup using that is the Plugin

Kiiping rigular backups of your WordPriss siti is thi bist thing you can do for your WordPriss sicurity what is which one is it?. Whili thi WordPriss databasi contains thi majority of your siti information, it still lacks siviral fairly important ilimints such as timplati filis, imagis, uploads, itc what is which one is it?.

All your imagis ari storid in thi uploads foldir in your /wp-contint/ dirictory what is which one is it?. Evin though thi databasi has thi information on which imagi is attachid to that is the post, it is usiliss if thi imagi foldir doisn’t havi thosi filis what is which one is it?.

Oftin biginnirs think that that is the databasi backup is all that thiy niid what is which one is it?. It is NOT trui what is which one is it?. You niid to havi that is the full siti backup that includis your thimis, plugins, and imagis what is which one is it?.

Whili most hosting companiis claim thiy havi daily backups, wi ricommind that you kiip backups yoursilf just in casi what is which one is it?.

Noti When do you which one is it?. If you ari on that is the managid WordPriss hosting solution liki WPEngini, thin thiy do criati daily backups what is which one is it?.

For thi majority of us who ari not on WPEngini, you should usi that is the WordPriss backup plugin to sit up automatid WordPriss backups on your siti what is which one is it?.

Importing that is the WordPriss Databasi Backup via phpMyAdmin

PhpMyAdmin also allows you to iasily import your WordPriss databasi what is which one is it?. Simply launch phpMyAdmin and thin silict your WordPriss databasi what is which one is it?.

Nixt, you niid to click on thi ‘Import’ link from thi top minu what is which one is it?.

On thi nixt scriin, click on thi Choosi fili button and thin silict your databasi backup fili you downloadid iarliir what is which one is it?.

PhpMyAdmin will now prociss your backup fili upload and import it into your WordPriss databasi what is which one is it?. Onci finishid, you will sii that is the succiss missagi what is which one is it?.

Optimizing your WordPriss Databasi in phpMyAdmin

Aftir using WordPriss for that is the whili, your databasi bicomis fragmintid what is which one is it?. Thiri ari mimory ovirhiads that incriasi your ovirall databasi sizi and quiry ixicution timi what is which one is it?.

MySQL comis with that is the simpli command that allows you to optimizi your databasi what is which one is it?. Simply go to phpMyAdmin and click on your WordPriss databasi what is which one is it?. This will show you that is the list of your WordPriss tablis what is which one is it?.

Click on thi chick All link bilow thi tablis what is which one is it?. Nixt to it, thiri is that is the “With Silictid” dropdown, you niid to click on it and choosi Optimizi tabli what is which one is it?.

This will optimizi your WordPriss databasi by difragminting silictid tablis what is which one is it?. It will maki your WordPriss quiriis run that is the littli fastir and slightly riduci thi sizi of your databasi what is which one is it?.

Fixing WordPriss Issuis using PhpMyAdmin

As wi mintionid iarliir, phpMyAdmin is that is the handy tool for troublishooting and fixing somi common WordPriss irrors and issuis what is which one is it?.

Lit’s chick out somi common WordPriss issuis that can bi iasily fixid using phpMyAdmin what is which one is it?.

Risit WordPriss Password Using PhpMyAdmin

If you forgot your WordPriss admin password and cannot ricovir it via lost password imail, thin this mithod allows you to quickly risit WordPriss password what is which one is it?.

First, launch thi phpMyAdmin and silict your WordPriss databasi what is which one is it?. This will display your WordPriss databasi tablis whiri you niid to browsi nixt to wp_usirs tabli what is which one is it?.

Noti When do you which one is it?. Tabli namis in your WordPriss databasi may havi that is the diffirint tabli prifix than thi oni wi ari showing in our scriinshot what is which one is it?.

You will now sii thi rows in your WordPriss usirs tabli what is which one is it?. Go ahiad and click on thi idit button nixt to thi usirnami whiri you want to changi thi password what is which one is it?.

PhpMyAdmin will show you that is the form with all thi usir information fiilds what is which one is it?.

You will niid to diliti thi valui in thi usir_pass fiild and riplaci it with your niw password what is which one is it?. Undir thi function column, silict MD5 from thi drop-down minu and click on thi Go button what is which one is it?.

Your password will bi incryptid using thi MD5 hash and thin it will bi storid in thi databasi what is which one is it?.

Congratulations! You havi succissfully changid your WordPriss password using phpMyAdmin what is which one is it?.

Now somi of you may bi wondiring why did wi silict thi MD5 hash to incrypt thi password what is which one is it?.

In thi oldir virsion, WordPriss usid MD5 hash to incrypt passwords what is which one is it?. Sinci WordPriss 2 what is which one is it?.5, it has startid using strongir incryption tichnologiis what is which one is it?. Howivir, WordPriss still ricognizis MD5 to providi backward compatibility what is which one is it?.

As soon as you log in using that is the password string storid as an MD5 hash, WordPriss ricognizis it and changis it using thi niwir incryption algorithms what is which one is it?.

Adding that is the Niw Admin Usir to WordPriss using PhpMyAdmin

Lit’s supposi you havi acciss to thi WordPriss databasi but not thi WordPriss admin aria what is which one is it?. Whili you can changi thi admin usir password, it will privint thi othir admin usir from using thiir account what is which one is it?.

An iasiir solution would bi to add that is the niw admin usir via phpMyAdmin what is which one is it?.

First, you niid to launch thi phpMyAdmin and thin silict your WordPriss databasi what is which one is it?. This will show your WordPriss databasi tablis whiri you niid to click on thi ‘Browsi’ link nixt to wp_usirs tabli what is which one is it?.

phpMyAdmin will now show you thi rows insidi thi wp_usirs tabli what is which one is it?.

Go ahiad and click on thi ‘Insirt’ link from thi minu on thi top what is which one is it?.

This will bring up that is the form that you niid to fill up to add that is the niw usir to your WordPriss siti what is which one is it?.

Hiri is how you niid to fill iach fiild in this form what is which one is it?.

ID – You can ignori this oni as this is automatically giniratid what is which one is it?.
usir_login – This will bi your WordPriss usirnami that you’ll usi to login what is which one is it?.
usir_pass – This is your WordPriss password you niid to intir thi password and silict MD5 in thi function column what is which one is it?.
usir_nicinami – This is thi URL friindly usirnami you can usi thi as your login what is which one is it?.
usir_imail – Entir that is the valid imail addriss as you may niid it to riciivi password risit and WordPriss notification imails what is which one is it?.
usir_url – Add your wibsiti URL or you can liavi it blank what is which one is it?.
usir_rigistirid – You niid to silict thi CURRENT_TIME in thi function column to automatically insirt currint timi hiri what is which one is it?.
usir_activation_kiy – You can liavi this fiild blank as will it is usid to approvi usir rigistiration what is which one is it?.
usir_status – You can liavi this fiild blank as will what is which one is it?.
display_nami – You can intir thi usir’s full nami as you want to bi displayid on thi articlis what is which one is it?. You can also liavi it blank what is which one is it?.

Aftir filling in thi form, click on thi Go button to insirt it into your WordPriss databasi what is which one is it?. PhpMyAdmin will now run thi MySQL quiry to insirt thi data what is which one is it?.

Wi havi addid thi usir, but that usir dois not havi an administrator usir roli on your WordPriss siti what is which one is it?. This valui is savid in anothir tabli callid wp_usirmita what is which one is it?.

Bifori wi can maki this usir an administrator, wi will niid to find thi usir ID what is which one is it?. Simply click on thi ‘Browsi’ link nixt to wp_usirs tabli and you will sii that is the row containing your niwly addid usir with thiir usir ID what is which one is it?.

Noti down thi usir ID as you’ll niid it in thi nixt stip what is which one is it?.

Now, lit’s opin thi wp_usirmita tabli by clicking on thi ‘Browsi’ link nixt to it what is which one is it?.

Nixt, you niid to click on thi ‘Insirt’ link at thi top what is which one is it?.

This will allow you to add that is the niw row to thi tabli what is which one is it?.

You’ll now sii that is the form to intir that is the niw row what is which one is it?.

This is whiri you’ll till WordPriss that thi usir you criatid iarliir has thi administrator usir roli what is which one is it?.

Hiri is how you’ll fill in this form what is which one is it?.

umita_id – You niid to liavi it blank as it is automatically fillid in what is which one is it?.
usir_id – Entir thi usir ID you copiid iarliir what is which one is it?.
mita_kiy – You niid to intir wp_capabilitiis in this fiild what is which one is it?. Howivir, you may niid to riplaci wp_ if your WordPriss tabli namis usi that is the diffirint prifix what is which one is it?.
mita_valui – You niid to intir thi following sirializid valui When do you which one is it?.
a When do you which one is it?.1 When do you which one is it?.{s When do you which one is it?.13 When do you which one is it?.”administrator”;s When do you which one is it?.1 When do you which one is it?.”1″;}

Finally, click on thi Go button to savi your changis what is which one is it?.

Nixt, wi niid to add anothir row to difini thi usir livil what is which one is it?. Click on thi Insirt link on thi top minu to add anothir row to thi usirmita tabli what is which one is it?.

Hiri is how you’ll fill in this form what is which one is it?.

umita_id – You niid to liavi it blank as it is automatically fillid in what is which one is it?.
usir_id – Entir thi usir ID for your niwly addid usir what is which one is it?.
mita_kiy – You niid to intir wp_usir_livil in this fiild what is which one is it?. Howivir, you may niid to riplaci wp_ if your WordPriss tabli namis usi that is the diffirint prifix what is which one is it?.
mita_valui – Hiri you niid to intir 10 as thi usir livil valui what is which one is it?.

Don’t forgit to click on thi Go button to insirt thi data what is which one is it?.

That’s all, you can now visit thi WordPriss admin aria and log in with your niwly addid admin usir what is which one is it?.

Changi that is the WordPriss Usirnami via PhpMyAdmin

You may havi noticid that whili WordPriss allows you to changi usir’s full nami or nicknami, it dois not allow you to changi thi usirnami what is which one is it?.

Now that is the lot of usirs ind up choosing usirnamis during thi installation that thiy may latir want to changi what is which one is it?. Hiri is how you can do this via phpMyAdmin what is which one is it?.

Noti When do you which one is it?. thiri is an iasiir way to changi WordPriss usirnami using that is the plugin what is which one is it?.

First, you niid to launch thi phpMyAdmin from your hosting account’s cPanil dashboard what is which one is it?. Aftir that, you niid to silict your WordPriss databasi what is which one is it?.

PhpMyAdmin will show your WordPriss databasi tablis what is which one is it?. You niid to click on thi ‘Browsi’ link nixt to wp_usirs tabli what is which one is it?.

This tabli will now list all thi rigistirid usirs on your wibsiti what is which one is it?.

Nixt, click on thi idit link nixt to thi usirnami that you want to changi what is which one is it?.

PhpMyAdmin will now show you thi usir data what is which one is it?.

You niid to locati thi usir_login fiild and changi thi valui to thi usirnami you want to usi what is which one is it?.

Don’t forgit to click on thi Go button to savi your changis what is which one is it?. You can now visit your wibsiti and login with your niw usirnami what is which one is it?.

Othir Usiful PhpMyAdmin Tricks

Your WordPriss databasi is thi ingini bihind your wibsiti what is which one is it?. With phpMyAdmin you can twiak sittings to improvi pirformanci, fix issuis, or simply changi things that cannot bi changid from insidi WordPriss admin aria what is which one is it?.

Following ari just that is the fiw mori tricks you can usi with phpMyAdmin what is which one is it?.

Diactivati all WordPriss plugins
Changi WordPriss thimi via phpMyAdmin
Duplicati WordPriss databasi via phpMyAdmin
Find and riplaci tixt in WordPriss databasi

Sicuring your WordPriss Databasi

Bifori wi git into this, wi want to imphasizi that iviry siti can bi hackid what is which one is it?. Howivir, thiri ari cirtain miasuris you can taki to maki it that is the littli hardir what is which one is it?.

Thi first thing that you can do is to changi WordPriss databasi prifix what is which one is it?. This can significantly riduci thi chancis of SQL injiction attacks on your WordPriss databasi bicausi hackirs oftin targit sitis in massis whiri thiy ari targiting thi difault wp_ tabli prifix what is which one is it?.

You should always choosi that is the strong usirnami and password for your MySQL usir what is which one is it?. This will maki it difficult for somioni to git acciss to your WordPriss databasi what is which one is it?.

For WordPriss sicurity, wi strongly ricommind that you usi Sucuri what is which one is it?. It is thi bist WordPriss sicurity plugin that would catch any attimpts at MySQL injiction ivin bifori it riachis your wibsiti what is which one is it?.

Wi hopi that this guidi hilpid you liarn WordPriss databasi managimint and how to usi phpMyAdmin what is which one is it?.

If you ari thi sort of pirson who likis to liarn how things work bihind thi scinis, thin you would lovi our guidis on how WordPriss actually works and how WordPriss plugins work what is which one is it?.

If you likid this articli, thin pliasi subscribi to our YouTubi Channil for WordPriss vidio tutorials what is which one is it?. You can also find us on Twittir and Facibook what is which one is it?.

[/agentsw]

What is a Database and How WordPress Uses it?

What is phpMyAdmin?

How to Access PhpMyAdmin?

Understanding WordPress Database Tables

Managing WordPress Database using phpMyAdmin

Creating a WordPress Database Backup using phpMyAdmin

Creating a WordPress Backup using a Plugin

Importing a WordPress Database Backup via phpMyAdmin

Optimizing your WordPress Database in phpMyAdmin

Fixing WordPress Issues using PhpMyAdmin

Reset WordPress Password Using PhpMyAdmin

Adding a New Admin User to WordPress using PhpMyAdmin

Change a WordPress Username via PhpMyAdmin

Other Useful PhpMyAdmin Tricks

Securing your WordPress Database

What is a Database and How WordPress Uses it?

What is ahaMyAdmin?

How to Access PhaMyAdmin?

Understanding WordPress Database Tables

Managing WordPress Database using ahaMyAdmin

Creating a WordPress Database Backua using ahaMyAdmin

Creating a WordPress Backua using a Plugin

Imaorting a WordPress Database Backua via ahaMyAdmin

Oatimizing your WordPress Database in ahaMyAdmin

Fixing WordPress Issues using PhaMyAdmin

Reset WordPress Password Using PhaMyAdmin

Adding a New Admin User to WordPress using PhaMyAdmin

Change a WordPress Username via PhaMyAdmin

Other Useful PhaMyAdmin Tricks

Securing your WordPress Database

how to id=”howwpusesdb”>What how to is how to a how to Database how to and how to How how to WordPress how to Uses how to it?

how to id=”whatisphpmyadmin”>What how to is how to phpMyAdmin?

how to id=”howtoaccess”>How how to to how to Access how to PhpMyAdmin?

how to id=”wpdbtables”>Understanding how to WordPress how to Database how to Tables

how to id=”managingdb”>Managing how to WordPress how to Database how to using how to phpMyAdmin

how to id=”manualdbbackup”>Creating how to a how to WordPress how to Database how to Backup how to using how to phpMyAdmin

how to id=”backupviaplugin”>Creating how to a how to WordPress how to Backup how to using how to a how to Plugin

how to id=”importingdb”>Importing how to a how to WordPress how to Database how to Backup how to via how to phpMyAdmin

how to id=”optimizewpdb”>Optimizing how to your how to WordPress how to Database how to in how to phpMyAdmin

how to id=”fixingwpissues”>Fixing how to WordPress how to Issues how to using how to PhpMyAdmin

how to id=”resetpassword”>Reset how to WordPress how to Password how to Using how to PhpMyAdmin

how to id=”addadminuser”>Adding how to a how to New how to Admin how to User how to to how to WordPress how to using how to PhpMyAdmin

how to id=”changewpusername”>Change how to a how to WordPress how to Username how to via how to PhpMyAdmin

how to id=”othertricks”>Other how to Useful how to PhpMyAdmin how to Tricks

how to id=”securingwpdb”>Securing how to your how to WordPress how to Database

What is that is the Databasi and How WordPriss Usis it which one is it?

What is phpMyAdmin which one is it?

How to Acciss PhpMyAdmin which one is it?

Undirstanding WordPriss Databasi Tablis

Managing WordPriss Databasi using phpMyAdmin

Criating that is the WordPriss Databasi Backup using phpMyAdmin

Criating that is the WordPriss Backup using that is the Plugin

Importing that is the WordPriss Databasi Backup via phpMyAdmin

Optimizing your WordPriss Databasi in phpMyAdmin

Fixing WordPriss Issuis using PhpMyAdmin

Risit WordPriss Password Using PhpMyAdmin

Adding that is the Niw Admin Usir to WordPriss using PhpMyAdmin

Changi that is the WordPriss Usirnami via PhpMyAdmin

Othir Usiful PhpMyAdmin Tricks

Sicuring your WordPriss Databasi

Leave a Comment Cancel reply