{"id":3621,"date":"2021-12-07T13:39:59","date_gmt":"2021-12-07T13:39:59","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=3621"},"modified":"2021-12-07T13:40:59","modified_gmt":"2021-12-07T13:40:59","slug":"3621","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/3621\/","title":{"rendered":"How to Rename A Database in phpMyAdmin"},"content":{"rendered":"<p>In this article, you\u2019ll see just by using simple steps how to rename a database in phpMyAdmin. The newest version of phpMyAdmin allows you to modify the database\u2019s name.<\/p>\n<p>Keep in mind that you\u2019ll need to update user permissions and any scripts that reference it,as you alter the name of a database.<\/p>\n<p>Before You Get Started<\/p>\n<p>For cPanel: If you wish the same database user to own access to the renamed database, make a note of the database\u2019s current username, which may or may not be similar to the current database\u2019s name.<\/p>\n<p><strong>1.<\/strong>\u00a0Log into\u00a0<strong>\u201ccPanel Account\u201d<\/strong><\/p>\n<p><strong>2.\u00a0<\/strong>Look for\u00a0<strong>\u201cMySQL\u00aeDatabase\u201d<\/strong>\u00a0in the search\u00a0and click it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3622\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-1-300x37.png\" alt=\"db-phpmyadmin-1\" width=\"976\" height=\"121\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-1-300x37.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-1-768x95.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-1.png 976w\" sizes=\"auto, (max-width: 976px) 100vw, 976px\" \/><\/p>\n<p><strong>3.\u00a0<\/strong>Scroll down the page to the\u00a0<strong>\u201cCurrent Databases section\u201d<\/strong>.<\/p>\n<blockquote class=\"wp-block-quote\"><p><strong>Note:-<\/strong>\u00a0Locate the database you\u2019re about to rename and make a note of or recall the database user who has already been allocated to it.<\/p><\/blockquote>\n<p><strong>4.\u00a0<\/strong>Change the name of the\u00a0<strong>\u201cDatabase\u201d<\/strong>\u00a0by clicking on it. Select the\u00a0<strong>\u201cRemain Option\u201d<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3623\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-2-300x63.png\" alt=\"db-phpmyadmin-2\" width=\"646\" height=\"135\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-2-300x63.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-2.png 646w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><\/p>\n<p><strong>5.\u00a0<\/strong>After clicking on the\u00a0<strong>Rename<\/strong>, you\u2019ll be redirected to a\u00a0<strong>screen\u00a0<\/strong>where you can choose a\u00a0<strong>\u201cNew name\u201d<\/strong>, Click the\u00a0<strong>Proceed button\u00a0<\/strong>after entering the new name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3624\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-3-300x166.png\" alt=\"db-phpmyadmin-3\" width=\"501\" height=\"278\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-3-300x166.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-3.png 501w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/><\/p>\n<p>After pressing the continue button, you\u2019ll notice that your old name has been updated with a new one.<\/p>\n<p>However, If the above steps of this article does not resolve your issue, please feel free to submit a support request and we will happily investigate it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, you\u2019ll see just by using simple steps how to rename a database in phpMyAdmin. The newest version of phpMyAdmin allows you to modify the database\u2019s name. Keep in mind that you\u2019ll need to update user permissions and any scripts that reference it,as you alter the name of a database. Before You Get [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-3621","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=3621"}],"version-history":[{"count":2,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3621\/revisions"}],"predecessor-version":[{"id":3626,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3621\/revisions\/3626"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=3621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=3621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=3621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}