{"id":3955,"date":"2017-01-23T05:26:49","date_gmt":"2017-01-23T10:26:49","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=3955"},"modified":"2017-01-23T05:26:49","modified_gmt":"2017-01-23T10:26:49","slug":"running-secure-database-system","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/running-secure-database-system\/","title":{"rendered":"Great Tips to Running a Secure Database System"},"content":{"rendered":"<p>Having a secure database today is ever more important with all the news every other week that either a corporate or government entity has been hacked into or researchers have found vulnerabilities in popular web applications and systems.<!--more--><\/p>\n<p>Databases are extremely important today as they are the in the core of everything tech related. You will find them storing data and information in <a href=\"\/\/local.brightwhiz\/tag\/web\/\">web<\/a> applications, software systems, <a href=\"\/\/local.brightwhiz\/tag\/mobile\/\">mobile <\/a>apps, <a href=\"\/\/local.brightwhiz\/tag\/embedded\/\">embedded <\/a>devices and all.<\/p>\n<p>You may not be able to stand against an army of attackers as there are various factors that come into play in the type of attack on can suffer on their database systems. Some may be out of your hands as in the case where there is a vulnerability in the application itself.<\/p>\n<p>Until a patch is released you may be a sitting duck but that notwithstanding there is a whole array of things you can do to harden the security and keep your data much safer on a day-to-day basis.<\/p>\n<h2>Here&#8217;s What to do to Have a Secure Database<\/h2>\n<ul>\n<li><strong>Keep Your Database Applications Up-to-date:<\/strong> Make sure you keep yourself abreast with all the latest updates and patches that are released for your database system. This will be reduce or get rid of the known vulnerabilities you have to deal with and keep you safe from some of the the holes attackers can use that are not in your control.<\/li>\n<li><strong>Enable Access Control and Require Authentication:<\/strong> If you use a database management system such as <a href=\"\/\/local.brightwhiz\/tag\/mongodb\/\">MongoDB<\/a> which allows open access control then make sure you enable it. You must always configure access control using authentication with a strong password as the bare minimum.\n<p>A strong password should contain a mix of uppercase, lowercase, numeric characters and symbols and should be of significant length.With databases like <a href=\"\/\/local.brightwhiz\/tag\/mysql\/\">MySQL<\/a> you would want to restrict access to the database root user preferably granting access from the localhost or specific IP addresses rather than from just anywhere. The same goes for other database users.<\/p>\n<p>Also you want to set up exclusive users for the database that are separate from the operating system users or it should be a dedicated operating system user. The other thing you need to do with these users is to set up user roles with the least privilege as possible. Users should be granted permissions that allow them to function as required and no more.<\/li>\n<li><strong>Use Encryption Within and Without the Database:<\/strong> incoming and outgoing connections between the database and various clients and applications should be encrypted with TLS\/SSL. In addition to that, the data stored should also be <a href=\"\/\/local.brightwhiz\/tag\/encryption\/\">encrypted <\/a>using either device, in-built engines, file system or physical encryption. In the very least sensitive information such as passwords, financial and medical information should be encrypted.\n<p>The storage folders of this data should also be protected under least privilege on the operating system&#8217;s file system permission controls.<\/li>\n<li><strong>Log and Audit all Database Activity:<\/strong> Access to the database, user operations, errors and other events should be logged and records kept to allow for forensic audits, for performance tuning and to allow for proper controls.<\/li>\n<li><strong>Limit Exposure on Public Networks:<\/strong> Restrictions should be placed on the interfaces where the databases listen on especially when they are public facing interfaces. Where possible as much as possible restrict access to certain applications IP addresses and ports.<\/li>\n<\/ul>\n<p>With these few pointers you are well on your way to having a more secure <a href=\"\/\/local.brightwhiz\/tag\/database\/\">database<\/a> that will give you peace of mind. There are obviously other factors that can break this <a href=\"\/\/local.brightwhiz\/tag\/security\/\">security<\/a> and therefore educating users on corporate networks on best practice should be encouraged as this can help prevent social engineering hacks or malware accessing internal networks from untrusted sources within the network.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Having a secure database today is ever more important with all the news every other week that either a corporate or government entity has been hacked into or researchers have&#8230;<\/p>\n","protected":false},"author":1,"featured_media":3956,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,23,17,20],"tags":[180,223,433,526,542,543,564,591],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Properly Manage a Secure Database System Online<\/title>\n<meta name=\"description\" content=\"Here&#039;s a quick security checklist to help you on your way to managing a more secure database online to keep your data safe from hackers\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/local.brightwhiz\/running-secure-database-system\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Properly Manage a Secure Database System Online\" \/>\n<meta property=\"og:description\" content=\"Here&#039;s a quick security checklist to help you on your way to managing a more secure database online to keep your data safe from hackers\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.brightwhiz\/running-secure-database-system\/\" \/>\n<meta property=\"og:site_name\" content=\"Brightwhiz.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/brightwhiz\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-23T10:26:49+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michael Bright\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:site\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Bright\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/\"},\"author\":{\"name\":\"Michael Bright\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\"},\"headline\":\"Great Tips to Running a Secure Database System\",\"datePublished\":\"2017-01-23T10:26:49+00:00\",\"dateModified\":\"2017-01-23T10:26:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/\"},\"wordCount\":631,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg\",\"keywords\":[\"Database\",\"Encryption\",\"Optimization\",\"Security\",\"Software\",\"Software Design\",\"Storage\",\"Tools\"],\"articleSection\":[\"Articles\",\"Guides\",\"Tips\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/local.brightwhiz\/running-secure-database-system\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/\",\"url\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/\",\"name\":\"How to Properly Manage a Secure Database System Online\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg\",\"datePublished\":\"2017-01-23T10:26:49+00:00\",\"dateModified\":\"2017-01-23T10:26:49+00:00\",\"description\":\"Here's a quick security checklist to help you on your way to managing a more secure database online to keep your data safe from hackers\",\"breadcrumb\":{\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.brightwhiz\/running-secure-database-system\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/#primaryimage\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg\",\"width\":1200,\"height\":630,\"caption\":\"Secure Database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.brightwhiz\/running-secure-database-system\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.brightwhiz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Great Tips to Running a Secure Database System\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/local.brightwhiz\/#website\",\"url\":\"http:\/\/local.brightwhiz\/\",\"name\":\"Brightwhiz.com\",\"description\":\"Best Tech guides, Tutorials, and News\",\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/local.brightwhiz\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/local.brightwhiz\/#organization\",\"name\":\"Brightwhiz\",\"url\":\"http:\/\/local.brightwhiz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"width\":706,\"height\":135,\"caption\":\"Brightwhiz\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/brightwhiz\/\",\"https:\/\/twitter.com\/brightwhizmag\",\"https:\/\/instagram.com\/bright_whiz\/\",\"https:\/\/www.pinterest.com\/sobbayi\/\",\"https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\",\"name\":\"Michael Bright\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"caption\":\"Michael Bright\"},\"sameAs\":[\"https:\/\/sobbayi.com\"],\"url\":\"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Properly Manage a Secure Database System Online","description":"Here's a quick security checklist to help you on your way to managing a more secure database online to keep your data safe from hackers","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":"http:\/\/local.brightwhiz\/running-secure-database-system\/","og_locale":"en_US","og_type":"article","og_title":"How to Properly Manage a Secure Database System Online","og_description":"Here's a quick security checklist to help you on your way to managing a more secure database online to keep your data safe from hackers","og_url":"http:\/\/local.brightwhiz\/running-secure-database-system\/","og_site_name":"Brightwhiz.com","article_publisher":"https:\/\/www.facebook.com\/brightwhiz\/","article_published_time":"2017-01-23T10:26:49+00:00","og_image":[{"width":1200,"height":630,"url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg","type":"image\/jpeg"}],"author":"Michael Bright","twitter_card":"summary_large_image","twitter_creator":"@brightwhizmag","twitter_site":"@brightwhizmag","twitter_misc":{"Written by":"Michael Bright","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/#article","isPartOf":{"@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/"},"author":{"name":"Michael Bright","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32"},"headline":"Great Tips to Running a Secure Database System","datePublished":"2017-01-23T10:26:49+00:00","dateModified":"2017-01-23T10:26:49+00:00","mainEntityOfPage":{"@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/"},"wordCount":631,"commentCount":0,"publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"image":{"@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg","keywords":["Database","Encryption","Optimization","Security","Software","Software Design","Storage","Tools"],"articleSection":["Articles","Guides","Tips","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/local.brightwhiz\/running-secure-database-system\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/","url":"http:\/\/local.brightwhiz\/running-secure-database-system\/","name":"How to Properly Manage a Secure Database System Online","isPartOf":{"@id":"http:\/\/local.brightwhiz\/#website"},"primaryImageOfPage":{"@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/#primaryimage"},"image":{"@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg","datePublished":"2017-01-23T10:26:49+00:00","dateModified":"2017-01-23T10:26:49+00:00","description":"Here's a quick security checklist to help you on your way to managing a more secure database online to keep your data safe from hackers","breadcrumb":{"@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.brightwhiz\/running-secure-database-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/#primaryimage","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2017\/01\/Secure-Database.jpg","width":1200,"height":630,"caption":"Secure Database"},{"@type":"BreadcrumbList","@id":"http:\/\/local.brightwhiz\/running-secure-database-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.brightwhiz\/"},{"@type":"ListItem","position":2,"name":"Great Tips to Running a Secure Database System"}]},{"@type":"WebSite","@id":"http:\/\/local.brightwhiz\/#website","url":"http:\/\/local.brightwhiz\/","name":"Brightwhiz.com","description":"Best Tech guides, Tutorials, and News","publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/local.brightwhiz\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/local.brightwhiz\/#organization","name":"Brightwhiz","url":"http:\/\/local.brightwhiz\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","width":706,"height":135,"caption":"Brightwhiz"},"image":{"@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/brightwhiz\/","https:\/\/twitter.com\/brightwhizmag","https:\/\/instagram.com\/bright_whiz\/","https:\/\/www.pinterest.com\/sobbayi\/","https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ"]},{"@type":"Person","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32","name":"Michael Bright","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","caption":"Michael Bright"},"sameAs":["https:\/\/sobbayi.com"],"url":"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/3955"}],"collection":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/comments?post=3955"}],"version-history":[{"count":0,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/3955\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media\/3956"}],"wp:attachment":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media?parent=3955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/categories?post=3955"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/tags?post=3955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}