How to manage databases with phpMyAdmin

{"/api/v1/ncpl/currencies/getAll":{"body":[{"Name":"U.S. Dollar","Code":"USD","Symbol":"$","Separator":".","Culture":"en-US"},{"Name":"Euro","Code":"EUR","Symbol":"€","Separator":",","Culture":"en-US"},{"Name":"British Pound","Code":"GBP","Symbol":"£","Separator":".","Culture":"en-US"},{"Name":"Canadian Dollars","Code":"CAD","Symbol":"C$","Separator":".","Culture":"en-US"},{"Name":"Australian Dollars","Code":"AUD","Symbol":"A$","Separator":".","Culture":"en-US"},{"Name":"Indian Rupees","Code":"INR","Symbol":"Rs","Separator":".","Culture":"en-US"},{"Name":"China Yuan RMB","Code":"CNY","Symbol":"¥","Separator":".","Culture":"en-US"}],"status":200,"statusText":"OK"},"/api/v1/ncpl/usermanagement/uiuser/getHeaderUserInfo:\"{\\\"hideSupportPin\\\":true}\"":{"body":{"__ctxId":"898A7870B14246E38799460AD86E7B81","__isError":true,"__errorType":"Nc.Platform.Abstractions.UnauthorizedException","Http_WWW_Authenticate":"Bearer","StatusCode":"Unauthorized","LogLevel":3,"Message":"","InnerException":null,"HelpLink":null,"Source":"Nc.Security.Middleware"},"status":401,"statusText":"Unauthorized"},"/api/v1/ncpl/cart/user/getShoppingCartSummary:\"{\\\"finalTotalOnly\\\":true}\"":{"body":null,"status":200,"statusText":"OK"}}

{"/api/v1/ncpl/simplekb/getarticle:\"{\\\"articleId\\\":9540,\\\"categoryId\\\":2180}\"":{"body":{"Id":9540,"FriendlyId":"","ArticleTypeId":3,"Title":"How to manage databases with phpMyAdmin","ArticleName":"How to manage databases with phpMyAdmin","ArticleSummary":null,"PreponedSummary":false,"Approved":true,"Body":"DQoJCTxwIHN0eWxlPSJ0ZXh0LWluZGVudDogMjVweDsiPnBocE15QWRtaW4gaXMgYW4gYXBwbGljYXRpb24gZm9yIE15U1FMIGRhdGFiYXNlcyBtYW5hZ2VtZW50LiBXaXRoIGl0IHlvdSBjYW4gY3JlYXRlLCBhbHRlciwgZHJvcCwgZGVsZXRlLCBpbXBvcnQgYW5kIGV4cG9ydCBNeVNRTCBkYXRhYmFzZSB0YWJsZXMuIFlvdSBjYW4gYWxzbyBydW4gTXlTUUwgcXVlcmllcywgb3B0aW1pemUsIHJlcGFpciBhbmQgY2hlY2sgdGFibGVzLCBjaGFuZ2UgY29sbGF0aW9uLg0KDQogICA8YnIgLz48YnIgLz48Yj5OT1RFOjwvYj4gTWFrZSBzdXJlIHRoZSBkYXRhYmFzZSB5b3Ugd291bGQgbGlrZSB0byBtYW5hZ2UgaXMgYWxyZWFkeSBjcmVhdGVkIGluIHRoZSA8YSBocmVmPSJodHRwczovL3d3dy5uYW1lY2hlYXAuY29tL3N1cHBvcnQva25vd2xlZGdlYmFzZS9hcnRpY2xlLmFzcHgvOTM2My8yMTgwL2hvdy10by1jcmVhdGUtYW5kLW1haW50YWluLW15c3FsLWRhdGFiYXNlcy1pbi1jcGFuZWwiPk15U1FMIERhdGFiYXNlczwvYT4gbWVudS4NCg0KPC9wPg0KCQk8Yj4NCgkJPC9iPg0KCQk8YnIgLz5UaGUgPGI+cGhwTXlBZG1pbjwvYj4gbWVudSBpbiBsb2NhdGVkIGluIDxiPmNQYW5lbDwvYj4gJmd0OyZndDsgPGI+RGF0YWJhc2VzPC9iPiBzZWN0aW9uLg0KDQo8YnIgLz48ZGl2PjxiciAvPjwvZGl2PjxkaXY+PGI+PGEgbmFtZT0icGFwZXJfbGFudGVybiI+Zm9yIGNQYW5lbCBwYXBlcl9sYW50ZXJuIHRoZW1lOjwvYT48L2I+PC9kaXY+PGRpdj48Yj48YSBuYW1lPSJwYXBlcl9sYW50ZXJuIj48YnIgLz48L2E+PC9iPjwvZGl2PjxpbWcgY2xhc3M9ImtiLWltYWdlIiBzcmM9Imh0dHBzOi8vTmFtZWNoZWFwLnNpbXBsZWtiLmNvbS9TaXRlQ29udGVudHMvMi03QzIyRDUyMzZBNDU0M0VCODI3RjNCRDg5MzZFMTUzRS9tZWRpYS9wbF9waHBteWFkbWluXzEucG5nIiAvPjxiciAvPjxiciAvPjxkaXY+PGltZyBjbGFzcz0ia2ItaW1hZ2UiIHNyYz0iaHR0cHM6Ly9OYW1lY2hlYXAuc2ltcGxla2IuY29tL1NpdGVDb250ZW50cy8yLTdDMjJENTIzNkE0NTQzRUI4MjdGM0JEODkzNkUxNTNFL21lZGlhL3BsX3BocG15YWRtaW5fMi5wbmciIC8+PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PjxiPmZvciBjUGFuZWwgeDMgdGhlbWU6PC9iPjwvZGl2PjxkaXY+PGI+PC9iPjxiciAvPjwvZGl2PjxkaXY+PGltZyBjbGFzcz0ia2ItaW1hZ2UiIHNyYz0iaHR0cHM6Ly9OYW1lY2hlYXAuc2ltcGxla2IuY29tL1NpdGVDb250ZW50cy8yLTdDMjJENTIzNkE0NTQzRUI4MjdGM0JEODkzNkUxNTNFL21lZGlhL2NwX3BocF9hZG1pbi5wbmciIC8+PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PjxpbWcgY2xhc3M9ImtiLWltYWdlIiBzcmM9Imh0dHBzOi8vTmFtZWNoZWFwLnNpbXBsZWtiLmNvbS9TaXRlQ29udGVudHMvMi03QzIyRDUyMzZBNDU0M0VCODI3RjNCRDg5MzZFMTUzRS9tZWRpYS9waHBteWFkMi5wbmciIC8+PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PkZvciBxdWljayBhY2Nlc3MgdG8gdGhlIDxiPnBocE15QWRtaW48L2I+LCB5b3UgY2FuIHVzZSBvdXIgPGEgaHJlZj0iaHR0cHM6Ly93d3cubmFtZWNoZWFwLmNvbS9zdXBwb3J0L2tub3dsZWRnZWJhc2UvYXJ0aWNsZS5hc3B4LzEwMTMyLzI3L3doZXJlLWNhbi1pLWxvZy1pbnRvLW15LWNwYW5lbC1ob3N0aW5nLWFjY291bnQjY1BhbmVsJTIwU2hvcnRjdXRzIiBsaW5rdGV4dD0iY1BhbmVsIHNob3J0Y3V0cyIgbGlua3R5cGU9IkN1c3RvbSIgdGFyZ2V0PSJfcGFyZW50Ij5jUGFuZWwgU2hvcnRjdXRzPC9hPiBpbiB0aGUgTmFtZWNoZWFwIGFjY291bnQuPGJyIC8+PC9kaXY+PHA+PC9wPjxwIHN0eWxlPSJ0ZXh0LWluZGVudDogMjVweDsiPkxldOKAmXMgdGFrZSBhIGxvb2sgYXQgdGhlIG1vc3Qgd2lkZWx5IHVzZWQgdGFicy4gDQo8YnIgLz48YnIgLz48Yj5EYXRhYmFzZXMNCjwvYj48YnIgLz48YnIgLz5UaGUgRGF0YWJhc2VzIHRhYiBsaXN0cyBhbGwgdGhlIGRhdGFiYXNlcyB3aGljaCBjYW4gYmUgbWFuYWdlZCB0aHJvdWdoIHRoZSBjUGFuZWwgdXNlci4NCjxiciAvPklmIHlvdSBlbmFibGUgdGhlIHN0YXRpc3RpY3MgZm9yIHRoZSBkYXRhYmFzZXMsIHlvdSB3aWxsIHNlZSBhIHRhYmxlIHdpdGggdGhlIHVzZWQgY29sbGF0aW9ucywgdGhlIG51bWJlciBvZiB0aGUgdGFibGVzIGFuZCByb3dzLCB0aGUgc2l6ZSBvZiB0aGUgZGF0YSBhbmQgaW5kZXhlcywgdGhlIHRvdGFsIHNpemUgYW5kIHRoZSBvdmVyaGVhZC4NCg0KPGJyIC8+PGJyIC8+PGI+U1FMPC9iPjxiciAvPjxiciAvPkluIHRoaXMgdGFiIHlvdSBjYW4gcnVuIFNRTCBxdWVyaWVzIGVpdGhlciBieSBlbnRlcmluZyB0aGUgZW50aXJlIFNRTCBxdWVyeSBjb2RlIG9yIG1hbnVhbGx5ICBkZWZpbmluZyB0aGUgcGFyYW1ldGVycyBvZiB0aGUgcXVlcnkuIDxiciAvPktlZXAgaW4gbWluZCB0aGF0IHRoaXMgdGFiIGlzIGNvbnRleHQtc2Vuc2l0aXZlLCB3aGljaCBtZWFucyB0aGF0IGRlcGVuZGluZyBvbiB3aGF0IHlvdSdyZSBsb29raW5nIGF0LCB0aGUgdGFyZ2V0IG9mIHlvdXIgU1FMIHF1ZXJpZXMgbWlnaHQgYmUgZGlmZmVyZW50LCBlLmcuLCBpZiB5b3UgYXJlIG9uIHRoZSBob21lIHBhZ2Ugb2YgcGhwTXlBZG1pbiBhbmQgZG8gbm90IGhhdmUgYW55IGRhdGFiYXNlcyBzZWxlY3RlZCwgaWYgeW91IGNsaWNrIG9uIHRoZSBTUUwgdGFiLCBhbnkgcXVlcmllcyB5b3UgcnVuIHdpbGwgYXBwbHkgdG8gdGhlIG92ZXJhbGwgc2VydmVyIChvciBob3N0aW5nIGFjY291bnQgaWYgb24gc2hhcmVkIGhvc3RpbmcpLiANCg0KDQoNCg0KPGJyIC8+PGJyIC8+PGI+RXhwb3J0PC9iPjxiciAvPjxiciAvPlRoZSBFeHBvcnQgdGFiIGFsbG93cyB5b3UgdG8gZXhwb3J0IHRoZSBkYXRhYmFzZSB0YWJsZXMgY29udGVudCBpbiBkaWZmZXJlbnQgZm9ybWF0cyAg4oCTIENTViwgU1FMLCBQREYsIE1pY3Jvc29mdCBFeGNlbCwgTWljcm9zb2Z0IFdvcmQsIFhNTCwgZXRjLiBZb3UgY2FuIHNlbGVjdCBlaXRoZXIgYWxsIHRoZSBkYXRhYmFzZSB0YWJsZXMgb3IgY2hvb3NlIHNwZWNpZmljIG9uZXMuIDxiciAvPlRoaXMgdGFiIGlzIGFsc28gY29udGV4dC1zZW5zaXRpdmUgLSB5b3UgY2FuIGVpdGhlciBleHBvcnQgYWxsIGRhdGFiYXNlcyBvciBhIHNpbmdsZSBkYXRhYmFzZS90YWJsZS4NCg0KPGJyIC8+PGJyIC8+PGI+SW1wb3J0PC9iPjxiciAvPjxiciAvPlRoZSBJbXBvcnQgdGFiIGFsbG93cyB5b3UgdG8gaW1wb3J0IHlvdXIgZGF0YWJhc2UgdGFibGVzIGZyb20gYSBmaWxlIHNhdmVkIG9uIHlvdXIgbG9jYWwgY29tcHV0ZXIuDQogICAgPGJyIC8+PGJyIC8+PGI+Tk9URTo8L2I+IFlvdSBjYW4gb25seSBpbXBvcnQgdGhlIGRhdGFiYXNlcyB0aGF0IGFyZSB1bmRlciAxIEdCLiBJZiB5b3UgZGF0YWJhc2UgYmFja3VwIGlzIGJpZ2dlciB0aGFuIHRoaXMsIHlvdSB3aWxsIG5lZWQgbmVlZCB0byA8YSBocmVmPSJodHRwczovL3d3dy5uYW1lY2hlYXAuY29tL3N1cHBvcnQva25vd2xlZGdlYmFzZS9hcnRpY2xlLmFzcHgvOTE4NC84OS9ob3ctdG8taW1wb3J0LWFuZC1leHBvcnQtZGF0YWJhc2UtdmlhLXNzaCI+aW1wb3J0IGl0IHZpYSBTU0g8L2E+Lg0KDQoNCjxiciAvPjxiciAvPjxiciAvPjxiPkRhdGFiYXNlIE1hbmFnZW1lbnQ8L2I+PGJyIC8+PGJyIC8+PGJyIC8+R28gdG8gdGhlIDxiPkRhdGFiYXNlczwvYj4gdGFiIGFuZCBjbGljayBvbiB0aGUgZGF0YWJhc2UgeW91IHdvdWxkIGxpa2UgdG8gbWFuYWdlOjxiciAvPsKgPGJyIC8+PGltZyBjbGFzcz0ia2ItaW1hZ2UiIHNyYz0iaHR0cHM6Ly9OYW1lY2hlYXAuc2ltcGxla2IuY29tL1NpdGVDb250ZW50cy8yLTdDMjJENTIzNkE0NTQzRUI4MjdGM0JEODkzNkUxNTNFL21lZGlhL3BsX3BocG15YWRtaW5fMy5wbmciIC8+PGJyIC8+PGJyIC8+PGJyIC8+VGhlbiBjcmVhdGUgYSB0YWJsZToNCjxiciAvPjxiciAvPjEuIEVudGVyIHRoZSBuYW1lIG9mIHlvdXIgdGFibGUgaW4gdGhlIGZpZWxkIDxiPk5hbWU8L2I+PGJyIC8+Mi4gRW50ZXIgdGhlIG51bWJlciBvZiBjb2x1bW5zIGluIHRoZSBmaWVsZCA8Yj5OdW1iZXIgb2YgQ29sdW1uczwvYj48YnIgLz4zLiBDbGljayBvbiA8Yj5HbzwvYj4gdG8gcHJvY2VlZCB0byB0aGUgbmV4dCBzY3JlZW48YnIgLz40LiBEZWZpbmUgdGhlIGNvbHVtbihzKSBieSBwcm92aWRpbmcgdGhlIGZvbGxvd2luZyBpbmZvcm1hdGlvbjoNCjxiciAvPsKgwqAgNC4xLiBOYW1lDQo8YnIgLz7CoMKgIDQuMi4gU2VsZWN0IHRoZSA8Yj5UeXBlPC9iPiBvZiBkYXRhIGZvciB0aGUgY29sdW1uLiAgU29tZSBjb21tb24gdHlwZXMgaW5jbHVkZTogPGJyIC8+PC9wPjx1bD48bGk+DQoNCg0KDQpJTlQgPSBJbnRlZ2VyIChhIG51bWJlciB3aXRob3V0IGEgZGVjaW1hbCBwb2ludCkgPGJyIC8+PC9saT48bGk+Q0hBUiA9IENoYXJhY3RlcnMgKHRleHQgdXAgdG8gYSBzcGVjaWZpYyBsZW5ndGgpIDxiciAvPjwvbGk+PGxpPlZBUkNIQVIgPSBWYXJpYWJsZSBMZW5ndGggQ2hhcmFjdGVycyAoZG9lcyBub3QgaGF2ZSBhIGZpeGVkIHdpZHRoKSA8YnIgLz48L2xpPjxsaT5URVhUID0gZm9yIGhvbGRpbmcgbGFyZ2UgYW1vdW50cyBvZiB0ZXh0IDxiciAvPjwvbGk+PGxpPkRBVEUgPSBvbmx5IGZvciBkYXRlcyA8YnIgLz48L2xpPjxsaT5EQVRFVElNRSA9IG9ubHkgZm9yIGEgZGF0ZSBhbmQgdGltZSBmb3JtYXQuIA0KCQkNCg0KDQo8L2xpPjwvdWw+wqDCoCA0LjMuIERlZmluZSB0aGUgPGI+TGVuZ3RoL1ZhbHVlczwvYj4gaWYgcmVxdWlyZWQuICBGb3IgZXhhbXBsZSwgZm9yIHRoZSBDSEFSIHR5cGUgeW91IHdpbGwgbmVlZCB0byBzcGVjaWZ5IHRoZSBtYXhpbXVtIG51bWJlciBvZiBjaGFyYWN0ZXJzIGFsbG93ZWQuDQo8YnIgLz7CoMKgIDQuNC4gVGhlIG90aGVyIGZpZWxkcyBhcmUgb3B0aW9uYWwuDQo8YnIgLz48YnIgLz41LiBDbGljayBvbiA8Yj5TYXZlPC9iPiBvbmNlIHlvdSBhcmUgZmluaXNoZWQuDQo8YnIgLz48YnIgLz5UaGUgcG9zc2libGUgYWN0aW9ucyB5b3UgY2FuIHBlcmZvcm0gdG8gYSBjaG9zZW4gdGFibGUgYXJlOiBCcm93c2UsIFN0cnVjdHVyZSwgU2VhcmNoLCBJbnNlcnQsIEVtcHR5IGFuZCBEcm9wOg0KDQo8YnIgLz48YnIgLz48aW1nIGNsYXNzPSJrYi1pbWFnZSIgc3JjPSJodHRwczovL05hbWVjaGVhcC5zaW1wbGVrYi5jb20vU2l0ZUNvbnRlbnRzLzItN0MyMkQ1MjM2QTQ1NDNFQjgyN0YzQkQ4OTM2RTE1M0UvbWVkaWEvcGxfcGhwbXlhZG1pbl80LnBuZyIgLz48YnIgLz48YnIgLz48YnIgLz48Yj5Ccm93c2U8L2I+PGJyIC8+PGJyIC8+T25seSB0aGUgdGFibGVzIHdpdGggZXhpc3RpbmcgcmVjb3JkcyBjYW4gYmUgYnJvd3NlZC4gT25jZSB5b3UgY2xpY2sgb24gdGhlIEJyb3dzZSBpY29uLCBhIG5ldyB3aW5kb3cgd2l0aCB0aGUgcmVjb3JkcyBsaXN0IHdpbGwgYmUgb3BlbmVkLg0KWW91IGNhbiBlZGl0IHRoZSBjaG9zZW4gcmVjb3JkIGJ5IGNsaWNraW5nIG9uIHRoZSBQZW4gaWNvbi4gWW91IHdpbGwgc2VlIHRoZW4gdGhlIHJlY29yZCBzdHJ1Y3R1cmUgYW5kIHdpbGwgYmUgYWJsZSB0byBtb2RpZnkgdGhlIHZhbHVlcyBvZiB0aGUgcmVjb3Jkcy4NCjxiciAvPsKgPGJyIC8+PGI+U3RydWN0dXJlPC9iPjxiciAvPjxiciAvPlRoZSBTdHJ1Y3R1cmUgc2NyZWVuIHNob3dzIHlvdSB0aGUgZGF0YWJhc2UncyB0YWJsZSBzdHJ1Y3R1cmUuIEl0IHNob3dzIHlvdSB0aGUgZmllbGRzJyBuYW1lcywgdGhlaXIgdHlwZXMsIGNvbGxhdGlvbnMsIGF0dHJpYnV0ZXMsIGFkZGl0aW9uYWwgaW5mb3JtYXRpb24sICB0aGUgZGVmYXVsdCB2YWx1ZXMgYW5kIHdoZXRoZXIgdGhlIGZpZWxkcycgdmFsdWVzIGNhbiBiZSBOVUxMLiANCjxiciAvPjxiciAvPjxiPlNlYXJjaDwvYj48YnIgLz48YnIgLz5UaHJvdWdoIHRoZSBTZWFyY2ggYWN0aW9uIHlvdSBjYW4gZ2VuZXJhdGUgYSBzZWFyY2ggcXVlcnkgZm9yIHRoZSBjaG9zZW4gdGFibGUuDQpZb3UgY2FuIGVpdGhlciB3cml0ZSB0aGUgV0hFUkUgY2xhdXNlLCBvciB5b3UgY2FuIHVzZSB0aGUgInF1ZXJ5IGJ5IGV4YW1wbGUiIGZ1bmN0aW9uYWxpdHkuIFlvdSBzaG91bGQgY2xpY2sgb24gdGhlIDxiPkdvIDwvYj5idXR0b24gdG8gZXhlY3V0ZSB0aGUgcXVlcnkuDQoNCjxiciAvPjxiciAvPjxiPkluc2VydDwvYj48YnIgLz48YnIgLz5Vc2luZyB0aGUgPGI+SW5zZXJ0IDwvYj5hY3Rpb24geW91IGNhbiBpbnNlcnQgcmVjb3JkcyBpbiB5b3VyIGRhdGFiYXNlIHRhYmxlLg0KT25jZSB5b3UgZmlsbCBpbiB0aGUgY29ycmVzcG9uZGluZyB2YWx1ZXMsIGNsaWNrIG9uIHRoZSA8Yj5HbyA8L2I+YnV0dG9uIGFuZCB0aGUgbmV3IHJlY29yZCB3aWxsIGJlIGluc2VydGVkLg0KPGJyIC8+PGJyIC8+PGI+RW1wdHk8L2I+PGJyIC8+PGJyIC8+VGhlIDxiPkVtcHR5IDwvYj5hY3Rpb24gYWxsb3dzIHlvdSB0byBlbXB0eSB5b3VyIGRhdGFiYXNlIHRhYmxlLCByZW1vdmluZyB0aGUgZGF0YSBhbmQga2VlcGluZyB0aGUgZW1wdHkgdGFibGUuDQo8YnIgLz48YnIgLz48Yj5Ecm9wPC9iPjxiciAvPjxiciAvPlRocm91Z2ggdGhlIDxiPkRyb3AgPC9iPmFjdGlvbiB5b3UgY2FuIGRlbGV0ZSB0aGUgd2hvbGUgdGFibGUgYW5kIGFsbCB0aGUgcmVjb3JkcyBzdG9yZWQgaW4gaXQuDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoNCg0KDQoJDQoNCg0KDQoNCjxiciAvPjxiciAvPjxiciAvPjxiciAvPjxiciAvPlRoYXQncyBpdCE8YnIgLz48YnIgLz4NCsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgPGJyIC8+wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIE5lZWQgYW55IGhlbHA/IENvbnRhY3Qgb3VyIDxhIGhyZWY9Imh0dHBzOi8vd3d3Lm5hbWVjaGVhcC5jb20vc3VwcG9ydC5hc3B4Ij5IZWxwRGVzazwvYT48YnIgLz48YnIgLz48cD48L3A+PHA+PC9wPg==","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"2020-01-31T09:18:47.0000000","LiveDateTime":"1754-02-02T00:00:00.0000000","CreatedDateTime":"2015-04-09T13:56:43.0000000","ApprovalDatetime":"2015-04-09T14:39:29.0000000","RequestCount":30403,"MarkedAsNew":false,"MarkedAsFeatured":false,"RatingValue":2,"CategoryPaths":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryPathDto","Level":1,"CategoryId":12,"CategoryName":"Hosting"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryPathDto","Level":2,"CategoryId":2180,"CategoryName":"MySQL questions"}],"AssociatedCategories":[{"CategoryId":2180,"CategoryName":"MySQL questions","CategoryDisplayName":"HostingMySQL questions"}],"AssociatedTags":[{"TagId":72,"Tag":" cpanel"},{"TagId":18756,"Tag":" MySQL"},{"TagId":19613,"Tag":" "},{"TagId":19615,"Tag":" database"},{"TagId":66837,"Tag":"db"},{"TagId":66838,"Tag":" sql"},{"TagId":66839,"Tag":" table"},{"TagId":66840,"Tag":" section"},{"TagId":66841,"Tag":" query"}],"RelatedArticles":[],"AssociatedMedias":[],"PreferredCategoryId":0,"RootParentCategoryName":null,"RootParentCategoryId":0},"status":200,"statusText":"OK"},"/api/v1/ncpl/simplekb/getcategorybycategoryid:\"{\\\"categoryId\\\":2180}\"":{"body":{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryDto","ParentCategoryId":12,"Parent_Category_Name":"Hosting","FriendlyId":null,"ApprovedYN":true,"TreatAsTopicYN":false,"CreatedDateTime":"3/10/2013 7:43:55 AM","CurrentCategoryPaths":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryPathDto","Level":1,"CategoryId":12,"CategoryName":"Hosting"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryPathDto","Level":2,"CategoryId":2180,"CategoryName":"MySQL questions"}],"RelatedCategories":[],"AssociatedArticles":[{"ArticleId":621,"Title":"SQL","ArticleName":"SQL","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"12/24/2020"},{"ArticleId":9363,"Title":"How to create and maintain MySQL Databases in cPanel","ArticleName":"How to create and maintain MySQL Databases in cPanel","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"12/28/2020"},{"ArticleId":9540,"Title":"How to manage databases with phpMyAdmin","ArticleName":"How to manage databases with phpMyAdmin","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"01/31/2020"},{"ArticleId":9791,"Title":"How to optimize website database","ArticleName":"How to optimize website database","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"11/13/2016"},{"ArticleId":9143,"Title":"How to import and export a database via phpMyAdmin ('Access denied create database db_name' error)","ArticleName":"How to import and export a database via phpMyAdmin ('Access denied create database db_name' error)","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"01/31/2020"},{"ArticleId":9184,"Title":"How to import and export a database via SSH","ArticleName":"How to import and export a database via SSH","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"12/05/2019"},{"ArticleId":1249,"Title":"How to remotely connect to a MySQL database located on our shared server","ArticleName":"How to remotely connect to a MySQL database located on our shared server","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"01/13/2021"},{"ArticleId":9973,"Title":"How to Duplicate a Database using phpMyAdmin","ArticleName":"How to Duplicate a Database using phpMyAdmin","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"12/28/2020"},{"ArticleId":9945,"Title":"How to empty a MySQL database","ArticleName":"How to empty a MySQL database","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"12/28/2020"},{"ArticleId":1269,"Title":"How to grant remote access to a single MySQL database","ArticleName":"How to grant remote access to a single MySQL database","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"11/12/2016"},{"ArticleId":9715,"Title":"How to connect to a database using Sequel Pro","ArticleName":"How to connect to a database using Sequel Pro","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"04/13/2018"},{"ArticleId":9329,"Title":"How to connect to database using NaviCat MySQL client","ArticleName":"How to connect to database using NaviCat MySQL client","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"10/22/2018"},{"ArticleId":9330,"Title":"How to connect to a database using the Workbench MySQL client","ArticleName":"How to connect to a database using the Workbench MySQL client","LiveDateTime":"2/2/1754 12:00:00 AM","NewTillDate":null,"FeaturedTillDate":null,"ModifiedDateTime":"01/09/2020"}],"AssociatedTags":[],"CategoryId":2180,"CategoryName":"MySQL questions"},"status":200,"statusText":"OK"},"/api/v1/ncpl/simplekb/getcategories:\"{\\\"parentCategoryId\\\":0,\\\"getTree\\\":true}\"":{"body":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2216,"CategoryName":"Spam Protection"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2217,"CategoryName":"Renewal"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2218,"CategoryName":"cPanel SSL Plugin"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2219,"CategoryName":"PHP Configuration"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2221,"CategoryName":"Multi-Domain SSL Certificates"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2222,"CategoryName":"Cancellation"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2223,"CategoryName":"Browser errors"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2224,"CategoryName":"Site Seal, Logo"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2225,"CategoryName":"SEO"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2226,"CategoryName":"Email Migration"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2211,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2227,"CategoryName":"SSL Resellers"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":true,"Description":"","ImageUrl":"/assets/img/pictograms/150/cloud-red.png","ShortDesc":"","CategoryId":2228,"CategoryName":"Apps","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2244,"CategoryName":"VPN"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2246,"CategoryName":"How to set up VPN?"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2248,"CategoryName":"Router VPN setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2249,"CategoryName":"Windows built-in VPN setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2251,"CategoryName":"Supersonic CDN"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":177,"CategoryName":"G Suite (Google Apps)"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2211,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2229,"CategoryName":"Hosting Resellers"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2232,"CategoryName":"DNSSEC"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2234,"CategoryName":"G Suite (Google Apps)"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2237,"CategoryName":"Host records setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2238,"CategoryName":"SSL installation errors"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/easywp-red.png","ShortDesc":"","CategoryId":2239,"CategoryName":"EasyWP","SubCategories":[]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2244,"CategoryName":"VPN"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2246,"CategoryName":"How to set up VPN?"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2248,"CategoryName":"Router VPN setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2249,"CategoryName":"Windows built-in VPN setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2251,"CategoryName":"Supersonic CDN"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2252,"CategoryName":"InterWorx questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"https://files.namecheap.com/cdn/1055/assets/img/pictograms/150/video-red.png","ShortDesc":"","CategoryId":2253,"CategoryName":"How-To Videos","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2254,"CategoryName":"Domains How-To"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2255,"CategoryName":"Hosting How-To"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2257,"CategoryName":"Sales & Payments How-To"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2258,"CategoryName":"cPanel Email How-To"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2262,"CategoryName":"EasyWP How-To"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2254,"CategoryName":"Domains How-To"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2255,"CategoryName":"Hosting How-To"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2257,"CategoryName":"Sales & Payments How-To"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2258,"CategoryName":"cPanel Email How-To"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2260,"CategoryName":"Private Email Contacts and Calendars Setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2253,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2262,"CategoryName":"EasyWP How-To"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":27,"CategoryName":"Getting Started"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/support-red.png","ShortDesc":"","CategoryId":5,"CategoryName":"General & Support","SubCategories":[]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":7,"CategoryName":"Billing FAQ"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2209,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":8,"CategoryName":"Transfer Information"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":22,"CategoryName":"Hosting Information"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":38,"CategoryName":"SSL General"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":9,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":45,"CategoryName":"Account Security"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":46,"CategoryName":"Domain Management"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2211,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":63,"CategoryName":"Namecheap API"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2228,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":177,"CategoryName":"G Suite (Google Apps)"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2179,"CategoryName":"Private Email: General Information"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2211,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2196,"CategoryName":"WHMCS module for SSL"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/savings-red.png","ShortDesc":"","CategoryId":2200,"CategoryName":"Checkout & Billing","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":7,"CategoryName":"Billing FAQ"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2201,"CategoryName":"Domains Billing"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":21,"CategoryName":"Hosting Billing"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":71,"CategoryName":"SSL Certificates Billing"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2177,"CategoryName":"Private Email"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2201,"CategoryName":"Domains Billing"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":67,"CategoryName":"Activation"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2209,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":83,"CategoryName":"Transfer to Namecheap"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":9,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":43,"CategoryName":"Profile Management"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":10,"CategoryName":"DNS Questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":29,"CategoryName":"cPanel questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2215,"CategoryName":"Private Email: Mailbox Management"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2214,"CategoryName":"Email Forwarding"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":21,"CategoryName":"Hosting Billing"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":11,"CategoryName":"Dynamic DNS"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":9,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":44,"CategoryName":"Account Access"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2209,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":84,"CategoryName":"Transfer to another provider"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":68,"CategoryName":"Validation"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2182,"CategoryName":"cPanel: Software Management"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2187,"CategoryName":"cPanel: WordPress"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2209,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":219,"CategoryName":"Canceled Transfers"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":71,"CategoryName":"SSL Certificates Billing"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2176,"CategoryName":"Private Email: DNS Settings"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":69,"CategoryName":"Installation"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/reseller-red.png","ShortDesc":"","CategoryId":34,"CategoryName":"Domains","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2232,"CategoryName":"DNSSEC"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2234,"CategoryName":"G Suite (Google Apps)"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2237,"CategoryName":"Host records setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":46,"CategoryName":"Domain Management"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":10,"CategoryName":"DNS Questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":11,"CategoryName":"Dynamic DNS"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":35,"CategoryName":"Registrations"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2207,"CategoryName":"Renewal questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":36,"CategoryName":"Domains with extended attributes"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":51,"CategoryName":"FreeDNS"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":15,"CategoryName":"Marketplace"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2208,"CategoryName":"3rd Party Services Setup"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":35,"CategoryName":"Registrations"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":70,"CategoryName":"Reissuance"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/protection-red.png","ShortDesc":"","CategoryId":37,"CategoryName":"WhoisGuard","SubCategories":[]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2200,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2177,"CategoryName":"Private Email"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2178,"CategoryName":"Private Email: Webmail Features"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2207,"CategoryName":"Renewal questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2210,"CategoryName":"cPanel Add-ons"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2175,"CategoryName":"Private Email: Client Setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/status-red.png","ShortDesc":"","CategoryId":2209,"CategoryName":"Domain Transfers","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2209,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":8,"CategoryName":"Transfer Information"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2209,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":83,"CategoryName":"Transfer to Namecheap"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2209,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":84,"CategoryName":"Transfer to another provider"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2209,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":219,"CategoryName":"Canceled Transfers"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":48,"CategoryName":"VPS"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":36,"CategoryName":"Domains with extended attributes"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":true,"Description":"","ImageUrl":"/assets/img/pictograms/150/server-red.png","ShortDesc":"","CategoryId":12,"CategoryName":"Hosting","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2219,"CategoryName":"PHP Configuration"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2225,"CategoryName":"SEO"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2252,"CategoryName":"InterWorx questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":27,"CategoryName":"Getting Started"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":22,"CategoryName":"Hosting Information"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":29,"CategoryName":"cPanel questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2182,"CategoryName":"cPanel: Software Management"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2187,"CategoryName":"cPanel: WordPress"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2210,"CategoryName":"cPanel Add-ons"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":48,"CategoryName":"VPS"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2188,"CategoryName":"Dedicated Server"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":30,"CategoryName":"WHM questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":32,"CategoryName":"DNS settings"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":103,"CategoryName":"LVE (CloudLinux)"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":89,"CategoryName":"SSH Access"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":205,"CategoryName":"FTP questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2180,"CategoryName":"MySQL questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2199,"CategoryName":"Hosting Migration"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2194,"CategoryName":"Tips & Tricks"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":239,"CategoryName":"WHMCS"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":33,"CategoryName":"SSL Installation"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2171,"CategoryName":"Private Email: Active Sync (Exchange) Setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2188,"CategoryName":"Dedicated Server"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":30,"CategoryName":"WHM questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":31,"CategoryName":"cPanel Email FAQs"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":51,"CategoryName":"FreeDNS"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/email-red.png","ShortDesc":"","CategoryId":93,"CategoryName":"Email service","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2216,"CategoryName":"Spam Protection"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2226,"CategoryName":"Email Migration"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2260,"CategoryName":"Private Email Contacts and Calendars Setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2179,"CategoryName":"Private Email: General Information"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2215,"CategoryName":"Private Email: Mailbox Management"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2214,"CategoryName":"Email Forwarding"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2176,"CategoryName":"Private Email: DNS Settings"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2178,"CategoryName":"Private Email: Webmail Features"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2175,"CategoryName":"Private Email: Client Setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2171,"CategoryName":"Private Email: Active Sync (Exchange) Setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":31,"CategoryName":"cPanel Email FAQs"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2186,"CategoryName":"cPanel Email: Client Setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2204,"CategoryName":"Private Email: Video Overview"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":32,"CategoryName":"DNS settings"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":15,"CategoryName":"Marketplace"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2186,"CategoryName":"cPanel Email: Client Setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":34,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2208,"CategoryName":"3rd Party Services Setup"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":93,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2204,"CategoryName":"Private Email: Video Overview"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/security-red.png","ShortDesc":"","CategoryId":14,"CategoryName":"SSL Certificates","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2217,"CategoryName":"Renewal"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2218,"CategoryName":"cPanel SSL Plugin"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2221,"CategoryName":"Multi-Domain SSL Certificates"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2222,"CategoryName":"Cancellation"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2223,"CategoryName":"Browser errors"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2224,"CategoryName":"Site Seal, Logo"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2238,"CategoryName":"SSL installation errors"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":38,"CategoryName":"SSL General"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":67,"CategoryName":"Activation"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":68,"CategoryName":"Validation"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":69,"CategoryName":"Installation"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":14,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":70,"CategoryName":"Reissuance"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":true,"Description":"","ImageUrl":"/assets/img/pictograms/150/performance-red.png","ShortDesc":"","CategoryId":9,"CategoryName":"My Account","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":9,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":45,"CategoryName":"Account Security"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":9,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":43,"CategoryName":"Profile Management"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":9,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":44,"CategoryName":"Account Access"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":103,"CategoryName":"LVE (CloudLinux)"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/affiliates-red.png","ShortDesc":"","CategoryId":55,"CategoryName":"Affiliates","SubCategories":[]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":89,"CategoryName":"SSH Access"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/tools-red.png","ShortDesc":"","CategoryId":2211,"CategoryName":"API & Resellers","SubCategories":[{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2211,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2227,"CategoryName":"SSL Resellers"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2211,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2229,"CategoryName":"Hosting Resellers"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2211,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":63,"CategoryName":"Namecheap API"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":2211,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2196,"CategoryName":"WHMCS module for SSL"}]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/timer-red.png","ShortDesc":"","CategoryId":2212,"CategoryName":"Legacy Products","SubCategories":[]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":205,"CategoryName":"FTP questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2180,"CategoryName":"MySQL questions"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2199,"CategoryName":"Hosting Migration"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":0,"TreatAsTopicYN":false,"Description":"","ImageUrl":"/assets/img/pictograms/150/premiumdns-red.png","ShortDesc":"","CategoryId":2231,"CategoryName":"PremiumDNS","SubCategories":[]},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":2194,"CategoryName":"Tips & Tricks"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":239,"CategoryName":"WHMCS"},{"__type":"Nc:SimpleKB:Abstractions:Dtos:CategoryItemDto","ParentCategoryId":12,"TreatAsTopicYN":false,"Description":"","ImageUrl":"","ShortDesc":"","CategoryId":33,"CategoryName":"SSL Installation"}],"status":200,"statusText":"OK"}}

phpMyAdmin is an application for MySQL databases management. With it you can create, alter, drop, delete, import and export MySQL database tables. You can also run MySQL queries, optimize, repair and check tables, change collation.

NOTE: Make sure the database you would like to manage is already created in the MySQL Databases menu.

The phpMyAdmin menu in located in cPanel >> Databases section.

for cPanel paper_lantern theme:

for cPanel x3 theme:

For quick access to the phpMyAdmin, you can use our cPanel Shortcuts in the Namecheap account.

Let’s take a look at the most widely used tabs.

Databases

The Databases tab lists all the databases which can be managed through the cPanel user.
If you enable the statistics for the databases, you will see a table with the used collations, the number of the tables and rows, the size of the data and indexes, the total size and the overhead.

SQL

In this tab you can run SQL queries either by entering the entire SQL query code or manually defining the parameters of the query.
Keep in mind that this tab is context-sensitive, which means that depending on what you're looking at, the target of your SQL queries might be different, e.g., if you are on the home page of phpMyAdmin and do not have any databases selected, if you click on the SQL tab, any queries you run will apply to the overall server (or hosting account if on shared hosting).

Export

The Export tab allows you to export the database tables content in different formats – CSV, SQL, PDF, Microsoft Excel, Microsoft Word, XML, etc. You can select either all the database tables or choose specific ones.
This tab is also context-sensitive - you can either export all databases or a single database/table.

Import

The Import tab allows you to import your database tables from a file saved on your local computer.

NOTE: You can only import the databases that are under 1 GB. If you database backup is bigger than this, you will need need to import it via SSH.

Database Management

Go to the Databases tab and click on the database you would like to manage:

Then create a table:

1. Enter the name of your table in the field Name
2. Enter the number of columns in the field Number of Columns
3. Click on Go to proceed to the next screen
4. Define the column(s) by providing the following information:
4.1. Name
4.2. Select the Type of data for the column. Some common types include:

INT = Integer (a number without a decimal point)
CHAR = Characters (text up to a specific length)
VARCHAR = Variable Length Characters (does not have a fixed width)
TEXT = for holding large amounts of text
DATE = only for dates
DATETIME = only for a date and time format.

4.3. Define the Length/Values if required. For example, for the CHAR type you will need to specify the maximum number of characters allowed.
4.4. The other fields are optional.

5. Click on Save once you are finished.

The possible actions you can perform to a chosen table are: Browse, Structure, Search, Insert, Empty and Drop:

Browse

Only the tables with existing records can be browsed. Once you click on the Browse icon, a new window with the records list will be opened. You can edit the chosen record by clicking on the Pen icon. You will see then the record structure and will be able to modify the values of the records.

Structure

The Structure screen shows you the database's table structure. It shows you the fields' names, their types, collations, attributes, additional information, the default values and whether the fields' values can be NULL.

Search

Through the Search action you can generate a search query for the chosen table. You can either write the WHERE clause, or you can use the "query by example" functionality. You should click on the Go button to execute the query.

Insert

Using the Insert action you can insert records in your database table. Once you fill in the corresponding values, click on the Go button and the new record will be inserted.

Empty

The Empty action allows you to empty your database table, removing the data and keeping the empty table.

Drop

Through the Drop action you can delete the whole table and all the records stored in it.

That's it!

Need any help? Contact our HelpDesk

Updated

1/31/2020

Viewed

30403 times