{"id":2449,"date":"2011-07-27T13:52:36","date_gmt":"2011-07-27T13:52:36","guid":{"rendered":"http:\/\/www.bodhost.com\/web-hosting\/?p=2449"},"modified":"2026-02-26T14:04:34","modified_gmt":"2026-02-26T14:04:34","slug":"steps-to-share-a-mysql-database-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/","title":{"rendered":"Steps to Share a MySQL Database in Cpanel"},"content":{"rendered":"\r\n

cPanel is one of the popular control panels. It allows the webmaster to control a number of key server features, such as management of the email accounts, database, etc…Each website has its own database, but sometime a person will run multiple websites that share similar content. In this case, a perfect solution is to allow the websites to share the same database. (Note: possibly it will increase the load on your database). This is simple to set up through the cPanel user interface.<\/p>\r\n\r\n\r\n\r\n

    \r\n
  1. Log in to the cPanel control panel with the help of a given username and password by a web host. To access the cPanel panel interface type your website domain into the web browser like below:
    http:\/\/www.website.com\/cpanel<\/li>\r\n
  2. Move down to the cPanel control panel until you see the databases section. You will see an icon name as a MySQL database. Click on that option to enter in the MySQL administration section.<\/li>\r\n
  3. Make a new MySQL database. The top field of the administration area is marked for creating new databases. Search the name you want to use for your database, then click the \u201cCreate Database” button to have cPanel create the database for you. Remember, that if you already have a database and are just increasing how many sites can use it, this step can be skipped.<\/li>\r\n
  4. Create user accounts for the database. The second section of the MySQL administration section is for adding database users. Create a new user_name and password for each website that will be sharing a website by clicking the Create \u201cUser\u201d button to produce each user account. Then, scroll down to Add User in order to link each user account to the database and to find out how much access each account will have.<\/li>\r\n
  5. Go back to the cPanel home page to access the phpmyadmin database management section. Scroll down and you will see the phpmyadmin option. Click that icon to enter the phpmyadmin section.<\/li>\r\n
  6. Choose your database from the list of databases on the left hand of the screen, then steer to the access controls section of the database. Inside access controls, go to the remote SQL section and get into the IP address of each website that will be sharing the database. Enter the IP addresses one at a time, by clicking the “Add Host” button after each one. The web host for the websites can provide the IP addresses if they are unknown.<\/li>\r\n
  7. Update the configuration file; typically labeled as a config.php for each website to indicate the proper database credentials. Refer back to the MySQL database user accounts you made for each website.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n","protected":false},"excerpt":{"rendered":"

    cPanel is one of the popular control panels. It allows the webmaster to control a number of key server features, such as management of the email accounts, database, etc…Each website…<\/p>\n

    Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[370],"tags":[193,229],"class_list":["post-2449","post","type-post","status-publish","format-standard","hentry","category-control-panels","tag-cpanel","tag-mysql-database"],"yoast_head":"\nSteps to Share a MySQL Database in Cpanel<\/title>\n<meta name=\"description\" content=\"Learn how to efficiently share a MySQL database in cPanel with step-by-step instructions. Simplify collaboration and access your database securely.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Steps to Share a MySQL Database in Cpanel\" \/>\n<meta property=\"og:description\" content=\"Learn how to efficiently share a MySQL database in cPanel with step-by-step instructions. Simplify collaboration and access your database securely.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - bodHOST\" \/>\n<meta property=\"article:published_time\" content=\"2011-07-27T13:52:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-26T14:04:34+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/steps-to-share-a-mysql-database-in-cpanel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/steps-to-share-a-mysql-database-in-cpanel\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/c48414ad1536cea20e85282b0737a9f9\"},\"headline\":\"Steps to Share a MySQL Database in Cpanel\",\"datePublished\":\"2011-07-27T13:52:36+00:00\",\"dateModified\":\"2026-02-26T14:04:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/steps-to-share-a-mysql-database-in-cpanel\\\/\"},\"wordCount\":449,\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"keywords\":[\"cPanel\",\"MySQL Database\"],\"articleSection\":[\"Control Panels\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/steps-to-share-a-mysql-database-in-cpanel\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/steps-to-share-a-mysql-database-in-cpanel\\\/\",\"name\":\"Steps to Share a MySQL Database in Cpanel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\"},\"datePublished\":\"2011-07-27T13:52:36+00:00\",\"dateModified\":\"2026-02-26T14:04:34+00:00\",\"description\":\"Learn how to efficiently share a MySQL database in cPanel with step-by-step instructions. Simplify collaboration and access your database securely.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/steps-to-share-a-mysql-database-in-cpanel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/steps-to-share-a-mysql-database-in-cpanel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/steps-to-share-a-mysql-database-in-cpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Control Panels\",\"item\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/category\\\/control-panels\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Steps to Share a MySQL Database in Cpanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"alternateName\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"width\":240,\"height\":240,\"caption\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/c48414ad1536cea20e85282b0737a9f9\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Steps to Share a MySQL Database in Cpanel","description":"Learn how to efficiently share a MySQL database in cPanel with step-by-step instructions. Simplify collaboration and access your database securely.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"Steps to Share a MySQL Database in Cpanel","og_description":"Learn how to efficiently share a MySQL database in cPanel with step-by-step instructions. Simplify collaboration and access your database securely.","og_url":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/","og_site_name":"Knowledge Base - bodHOST","article_published_time":"2011-07-27T13:52:36+00:00","article_modified_time":"2026-02-26T14:04:34+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/#article","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/"},"author":{"name":"admin","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/c48414ad1536cea20e85282b0737a9f9"},"headline":"Steps to Share a MySQL Database in Cpanel","datePublished":"2011-07-27T13:52:36+00:00","dateModified":"2026-02-26T14:04:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/"},"wordCount":449,"publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"keywords":["cPanel","MySQL Database"],"articleSection":["Control Panels"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/","url":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/","name":"Steps to Share a MySQL Database in Cpanel","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/#website"},"datePublished":"2011-07-27T13:52:36+00:00","dateModified":"2026-02-26T14:04:34+00:00","description":"Learn how to efficiently share a MySQL database in cPanel with step-by-step instructions. Simplify collaboration and access your database securely.","breadcrumb":{"@id":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.bodhost.com\/kb\/steps-to-share-a-mysql-database-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Control Panels","item":"https:\/\/www.bodhost.com\/kb\/category\/control-panels\/"},{"@type":"ListItem","position":2,"name":"Steps to Share a MySQL Database in Cpanel"}]},{"@type":"WebSite","@id":"https:\/\/www.bodhost.com\/kb\/#website","url":"https:\/\/www.bodhost.com\/kb\/","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","description":"","publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"alternateName":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bodhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bodhost.com\/kb\/#organization","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","url":"https:\/\/www.bodhost.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","width":240,"height":240,"caption":"Web Hosting Knowledge Base | bodHOST Hosting FAQ"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/c48414ad1536cea20e85282b0737a9f9","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.bodhost.com\/kb\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/2449","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/comments?post=2449"}],"version-history":[{"count":6,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/2449\/revisions"}],"predecessor-version":[{"id":12337,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/2449\/revisions\/12337"}],"wp:attachment":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/media?parent=2449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/categories?post=2449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/tags?post=2449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}