{"id":719,"date":"2024-06-18T18:46:18","date_gmt":"2024-06-18T18:46:18","guid":{"rendered":"https:\/\/zalvis.com\/docs\/?p=719"},"modified":"2024-06-18T18:47:46","modified_gmt":"2024-06-18T18:47:46","slug":"how-to-create-separate-database-access","status":"publish","type":"post","link":"https:\/\/zalvis.com\/docs\/how-to-create-separate-database-access.html","title":{"rendered":"How to Create Separate Database Access"},"content":{"rendered":"<p>This is very useful when you want to provide access to one database only within the cPanel account.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-720\" src=\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8275.png\" alt=\"\" width=\"1468\" height=\"736\" srcset=\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8275.png 1468w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8275-300x150.png 300w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8275-1024x513.png 1024w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8275-768x385.png 768w\" sizes=\"auto, (max-width: 1468px) 100vw, 1468px\" \/><\/p>\n<p>You need to create separate phpMyAdmin access though the Softaculous App Installer.<\/p>\n<p>Then install direct phpmyadmin access under your site ulr (like <a href=\"https:\/\/newdomain.com\/phpmyadmin\/\" target=\"_self\" rel=\"noopener\">https:\/\/newdomain.com\/phpmyadmin\/<\/a>), and use it to connect with the database credentials set for your site.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-721\" src=\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8276.png\" alt=\"\" width=\"989\" height=\"416\" srcset=\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8276.png 989w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8276-300x126.png 300w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8276-768x323.png 768w\" sizes=\"auto, (max-width: 989px) 100vw, 989px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-722\" src=\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8277.png\" alt=\"\" width=\"1881\" height=\"885\" srcset=\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8277.png 1881w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8277-300x141.png 300w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8277-1024x482.png 1024w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8277-768x361.png 768w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8277-1536x723.png 1536w\" sizes=\"auto, (max-width: 1881px) 100vw, 1881px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-723\" src=\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8278.png\" alt=\"\" width=\"1617\" height=\"843\" srcset=\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8278.png 1617w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8278-300x156.png 300w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8278-1024x534.png 1024w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8278-768x400.png 768w, https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8278-1536x801.png 1536w\" sizes=\"auto, (max-width: 1617px) 100vw, 1617px\" \/><br \/>\nYou can check how to create MySQL Databases and Users <a href=\"https:\/\/zalvis.com\/docs\/creating-mysql-databases-and-users.html\">here<\/a>.<\/p>\n<div class=\"qvryc69e0f3eb55a27\" >If you enjoyed this article, then you\u2019ll love Zalvis's Cloud Hosting platform. Turbocharge your website and get 24\/7 support from our veteran team. Our world-class hosting infrastructure focuses on auto-scaling, performance, and security. Let us show you the Zalvis difference! <a href=\"https:\/\/zalvis.com\/\">Check out our services.<\/a><\/div><style type=\"text\/css\">\r\n@media screen and (min-width: 1201px) {\r\n.qvryc69e0f3eb55a27 {\r\ndisplay: block;\r\n}\r\n}\r\n@media screen and (min-width: 993px) and (max-width: 1200px) {\r\n.qvryc69e0f3eb55a27 {\r\ndisplay: block;\r\n}\r\n}\r\n@media screen and (min-width: 769px) and (max-width: 992px) {\r\n.qvryc69e0f3eb55a27 {\r\ndisplay: block;\r\n}\r\n}\r\n@media screen and (min-width: 768px) and (max-width: 768px) {\r\n.qvryc69e0f3eb55a27 {\r\ndisplay: block;\r\n}\r\n}\r\n@media screen and (max-width: 767px) {\r\n.qvryc69e0f3eb55a27 {\r\ndisplay: block;\r\n}\r\n}\r\n<\/style>\r\n","protected":false},"excerpt":{"rendered":"<p>This is very useful when you want to provide access to one database only within the cPanel account. You need to create separate phpMyAdmin access though the Softaculous App Installer. Then install direct phpmyadmin access under your site ulr (like https:\/\/newdomain.com\/phpmyadmin\/), and use it to connect with the database credentials set for your site. You [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-719","post","type-post","status-publish","format-standard","hentry","category-cpanel-hosting"],"_links":{"self":[{"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/posts\/719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/comments?post=719"}],"version-history":[{"count":4,"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/posts\/719\/revisions"}],"predecessor-version":[{"id":727,"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/posts\/719\/revisions\/727"}],"wp:attachment":[{"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/media?parent=719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/categories?post=719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zalvis.com\/docs\/wp-json\/wp\/v2\/tags?post=719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}