{"id":71,"date":"2011-06-02T11:51:35","date_gmt":"2011-06-02T11:51:35","guid":{"rendered":"http:\/\/blog.nixwind.com\/?p=71"},"modified":"2011-06-02T11:58:14","modified_gmt":"2011-06-02T11:58:14","slug":"database-management-with-ispcp","status":"publish","type":"post","link":"https:\/\/blog.nixwind.com\/?p=71","title":{"rendered":"Database management with IspCP"},"content":{"rendered":"<p>This is a tutorial\/howto on managing Mysql databases with IsPCP<\/p>\n<p><strong>1) Click on &#8220;Manage SQL&#8221;<\/strong><\/p>\n<p><a href=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-sql.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-72\" title=\"ispcp-sql\" src=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-sql-300x79.png\" alt=\"\" width=\"300\" height=\"79\" srcset=\"https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-sql-300x79.png 300w, https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-sql-1024x270.png 1024w, https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-sql.png 1050w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><strong>2) Click on &#8220;Add Sql Database&#8221;<\/strong><\/p>\n<p><a href=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-addsql.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-73\" title=\"ispcp-addsql\" src=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-addsql-300x84.png\" alt=\"\" width=\"300\" height=\"84\" srcset=\"https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-addsql-300x84.png 300w, https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-addsql.png 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Use a desired database name and if you want to have\u00a0 the user id added with the database name check &#8220;Use numeric ID&#8221; box and enable the needed option<\/p>\n<p><strong>3) Click on &#8220;Add SQL user&#8221;<\/strong><\/p>\n<p><a href=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-adddbuser.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-75\" title=\"ispcp-adddbuser\" src=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-adddbuser-300x75.png\" alt=\"\" width=\"300\" height=\"75\" srcset=\"https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-adddbuser-300x75.png 300w, https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-adddbuser-1024x257.png 1024w, https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-adddbuser.png 1188w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-addsqluser.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-74\" title=\"ispcp-addsqluser\" src=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-addsqluser-300x111.png\" alt=\"\" width=\"300\" height=\"111\" srcset=\"https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-addsqluser-300x111.png 300w, https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-addsqluser.png 1023w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>4) Managing database with Phpmyadmin<\/strong><\/p>\n<p>Click on the PhpMyAdmin or you can access it with the url http:\/\/admin.yourserver_name.com\/pma\/<\/p>\n<p><a href=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-phpmyadmin.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-76\" title=\"ispcp-phpmyadmin\" src=\"http:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-phpmyadmin-300x283.png\" alt=\"\" width=\"300\" height=\"283\" srcset=\"https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-phpmyadmin-300x283.png 300w, https:\/\/blog.nixwind.com\/wp-content\/uploads\/2011\/06\/ispcp-phpmyadmin.png 495w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Use database username and password to login to the phpmyadmin<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a tutorial\/howto on managing Mysql databases with IsPCP 1) Click on &#8220;Manage SQL&#8221; 2) Click on &#8220;Add Sql Database&#8221; Use a desired database name and if you want to have\u00a0 the user id added with the database name check &#8220;Use numeric ID&#8221; box and enable the needed option 3) Click on &#8220;Add SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[16,10,15,17],"_links":{"self":[{"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=\/wp\/v2\/posts\/71"}],"collection":[{"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=71"}],"version-history":[{"count":3,"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":78,"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions\/78"}],"wp:attachment":[{"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nixwind.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}