When working within your PhpMyAdmin tool, you have the ability to create and run custom MySQL statements. This can be very helpful if you are performing things like a site move or creating a test site and need to change specific site information stored in the database. Follow the instructions below as we demonstrate how to use manual MySQL statements in your PhpMyAdmin tool.

Using mySQL statements in phpMyAdmin

  1. Log into your cPanel dashboard.
  2. click the phpmyadmin toolOnce in the cpanel dashboard, find the Databases category and click on the phpMyAdmin tool.
  3. choose databaseThis leads you to the main page. From here, look to the left-hand sidebar and click on the name of the database you want to work with. Here, we selected the database named wp962, which is for a WordPress installation.
  4. select database tableNext, you want to select the database table you will be working with. From the sidebar menu click on the name of the table you will be creating the statement for. For our example, we chose the wp_users table.
  5. click SQL tabOnce on the table page, look to the tabs in the upper part of the screen and select the SQL tab.
  6. enter the MySQL statementYou are brought to an editor screen where you can enter your MySQL statement. Once the statement has been entered, click on the Go button in the lower right corner of the screen to run it. In our example, we simply changed the email address of the admin user. Below you can see that the database now has the new email address in the user_email field.
    BeforeAfter
    before the statement was run after the statement was run
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!