Menu
iThemes
WordPress Backup, Security & Maintenance
  • Products
    • iThemes Security Pro
    • BackupBuddy
    • Kadence WP
    • Restrict Content Pro
    • iThemes Sync
    • Why buy from iThemes?
  • Bundles
    • Essentials Bundle
    • Plugin Suite
    • WordPress Web Designer’s Toolkit
    • Customer Spotlights
  • Resources
    • Blog
    • WordPress 101 Tutorials
    • WordPress Ebooks
    • Weekly WordPress Vulnerability Report
    • The Ultimate Guide to Starting a Web Design Business
  • Training
    • Upcoming Webinars
    • Free Webinar Library
    • Premium Courses
    • Become a Member
    • Member Login
  • Support
    • Documentation
    • Get Help
    • Product Updates
    • Upgrade Policy
    • Contact
    • Our Mission: Make People’s Lives Awesome
  • Log In
WordPress News and Updates from iThemes
Categories
  • Product Updates
  • WordPress Backup
  • WordPress Block Editor
  • WordPress Ecommerce
  • WordPress for Freelancers
  • WordPress Security
  • WordPress Tutorials
  • WPprosper

What is phpMyAdmin?

Written by Mike Mortimer on February 13, 2019

Last Updated on October 8, 2020

What is phpMyAdmin? phpMyAdmin is a free software tool that allows you manage the MySQL database of your website. For WordPress websites specifically, the MySQL database stores all the data related to your posts, pages, comments, users, links and more.

Occasionally, while managing your website, you may come across something that requires you to directly access your WordPress database.

Note: The use of phpMyAdmin for website database management is considered advanced. If you are unfamiliar with this type of database administration, then it is recommended that you seek help from your website developer.

How Do I Access phpMyAdmin?

You can access phpMyAdmin from your website hosting account. Depending on your hosting account configuration, you should see a direct link to login to your phpMyAdmin.

For example, with iThemes Hosting, you have access to phpMyAdmin where you can go to handle many of the needs for your website’s database.

You need 3 main things to start, all of which you can get from the Database Information section of your iThemes Hosting management page.

phpMyAdmin access

To login to phpMyAdmin, you’ll need:

  • 1. Your database password
  • 2. Your database server
  • 3. Your database username

This article assumes that you’ve already gotten your database password.

ou’ll also need the database server which you can see from the example above is mariadb-035.wc1.lan3.stabletransit.com.

The database username which in this example is 2015039_eed292b5. You will then go ahead and select the Login link under phpMyAdmin.

This will bring you to the phpMyAdmin login screen where you will enter the database username and password then locate the database server from the drop-down menu.

Site Management Tools - phpMyAdmin Login

Once you enter that information, you will be logged into phpMyAdmin.

phpMyAdmin Settings

When you access phpMyAdmin, the center section is your settings and basic MySQL server information by default.

Here you can adjust languages, themes, font, size and many other things. You can also find information specific to your database server and web server from the right-hand menu.

Your Website Database Information

Your database information can be viewed from the left-hand menu. This is where you would select the database you wish to work with.

Site Management Tools - Database Menu

information_schema will be present for all of your databases and can be disregarded. The main database that you are interested in will be listed above that. You will click on that database to open the database menu.

Site Management Tools - Database Tables

From here, you can make modifications to your tables directly, including updating information and deleting content from your site.

Note: We strongly recommend making a database backup of your database using a WordPress backup plugin such as BackupBuddy before you make any changes.

As mentioned previously, phpMyAdmin database administration is an advanced skill so please be sure to speak with your website developer if you are unsure about changes that need to be made.

Share via:

  • Facebook
  • Twitter
  • LinkedIn
  • More
Other related posts
great-landing-pages
What Makes Great Landing Pages? 16 Things You Need to Know
July 2022
5 Web Design Trends for July 2022
website kpis
10 Essential Website KPIs for Measuring Performance
WordPress pages vs posts
WordPress Pages vs Posts: What’s the Difference?

Respond

Click here to cancel reply.

Get updates on new themes & plugins plus special discounts

About iThemes

  • The Team
  • Contact Us
  • Website Accessibility Statement
  • Sitemap

Resources

  • Blog
  • Documentation
  • WordPress Tutorials
  • Free WordPress Ebooks
  • Free Webinar Library
  • Free Upcoming Webinars
  • iThemes Training
  • Affiliates

Customers

  • Member Panel Login
  • Support
  • FAQs
  • Upgrade Policy
  • Licensing
  • Terms and Conditions
  • Refund Policy

Top Products

  • BackupBuddy
  • iThemes Security Pro
  • iThemes Sync
  • Restrict Content Pro
  • WPComplete
  • WordPress Hosting
  • WordPress Plugins
  • Content Upgrades
  • WordPress Landing Page Plugin
  • BackupBuddy Stash

iThemes Media LLC Copyright © 2022 All rights reserved | Privacy Policy

© 2022 All Rights Reserved.

[class^="wpforms-"]
[class^="wpforms-"]
Share via
Facebook
Twitter
LinkedIn
Mix
Email
Print
Copy Link
Powered by Social Snap
Copy link
CopyCopied
Powered by Social Snap