{"id":2941,"date":"2021-10-12T10:21:32","date_gmt":"2021-10-12T10:21:32","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=2941"},"modified":"2021-10-12T10:21:32","modified_gmt":"2021-10-12T10:21:32","slug":"learning-about-information_schema-database","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/","title":{"rendered":"Learning About information_schema Database"},"content":{"rendered":"<p>There is an extra database named as information_schema within the MySQL version 5.02. You&#8217;ll be able to notice this database in <strong>cPanel<\/strong> &gt;&gt; <strong>Databases<\/strong> &gt;&gt; <strong>phpMyAdmin<\/strong>. It permits you to access the database information for corresponding user.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2942 aligncenter\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/mysql-db-100x300.png\" alt=\"mysql-db\" width=\"219\" height=\"659\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/mysql-db-100x300.png 100w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/mysql-db.png 219w\" sizes=\"auto, (max-width: 219px) 100vw, 219px\" \/><\/p>\n<p>information_schema database stores the information concerning all alternative databases. For instance, data type of columns, a database or a table name, access privileges, etc. it&#8217;s a virtual database that&#8217;s in-built with associate aim to deliver information concerning the database system itself. The tables inside this database are automatically populated by the MySQL server.<\/p>\n<p>You should keep in mind one major factor about the information_schema database and it&#8217;s possible to query it, however its structure can\u2019t be modified and data can\u2019t be changed.<\/p>\n<p>When you query the information_schema database, you get lots of options on dominant the changes within the structure of your database and additionally, provide some level of automation on the database layer. For obtaining these 2, it&#8217;s necessary to follow some rules, like internal data modeling rules, naming convention, etc. you&#8217;ll be able to additionally exploit it to document your database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There is an extra database named as information_schema within the MySQL version 5.02. You&#8217;ll be able to notice this database in cPanel &gt;&gt; Databases &gt;&gt; phpMyAdmin. It permits you to access the database information for corresponding user. information_schema database stores the information concerning all alternative databases. For instance, data type of columns, a database or [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-2941","post","type-post","status-publish","format-standard","hentry","category-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Learning About information_schema Database - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learning About information_schema Database - OWS KB\" \/>\n<meta property=\"og:description\" content=\"There is an extra database named as information_schema within the MySQL version 5.02. You&#8217;ll be able to notice this database in cPanel &gt;&gt; Databases &gt;&gt; phpMyAdmin. It permits you to access the database information for corresponding user. information_schema database stores the information concerning all alternative databases. For instance, data type of columns, a database or [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-12T10:21:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/mysql-db-100x300.png\" \/>\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=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/mysql-db.png\",\"width\":219,\"height\":659,\"caption\":\"mysql-db\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/\",\"name\":\"Learning About information_schema Database - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/#primaryimage\"},\"datePublished\":\"2021-10-12T10:21:32+00:00\",\"dateModified\":\"2021-10-12T10:21:32+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/learning-about-information_schema-database\/\",\"name\":\"Learning About information_schema Database\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=2941"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2941\/revisions"}],"predecessor-version":[{"id":2943,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2941\/revisions\/2943"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=2941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=2941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=2941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}