{"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":"

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

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

Before You Get Started<\/p>\n

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

1.<\/strong>\u00a0Log into\u00a0\u201ccPanel Account\u201d<\/strong><\/p>\n

2.\u00a0<\/strong>Look for\u00a0\u201cMySQL\u00aeDatabase\u201d<\/strong>\u00a0in the search\u00a0and click it.<\/p>\n

\"db-phpmyadmin-1\"<\/p>\n

3.\u00a0<\/strong>Scroll down the page to the\u00a0\u201cCurrent Databases section\u201d<\/strong>.<\/p>\n

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

4.\u00a0<\/strong>Change the name of the\u00a0\u201cDatabase\u201d<\/strong>\u00a0by clicking on it. Select the\u00a0\u201cRemain Option\u201d<\/strong>.<\/p>\n

\"db-phpmyadmin-2\"<\/p>\n

5.\u00a0<\/strong>After clicking on the\u00a0Rename<\/strong>, you\u2019ll be redirected to a\u00a0screen\u00a0<\/strong>where you can choose a\u00a0\u201cNew name\u201d<\/strong>, Click the\u00a0Proceed button\u00a0<\/strong>after entering the new name.<\/p>\n

\"db-phpmyadmin-3\"<\/p>\n

After pressing the continue button, you\u2019ll notice that your old name has been updated with a new one.<\/p>\n

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":"

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 […]<\/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"],"yoast_head":"\nHow to Rename A Database in phpMyAdmin - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/3621\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Rename A Database in phpMyAdmin - OWS KB\" \/>\n<meta property=\"og:description\" content=\"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 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/3621\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-07T13:39:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T13:40:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-1-300x37.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3621\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-phpmyadmin-1.png\",\"width\":976,\"height\":121,\"caption\":\"db-phpmyadmin-1\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3621\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/3621\/\",\"name\":\"How to Rename A Database in phpMyAdmin - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/3621\/#primaryimage\"},\"datePublished\":\"2021-12-07T13:39:59+00:00\",\"dateModified\":\"2021-12-07T13:40:59+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/3621\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/3621\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3621\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3621\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/3621\/\",\"name\":\"How to Rename A Database in phpMyAdmin\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_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}]}}