{"id":34684,"date":"2022-01-05T17:54:56","date_gmt":"2022-01-05T17:54:56","guid":{"rendered":"https:\/\/www.hostduplex.com\/kb\/?post_type=ht_kb&#038;p=34684"},"modified":"2022-01-05T18:01:56","modified_gmt":"2022-01-05T18:01:56","slug":"how-to-run-a-query-in-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/www.hostduplex.com\/kb\/article\/how-to-run-a-query-in-phpmyadmin\/","title":{"rendered":"How to run a query in phpMyAdmin"},"content":{"rendered":"\n<p>1. Log in to your cPanel account<\/p>\n\n\n\n<p>2. Click on phpMyAdmin. You can find it by using the search bar or by scrolling to the Databases section<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"454\" src=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1024x454.png\" alt=\"\" class=\"wp-image-34685\" srcset=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1024x454.png 1024w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-300x133.png 300w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-768x340.png 768w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-50x22.png 50w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-1536x681.png 1536w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-60x27.png 60w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM-100x44.png 100w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.15.54-PM.png 1852w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Once on the phpMyAdmin homepage, go to the area where you want to run your SQL query. You can do it from the homepage (if you want the query to apply to the whole server), on a database or a table<\/p>\n\n\n\n<p>4. Once on the correct location, click on the SQL tab<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"496\" src=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.16.59-PM-1024x496.png\" alt=\"\" class=\"wp-image-34686\" srcset=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.16.59-PM-1024x496.png 1024w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.16.59-PM-300x145.png 300w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.16.59-PM-768x372.png 768w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.16.59-PM-50x24.png 50w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.16.59-PM-1536x744.png 1536w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.16.59-PM-60x29.png 60w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.16.59-PM-100x48.png 100w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.16.59-PM.png 1880w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>5. From here, you can type in your query and then click the &#8216;Go&#8217; button at the bottom right<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"319\" src=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.18.02-PM-1024x319.png\" alt=\"\" class=\"wp-image-34687\" srcset=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.18.02-PM-1024x319.png 1024w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.18.02-PM-300x93.png 300w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.18.02-PM-768x239.png 768w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.18.02-PM-50x16.png 50w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.18.02-PM-1536x478.png 1536w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.18.02-PM-2048x638.png 2048w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.18.02-PM-60x19.png 60w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2022\/01\/Screen-Shot-2022-01-05-at-12.18.02-PM-100x31.png 100w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-text-color has-background has-purple-background-color has-purple-color is-style-dots\"\/>\n\n\n\n<p><meta charset=\"utf-8\">If you are a Host Duplex customer and still have questions, please open a ticket in the\u00a0<a href=\"https:\/\/secure.hostduplex.com\/clientarea.php\" target=\"_blank\" rel=\"noopener\">Host Duplex client portal.<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Log in to your cPanel account 2. Click on phpMyAdmin. You can find it by using the search bar or by scrolling to the Databases section 3. Once on the phpMyAdmin homepage, go to the area where you want to run your SQL query. You can do it from&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[20],"ht-kb-tag":[23,254,144,253],"class_list":["post-34684","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cpanel","ht_kb_tag-cpanel","ht_kb_tag-databases","ht_kb_tag-phpmyadmin","ht_kb_tag-queries"],"_links":{"self":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/comments?post=34684"}],"version-history":[{"count":2,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34684\/revisions"}],"predecessor-version":[{"id":34689,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34684\/revisions\/34689"}],"wp:attachment":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/media?parent=34684"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=34684"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=34684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}