{"id":33694,"date":"2016-09-18T16:39:04","date_gmt":"2016-09-18T16:39:04","guid":{"rendered":"https:\/\/hostduplex.com\/kb\/?p=55"},"modified":"2016-09-18T16:39:04","modified_gmt":"2016-09-18T16:39:04","slug":"how-to-edit-database-table-via-phpmyadmin-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.hostduplex.com\/kb\/how-to-edit-database-table-via-phpmyadmin-in-cpanel\/","title":{"rendered":"How to edit database table via phpMyAdmin in cPanel?"},"content":{"rendered":"<p><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><strong>1.<\/strong> Log into your cPanel account.<\/span><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>2.<\/strong> In the <strong>Databases<\/strong> section, click on the <\/span><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><strong>phpMyAdmin<\/strong><\/span> icon.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-icon.gif\" alt=\"\" align=\"middle\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>3.<\/strong> In left side-bar, Click on the expand button to expand the database like &#8220;example&#8221;.<\/span><\/p>\n<p><span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-expand-db.gif\" alt=\"\" align=\"left\" \/><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>4.<\/strong> Under your cPanel username, you can see a list of all databases. Select an appropriate database which you want to edit, and it will be expanded.<\/p>\n<p><strong>5. <\/strong>Select appropriate table you want to edit like If you want to edit table of WordPress and change blog name from phpMyAdmin then select &#8220;wp-options&#8221;.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-db-list2.gif\" alt=\"\" \/><\/p>\n<p><strong><strong>6. <\/strong><\/strong>Click on <strong>Edit<\/strong> option on 3rd raw.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/wp-table-edit.gif\" align=\"left\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: medium;\"><strong>7.<\/strong> Edit <strong>My Blog<\/strong> to different text and then click on the<strong> Go<\/strong> button.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/wp-table-change.gif\" alt=\"\" align=\"left\" \/><br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: medium;\"><br \/>\nBy this method, you can change the value of SQL data of any software without accessing administrator area like If you can&#8217;t change the theme from administrator area then you can use this method to change the value of SQL and even you can change the password of any account.<br \/>\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like &#8220;example&#8221;. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4. Under your cPanel username, you can see a list of all databases. Select&#8230;<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[57],"tags":[],"class_list":["post-33694","post","type-post","status-publish","format-standard","hentry","category-databases"],"_links":{"self":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts\/33694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/comments?post=33694"}],"version-history":[{"count":0,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts\/33694\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/media?parent=33694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/categories?post=33694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/tags?post=33694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}