InMotion Hosting Support Center

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.
    before the statement was run after the statement was run
Was this article helpful?

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

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Post a Comment

Email Address:
Phone Number:

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?


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:
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!