{"id":1095,"date":"2026-01-13T09:40:00","date_gmt":"2026-01-13T09:40:00","guid":{"rendered":"https:\/\/www.4uhosting.co.uk\/articles\/knowledgebase\/use-phpmyadmin\/"},"modified":"2026-08-19T14:00:46","modified_gmt":"2026-08-19T13:00:46","slug":"use-phpmyadmin","status":"publish","type":"kb_article","link":"https:\/\/www.4uhosting.co.uk\/articles\/knowledgebase\/use-phpmyadmin\/","title":{"rendered":"How to Use phpMyAdmin in cPanel"},"content":{"rendered":"
\"phpMyAdmin<\/a><\/figure>\n

Open phpMyAdmin<\/h2>\n
    \n
  1. Go to Databases > phpMyAdmin<\/strong>.<\/li>\n
  2. Wait for phpMyAdmin to open in a new screen or tab.<\/li>\n<\/ol>\n
    \"phpMyAdmin<\/a><\/figure>\n
      \n
    1. Select the database from the left menu.<\/li>\n<\/ol>\n

      Browse a Table<\/h2>\n
        \n
      1. Select the database.<\/li>\n
      2. Click the table name.<\/li>\n
      3. Click Browse<\/strong>.<\/li>\n
      4. Review the rows in the table.<\/li>\n<\/ol>\n

        Run a SQL Query<\/h2>\n
          \n
        1. Select the database.<\/li>\n
        2. Click SQL<\/strong>.<\/li>\n
        3. Enter the query.<\/li>\n<\/ol>\n
          \"SQL<\/a><\/figure>\n
            \n
          1. Click Go<\/strong>.<\/li>\n<\/ol>\n

            Export a Database<\/h2>\n
              \n
            1. Select the database.<\/li>\n
            2. Click Export<\/strong>.<\/li>\n
            3. Choose Quick<\/strong> for a standard export.<\/li>\n
            4. Choose SQL<\/strong> as the format.<\/li>\n<\/ol>\n
              \"Export<\/a><\/figure>\n
                \n
              1. Click Export<\/strong>.<\/li>\n<\/ol>\n

                Import a Database<\/h2>\n
                  \n
                1. Select the database.<\/li>\n
                2. Click Import<\/strong>.<\/li>\n
                3. Click Choose File<\/strong>.<\/li>\n
                4. Select the SQL file from your computer.<\/li>\n
                5. Click Import<\/strong> or Go<\/strong>.<\/li>\n<\/ol>\n

                  Notes<\/h2>\n
                    \n
                  • phpMyAdmin works directly with database data.<\/li>\n
                  • Export a copy before making major changes.<\/li>\n
                  • Be careful with SQL queries, especially DELETE<\/strong>, DROP<\/strong>, and UPDATE<\/strong> queries.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                    Open phpMyAdmin Go to Databases > phpMyAdmin. Wait for phpMyAdmin to open in a new screen or tab. Select the database from the left…<\/p>\n","protected":false},"author":1,"featured_media":0,"template":"","kb_category":[19],"class_list":["post-1095","kb_article","type-kb_article","status-publish","hentry","kb_category-cpanel-databases"],"_links":{"self":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/1095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article"}],"about":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/types\/kb_article"}],"author":[{"embeddable":true,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":2,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/1095\/revisions"}],"predecessor-version":[{"id":1276,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/1095\/revisions\/1276"}],"wp:attachment":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/media?parent=1095"}],"wp:term":[{"taxonomy":"kb_category","embeddable":true,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_category?post=1095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}