{"id":1370,"date":"2020-12-12T23:50:20","date_gmt":"2020-12-13T04:50:20","guid":{"rendered":"https:\/\/truxgoservers.com\/blog\/?p=1370"},"modified":"2020-12-12T23:50:21","modified_gmt":"2020-12-13T04:50:21","slug":"mysql-database-administration","status":"publish","type":"post","link":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/","title":{"rendered":"MySQL &#8211; Database administration"},"content":{"rendered":"\n<p>MySQL is a Database Management System (DBMS) for relational databases. Thus, this is nothing more than an application that allows you to manage files called databases. There are many types of databases, from a simple file to object-oriented relational systems. As a relational database, uses multiple tables to store and organize information. MySQL was written in C and C ++ and stands out for its great adaptation to different development environments, allowing its interaction with the most used programming languages \u200b\u200bsuch as PHP, Perl and Java and its integration in different operating systems.<\/p>\n\n\n\n<p>A database is simply a collection of structured data. The database is a place where data is stored and organized. The word &#8220;relational&#8221; means that the data stored in the data set is organized in the form of tables. Each table is related in some way.<\/p>\n\n\n\n<p>This originally was developed in 1994. US technology company Sun Microsystems then took full control when it bought in 2008. US tech giant Oracle acquired Sun Microsystems in 2010, and MySQL has been owned by Oracle since then.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Features<\/h2>\n\n\n\n<p>It was originally developed in 1994. US technology company Sun Microsystems then took full control when it bought MySQL in 2008. US tech giant Oracle acquired Sun Microsystems in 2010, and MySQL has been owned by Oracle since then.<\/p>\n\n\n\n<p><strong><em>Without getting too deep into technical issues, the main processes that take place in a MySQL environment are the same, and they are:<\/em><\/strong><\/p>\n\n\n\n<p><strong><em>\u25b8<\/em><\/strong><em>This was create as a database to store and manipulate data, defining the relationship of each table.<\/em><\/p>\n\n\n\n<p><strong><em>\u25b8<\/em><\/strong><em>Clients can make requests by writing specific SQL statements in MySQL.<\/em><\/p>\n\n\n\n<p><strong><em>\u25b8<\/em><\/strong><em>The server application will respond with the requested information and this will appear in front of the clients.<\/em><\/p>\n\n\n\n<p>See also:<br><a href=\"https:\/\/truxgoservers.com\/blog\/php-general-purpose-programming-language\/\">PHP \u2013 general purpose programming language<\/a><br><a href=\"https:\/\/truxgoservers.com\/blog\/what-should-we-know-about-security-with-javascript\/\">What should we know about security with JavaScript<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is a Database Management System (DBMS) for relational databases. Thus, this is nothing more than an application that allows you to manage files called databases. There are many types of databases, from a simple file to object-oriented relational systems. As a relational database, uses multiple tables to store and organize information. MySQL was written [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1371,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,1],"tags":[221,220,33],"class_list":["post-1370","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-tutorial","tag-database","tag-mysql","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL - Database administration - Truxgo Server Blog<\/title>\n<meta name=\"description\" content=\"MySQL a database management system that is useful for many things and we see what functions this management system fulfills....\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL - Database administration - Truxgo Server Blog\" \/>\n<meta property=\"og:description\" content=\"MySQL a database management system that is useful for many things and we see what functions this management system fulfills....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/\" \/>\n<meta property=\"og:site_name\" content=\"Truxgo Server Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-13T04:50:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-13T04:50:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/truxgoservers.com\/blog\/wp-content\/uploads\/2020\/12\/DataBase.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1792\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Truxgo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Truxgo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/\"},\"author\":{\"name\":\"Truxgo\",\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/#\\\/schema\\\/person\\\/8b409c26449db6aa09724b45331e333e\"},\"headline\":\"MySQL &#8211; Database administration\",\"datePublished\":\"2020-12-13T04:50:20+00:00\",\"dateModified\":\"2020-12-13T04:50:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/\"},\"wordCount\":299,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/DataBase.jpg\",\"keywords\":[\"Database\",\"MySQL\",\"Tutorial\"],\"articleSection\":[\"PHP\",\"Tutorial\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/\",\"url\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/\",\"name\":\"MySQL - Database administration - Truxgo Server Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/DataBase.jpg\",\"datePublished\":\"2020-12-13T04:50:20+00:00\",\"dateModified\":\"2020-12-13T04:50:21+00:00\",\"description\":\"MySQL a database management system that is useful for many things and we see what functions this management system fulfills....\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/#primaryimage\",\"url\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/DataBase.jpg\",\"contentUrl\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/DataBase.jpg\",\"width\":2560,\"height\":1792},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/mysql-database-administration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL &#8211; Database administration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/\",\"name\":\"Truxgo Server Blog\",\"description\":\"Cloud Server and Hosting Tutorials.\",\"publisher\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/#organization\",\"name\":\"Truxgo Server Blog\",\"url\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/cropped-truxgo-logo-blanco.png\",\"contentUrl\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/cropped-truxgo-logo-blanco.png\",\"width\":1250,\"height\":278,\"caption\":\"Truxgo Server Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/#\\\/schema\\\/person\\\/8b409c26449db6aa09724b45331e333e\",\"name\":\"Truxgo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/52691a61c58e68677ed4860007c1bb03b14eabe7350747ab3fad3e17825b4b96?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/52691a61c58e68677ed4860007c1bb03b14eabe7350747ab3fad3e17825b4b96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/52691a61c58e68677ed4860007c1bb03b14eabe7350747ab3fad3e17825b4b96?s=96&d=mm&r=g\",\"caption\":\"Truxgo\"},\"sameAs\":[\"https:\\\/\\\/truxgoservers.com\\\/blog\"],\"url\":\"https:\\\/\\\/truxgoservers.com\\\/blog\\\/author\\\/truxgo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL - Database administration - Truxgo Server Blog","description":"MySQL a database management system that is useful for many things and we see what functions this management system fulfills....","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":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/","og_locale":"es_MX","og_type":"article","og_title":"MySQL - Database administration - Truxgo Server Blog","og_description":"MySQL a database management system that is useful for many things and we see what functions this management system fulfills....","og_url":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/","og_site_name":"Truxgo Server Blog","article_published_time":"2020-12-13T04:50:20+00:00","article_modified_time":"2020-12-13T04:50:21+00:00","og_image":[{"width":2560,"height":1792,"url":"https:\/\/truxgoservers.com\/blog\/wp-content\/uploads\/2020\/12\/DataBase.jpg","type":"image\/jpeg"}],"author":"Truxgo","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Truxgo","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/#article","isPartOf":{"@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/"},"author":{"name":"Truxgo","@id":"https:\/\/truxgoservers.com\/blog\/#\/schema\/person\/8b409c26449db6aa09724b45331e333e"},"headline":"MySQL &#8211; Database administration","datePublished":"2020-12-13T04:50:20+00:00","dateModified":"2020-12-13T04:50:21+00:00","mainEntityOfPage":{"@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/"},"wordCount":299,"commentCount":1,"publisher":{"@id":"https:\/\/truxgoservers.com\/blog\/#organization"},"image":{"@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/#primaryimage"},"thumbnailUrl":"https:\/\/truxgoservers.com\/blog\/wp-content\/uploads\/2020\/12\/DataBase.jpg","keywords":["Database","MySQL","Tutorial"],"articleSection":["PHP","Tutorial"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/","url":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/","name":"MySQL - Database administration - Truxgo Server Blog","isPartOf":{"@id":"https:\/\/truxgoservers.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/#primaryimage"},"image":{"@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/#primaryimage"},"thumbnailUrl":"https:\/\/truxgoservers.com\/blog\/wp-content\/uploads\/2020\/12\/DataBase.jpg","datePublished":"2020-12-13T04:50:20+00:00","dateModified":"2020-12-13T04:50:21+00:00","description":"MySQL a database management system that is useful for many things and we see what functions this management system fulfills....","breadcrumb":{"@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/#primaryimage","url":"https:\/\/truxgoservers.com\/blog\/wp-content\/uploads\/2020\/12\/DataBase.jpg","contentUrl":"https:\/\/truxgoservers.com\/blog\/wp-content\/uploads\/2020\/12\/DataBase.jpg","width":2560,"height":1792},{"@type":"BreadcrumbList","@id":"https:\/\/truxgoservers.com\/blog\/mysql-database-administration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/truxgoservers.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL &#8211; Database administration"}]},{"@type":"WebSite","@id":"https:\/\/truxgoservers.com\/blog\/#website","url":"https:\/\/truxgoservers.com\/blog\/","name":"Truxgo Server Blog","description":"Cloud Server and Hosting Tutorials.","publisher":{"@id":"https:\/\/truxgoservers.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/truxgoservers.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/truxgoservers.com\/blog\/#organization","name":"Truxgo Server Blog","url":"https:\/\/truxgoservers.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/truxgoservers.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/truxgoservers.com\/blog\/wp-content\/uploads\/2020\/08\/cropped-truxgo-logo-blanco.png","contentUrl":"https:\/\/truxgoservers.com\/blog\/wp-content\/uploads\/2020\/08\/cropped-truxgo-logo-blanco.png","width":1250,"height":278,"caption":"Truxgo Server Blog"},"image":{"@id":"https:\/\/truxgoservers.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/truxgoservers.com\/blog\/#\/schema\/person\/8b409c26449db6aa09724b45331e333e","name":"Truxgo","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/52691a61c58e68677ed4860007c1bb03b14eabe7350747ab3fad3e17825b4b96?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/52691a61c58e68677ed4860007c1bb03b14eabe7350747ab3fad3e17825b4b96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/52691a61c58e68677ed4860007c1bb03b14eabe7350747ab3fad3e17825b4b96?s=96&d=mm&r=g","caption":"Truxgo"},"sameAs":["https:\/\/truxgoservers.com\/blog"],"url":"https:\/\/truxgoservers.com\/blog\/author\/truxgo\/"}]}},"_links":{"self":[{"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/posts\/1370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/comments?post=1370"}],"version-history":[{"count":4,"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/posts\/1370\/revisions"}],"predecessor-version":[{"id":1380,"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/posts\/1370\/revisions\/1380"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/media\/1371"}],"wp:attachment":[{"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/media?parent=1370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/categories?post=1370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/truxgoservers.com\/blog\/wp-json\/wp\/v2\/tags?post=1370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}