{"id":286,"date":"2023-02-26T14:47:00","date_gmt":"2023-02-26T14:47:00","guid":{"rendered":"https:\/\/blog.trustedhosting.in\/?p=286"},"modified":"2023-02-26T14:47:00","modified_gmt":"2023-02-26T14:47:00","slug":"phpmyadmin-cpanel","status":"publish","type":"post","link":"https:\/\/www.webystrata.com\/blog\/phpmyadmin-cpanel\/","title":{"rendered":"phpMyAdmin &#8211; cPanel"},"content":{"rendered":"<p>The phpMyAdmin is a third-party tool to manage tables and data inside a database. It is graphical user interface to manage MySQL databases. You can manually create Tables, Import and Export data or edit the values of a row through it.<\/p>\n<p>To access phpMyAdmin, click on the phpMyAdmin link, which can be found under the databases section of cPanel Home.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/manage.trustedhosting.in\/index.php?rp=\/images\/kb\/62_php-my-admin.png\" alt=\"phpMyAdmin Link\" width=\"1000\" height=\"221\" \/><\/p>\n<p>You will see a dashboard similar to this.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/manage.trustedhosting.in\/index.php?rp=\/images\/kb\/63_php-my-admin-1.png\" alt=\"phpMyAdmin\" width=\"1000\" height=\"375\" \/><\/p>\n<p>On the left hand pane, there is a list of databases, which can be expended to see the table in each database. On the right hand pane, there is general information of Database server.<\/p>\n<h2>Execute an SQL Query<\/h2>\n<p>To execute an SQL Query on a database, we will need to perform the following steps \u2212<\/p>\n<p><strong>Step 1<\/strong>\u00a0\u2212 Select the database from left pane by clicking over the name of the database. Once the database is selected, it will show you the structure of the database.<\/p>\n<p><strong>Step 2<\/strong>\u00a0\u2212 Click on SQL from top bar to open SQL editor.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/manage.trustedhosting.in\/index.php?rp=\/images\/kb\/64_php-my-admin-png-1.png\" alt=\"SQL Editor\" width=\"1000\" height=\"160\" \/><\/p>\n<p><strong>Step 3<\/strong>\u00a0\u2212 Write your query into the SQL editor. You can also enter multiple queries, separated by semicolon (;).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/manage.trustedhosting.in\/index.php?rp=\/images\/kb\/65_php-my-admin-png-2.png\" alt=\"Multiple Queries\" width=\"1000\" height=\"418\" \/><\/p>\n<p><strong>Step 4<\/strong>\u00a0\u2212 Click\u00a0<strong>Go<\/strong>\u00a0button to execute the query. If the query is executed successfully, you will get a success message<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The phpMyAdmin is a third-party tool to manage tables and data inside a database. It is graphical user interface to&hellip;<\/p>\n","protected":false},"author":1,"featured_media":288,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[12],"class_list":["post-286","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel-complete-tutorials","tag-cpanel-complete-tutorials"],"_links":{"self":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=286"}],"version-history":[{"count":1,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/286\/revisions"}],"predecessor-version":[{"id":291,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/286\/revisions\/291"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/288"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}