How to show running MySQL queries in SiteWorx

How to show running MySQL queries in SiteWorx 

If you are a Nexcess client on a physical (non-cloud) server, you can use phpMyAdmin from your SiteWorx account to show running MySQL queries with the following procedure.

ATTENTION: If you are a Nexcess Cloud client, see instead How to generate and view SSH/FTP passwords for your Nexcess Cloud Account and How to add SSH keys for your Nexcess Cloud account.

  1. Log in to your SiteWorx account.

    • If you do not know your password, click Forgot your password on the login page.
    • If you do not know the web address for your SiteWorx login page, either refer to your Welcome Email or contact our 24-hour Support Team for assistance.
  2. On the left, select Hosting Features > MySQL > PhpMyAdmin.

  1. Select the correct database from the list on the left.

  1. Click the SQL tab.

  1. In the Run SQL query/queries on database DATABASE_NAME field, enter the following:

    show full processlist;

  2. Click Go on the far right.

 

For 24-hour assistance any day of the year, contact our Support Team by email or through the Client Portal.

Article Rating (1 Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
 
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to create MySQL databases with SiteWorx
Added on Mon, Mar 25, 2019
How to change email account passwords in SiteWorx
Added on Wed, Dec 19, 2018
How to truncate MySQL tables in Nexcess Cloud
Added on Mon, Dec 17, 2018
How to configure DNS records in SiteWorx
Added on Wed, Mar 13, 2019
How to download backup files with SiteWorx
Added on Tue, Dec 18, 2018
How to add FTP accounts with SiteWorx
Added on Mon, Jun 11, 2018
How to enable SSH access
Added on Mon, Dec 17, 2018
How to repair MySQL tables
Added on Fri, Sep 14, 2018
How to resolve the SSL warning when logging in to SiteWorx
Added on Wed, Mar 11, 2015
How to change the password for a MySQL database user
Added on Wed, Dec 19, 2018