Then, we’ll showcase ten WordPress phpMyAdmin use cases<\/a>, including creating new WordPress users, changing passwords, deactivating themes\/plugins, and more.<\/p>\n\n\n\n Let’s dig in…<\/p>\n<\/div>\n\n\n\n So – why do you need a WordPress phpMyAdmin tutorial? \ud83e\udd14<\/p>\n\n\n\n Well, despite their simple interface, WordPress websites consist of a complex set of data<\/strong> like pages, posts, tags, categories, comments, login credentials, settings, and configurations along with data from the plugins and themes installed on your site. <\/p>\n\n\n\n All this data is stored in an organized system called the database<\/strong>.<\/p>\n\n\n Luckily you don’t have to create a database manually. It’s automatically created by WordPress when you first install the CMS on the site<\/a>.<\/p>\n\n\n\n WordPress uses MySQL<\/strong> (a database management system) to create databases and that’s why a WordPress database<\/a> is often referred to as a MySQL database<\/a>.<\/p>\n\n\n\n The MySQL database is too complex for a regular website owner to operate so you need an administrative tool to access and operate the database.<\/p>\n\n\n\n PhpMyAdmin<\/strong> is a free and popular administration tool that allows you to browse, modify, add, delete, export, or import the MySQL database.<\/p>\n\n\n\n Pretty much all WordPress hosts offer phpMyAdmin as part of their hosting dashboards, whether they’re using cPanel or a custom dashboard.<\/p>\n\n\n We mentioned earlier how the WordPress database is an organized system. In this system, all your website’s data is saved in the form of tables<\/strong>. Each table contains a unique set of data displayed in rows<\/strong> and columns<\/strong>.<\/p>\n\n\n\n For instance, the wp_user table on the database of my demo site has three rows displaying information about the site users. Each row is further divided into a couple of columns containing specific information about the users:<\/p>\n\n\n\n When a database is first created, it contains a set of core tables<\/a>. As you add more posts, and pages, create new users, configure new settings, and install new plugins and themes, more and more tables are added to the database.<\/p>\n\n\n\n Now that you know what exactly is the phpMyAdmin and what role it plays in your WordPress website, let’s look at the different ways to use this tool to operate your site in our WordPress phpMyAdmin tutorial.<\/p>\n\n\n PhpMyAdmin can be used to carry out a ton of functions.<\/p>\n\n\n\n Our WordPress phpMyAdmin tutorial will show you how to use it to manage your site’s database. You will learn how to…<\/p>\n\n\n\n Before you take any of these steps, we recommend that you make a backup of your website<\/a>. The database contains critical data from your site. In case you accidentally delete a table, row, or column, you can use the backup to restore your site to normal.<\/p>\n\n\n\n \ud83d\udc49 Before we get to the specific use cases, let’s talk about how to access phpMyAdmin.<\/p>\n\n\n How you access phpMyAdmin will depend on which WordPress hosting provider you’re using.<\/p>\n\n\n\n If your host offers cPanel, you can get started by opening your hosting account and locating cPanel.<\/p>\n\n\n In cPanel, look for phpMyAdmin<\/strong> and select it.<\/p>\n\n\n On the left side of the phpMyAdmin, you will notice one or more databases<\/strong>.<\/p>\n\n\n\n A single website has a single database. If you are hosting multiple websites in your hosting account, you might see multiple databases.<\/p>\n\n\n Select your site’s database and the right panel of your screen will be immediately populated with tables.<\/p>\n\n\n\n Now, let’s get into using this database access to perform specific actions. \ud83d\uddc3\ufe0f<\/p>\n\n\n If you get locked out of your WordPress site<\/a>, one common fix is to create a new WordPress admin user<\/a> via phpMyAdmin.<\/p>\n\n\n\n To add a new admin WordPress user with phpMyAdmin, navigate to the wp_users<\/strong> table.<\/p>\n\n\n\n Some web hosts change the prefix<\/a> of the table for security reasons. Just look for the table that has “_users” as the suffix.<\/p>\n\n\n\n For example, on our test site, it’s wpzu_users<\/strong>.<\/p>\n\n\n Next, in the wp_users table, select the Insert<\/strong> tab and fill in the following details: username<\/strong>, password<\/strong>, email address<\/strong>, date<\/strong>, and time<\/strong> for the user to be registered.<\/p>\n\n\n\n Make sure that the value for the “user_status” field is set to zero<\/strong> and in the “user_pass” field, select MD5<\/strong> from the Function<\/strong> drop-down.<\/p>\n\n\n Leave the other fields empty and hit the Go<\/strong> button.<\/p>\n\n\n\n Go back and check the wp_users table. You should be able to see the new user added to the table.<\/p>\n\n\n\n Make a note of the value in the ID<\/strong> column.<\/p>\n\n\n Next, go to the wp_usermeta<\/strong> table and select the Insert<\/strong> tab. Fill in the following values:<\/p>\n\n\n\n That’s it. Go to the end of the page and hit the Go<\/strong> button.<\/p>\n\n\n\n You have now added a new admin user to your WordPress website.<\/p>\n\n\n\n You can log in using those credentials and you’ll be able to fully control your site.<\/p>\n\n\n Go to wp_users<\/strong> and select the Edit<\/strong> button located adjacent to the username you want to change.<\/p>\n\n\n Enter the new username<\/strong> in the user_login<\/strong> field. Leave every other field as is and hit the Go<\/strong> button.<\/p>\n\n\n\n You have now changed the username of your WordPress website.<\/p>\n\n\n Go to wp_users<\/strong> and select the Edit<\/strong> button located adjacent to the username whose user password you want to change:<\/p>\n\n\n\n Congratulations! You have successfully changed your user password from the WordPress phpMyAdmin.<\/p>\n\n\n If you are planning to take manual backups of your database<\/a>, then go to phpMyAdmin, select the database<\/strong> you want to backup, and hit the Export<\/strong> button.<\/p>\n\n\n\n Next, you will need to select an export method. The quick<\/strong> method will download the entire database and the custom<\/strong> method allows more control over the backup process. It lets you to select which tables to export, and compress the backup into a zip file, among other things.<\/p>\n\n\n\n Choose any of the export methods and hit the Go<\/strong> button.<\/p>\n\n\n\n The MySQL database will be downloaded to your local computer.<\/p>\n\n\n We already showed you how to export the database<\/a> in the previous section. Here we will show you how to import<\/strong> a database using phpMyAdmin.<\/p>\n\n\n\n Before you start the process, you should have a database downloaded to your local computer. Then, go to phpMyAdmin and select the Import<\/strong> button. Upload the database using the Choose File<\/strong> option.<\/p>\n\n\n\n Leave all other fields as is and hit the Go<\/strong> button.<\/p>\n\n\n The import should take a couple of seconds. After the process is complete, phpMyAdmin will show you a success message.<\/p>\n\n\n A WordPress website becomes bulky as you add users, posts, and pages and install new plugins and themes to your site. Some of these data (like from uninstalled plugins and themes) are unnecessary and tend to slow your site down. You can remove them and clean your database<\/a> using a simple command in WordPress phpMyAdmin.<\/p>\n\n\n\n Select the database in your phpMyAdmin. Then scroll down and select the Check all \/ Check tables having overhead<\/strong> option.<\/p>\n\n\n\n Next, from the menu located beside Check all, select Optimize table<\/strong>. This will clean up the tables as well as boost your database performance.<\/p>\n\n\n \ud83d\udccc Side note<\/strong>: Some plugins help you optimize the database without you having to access phpMyAdmin. We have tested those plugins and written about them in these two guides: best database maintenance plugins<\/a> and the best WordPress database management plugins<\/a>.<\/p>\n\n\n In some situations, phpMyAdmin can help secure your website against hack attacks like SQL injection.<\/p>\n\n\n\n In MySQL injection attacks, hackers target the database and steal information like usernames and passwords which they use to break into your website.<\/p>\n\n\n\n You can make it more difficult to perform these types of injection attacks by changing your database tables’ default prefix<\/a> (i.e., wp_) to something else (for example wp8p_).<\/p>\n\n\n\n If you want to do this on a live WordPress site, we highly recommend backing up your site before making changes. Doing this incorrectly will make your site stop working temporarily, so it’s good to have a backup.<\/p>\n\n\n\n To change the database prefix, go to cPanel<\/strong>, then select File Manager<\/strong> and click on the public_html<\/strong> folder.<\/p>\n\n\n\n Inside the public_html folder look for the wp-config.php<\/strong> file. Right-click and select Edit<\/strong>.<\/p>\n\n\n The file will open in a new tab. In this tab, look for the phrase $table_prefix<\/em>. It contains your database prefix. Just replace it with something else.<\/p>\n\n\n\n Hit the Save Changes<\/strong> button located at the top of the screen before you exit the window.<\/p>\n\n\n Next, open phpMyAdmin and select your database. Then, scroll down to the end of the page and click on the Check all<\/strong> option to select all the tables in your database.<\/p>\n\n\n\n From the dropdown menu, select the Replace table prefix<\/strong> and a popup will appear. Insert the name of the old and new database prefixes.<\/p>\n\n\n\n The database prefix for our demo site is wpu_<\/em>. Be sure to insert the database prefix of your website in the From<\/strong> option.<\/p>\n\n\n\n After inserting the prefixes hit the Continue<\/strong> button and your database prefix will be changed.<\/p>\n\n\n If you’re debugging something on your site, you might have a situation where you need to manually disable all of your WordPress plugins without being able to access your WordPress dashboard.<\/p>\n\n\n\n Open your database and navigate to the wp_options<\/strong> table, scroll down to the active_plugins<\/strong> row, and select the Edit<\/strong> button of that row.<\/p>\n\n\n\n On the next page, go to the option_value<\/strong> box and delete all content. Then hit the Go<\/strong> button.<\/p>\n\n\n This will deactivate all the plugins installed on your site.<\/p>\n\n\n Go to the wp_options<\/strong> table, and find the rows called template<\/strong> and stylesheet<\/strong>. You will see the name of your active theme in these two rows.<\/p>\n\n\n\n To change your current theme you will need to replace<\/strong> the name of your active theme with the one you desire. You can do that by using the Edit<\/strong> button or double-clicking on the theme name.<\/p>\n\n\n\n Change the name in both the template<\/strong> and stylesheet<\/strong> rows and you would have changed your site’s theme<\/a>.<\/p>\n\n\n Common database errors that you are likely to encounter on your WordPress website are:<\/p>\n\n\n\n In some cases, these errors can be caused by data corruption in your database. Luckily, phpMyAdmin offers a one-click solution for database issues. Here’s what you have to do:<\/p>\n\n\n\n Select your database<\/strong>, scroll down, and choose the Check all<\/strong> option. Then from the menu select the Repair table<\/strong> option and hit the Go<\/strong> button.<\/p>\n\n\n\n \ud83d\udc68\u200d\ud83c\udf93 Learn more about how to repair the WordPress database<\/a>.<\/p>\n\n\nWhat is phpMyAdmin?<\/h2>\n\n\n\n
![\"wordpress](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/phpmyadmin-database.png\")
<\/figure><\/div>\n\n\nWhat are MySQL and phpMyAdmin?<\/h3>\n\n\n\n
![\"locating](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/locating-phpmyadmin-in-cpanel.png\")
<\/figure><\/div>\n\nWhat are database tables, rows, and columns?<\/h3>\n\n\n\n
\n
![\"contents](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/contents-of-a-table-in-phpmyadmin-database.png\")
<\/figure><\/div>\n\n\nWordPress phpMyAdmin tutorial: Using it to manage your site<\/h2>\n\n\n\n
\n
How to access phpMyAdmin<\/h3>\n\n\n\n
![\"locating](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/locating-cpanel-in-hosting-account.png\")
<\/figure><\/div>\n\n\n<\/figure><\/div>\n\n\n![\"multiple](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/multiple-phpmyadmin-databases.png\")
<\/figure><\/div>\n\n\nHow to add a new WordPress admin user with phpMyAdmin<\/h3>\n\n\n\n
![\"user](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/user-table-in-wordpress-database.png\")
<\/figure><\/div>\n\n\n![\"adding](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/adding-user-in-phpmyadmin-database.png\")
<\/figure><\/div>\n\n\n![\"user](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/user-id-in-wordpress-database.png\")
<\/figure><\/div>\n\n\n\n
![\"editing](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/editing-user-meta-description-in-phpmyadmin.png\")
<\/figure><\/div>\n\nChange a username<\/h3>\n\n\n\n
![\"editing](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/editing-user-in-phpmyadmin-database.png\")
<\/figure><\/div>\n\n\n![\"user](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/user-login-option-in-wordpress-phpmyadmin.png\")
<\/figure><\/div>\n\nReset a user password<\/h3>\n\n\n\n
\n
![\"user](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/user-password-option-in-wordpress-phpmyadmin.png\")
<\/figure><\/div>\n\nBack up database<\/h3>\n\n\n\n
![\"quick](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/quick-custom-export-options-in-wordpress-database.png\")
<\/figure><\/div>\n\nImport or export database<\/h3>\n\n\n\n
![\"importing](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/importing-database-in-wordpress-phpmyadmin.png\")
<\/figure><\/div>\n\n\nBoost site performance<\/h3>\n\n\n\n
![\"optimizing](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/optimizing-table-in-wordpress-phpmyadmin.png\")
<\/figure><\/div>\n\n\nChange WordPress database prefix to secure your site<\/h3>\n\n\n\n
![\"editing](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/editing-wpconfig-file-in-file-manager.png\")
<\/figure><\/div>\n\n\n![\"changing](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/changing-database-prefix-in-wpconfig.png\")
<\/figure><\/div>\n\n\n![\"rename](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/04\/rename-database-prefix-in-phpmyadmin.png\")
<\/figure><\/div>\n\nDeactivate all WordPress plugins<\/h3>\n\n\n\n
![\"delete](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/delete-option-value-content-in-phpmyadmin-database.png\")
<\/figure><\/div>\n\n\nChange the WordPress theme<\/h3>\n\n\n\n
![\"changing](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/changing-theme-in-phpmyadmin-database.png\")
<\/figure><\/div>\n\nTroubleshooting common database issues<\/h3>\n\n\n\n
\n
![\"repair](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2023\/03\/repair-table-in-phpmyadmin-database.png\")
<\/figure><\/div>\n\n