{"id":6403,"date":"2014-08-04T19:48:47","date_gmt":"2014-08-04T19:48:47","guid":{"rendered":"https:\/\/www.jose-aguilar.com\/blog\/?p=6403"},"modified":"2016-08-04T11:56:39","modified_gmt":"2016-08-04T11:56:39","slug":"adminer","status":"publish","type":"post","link":"https:\/\/www.jose-aguilar.com\/blog\/adminer\/","title":{"rendered":"Adminer"},"content":{"rendered":"<p><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Adminer<\/span> <span class=\"hps\">(antes<\/span> <span class=\"hps\">phpMinAdmin<\/span>) es una <span class=\"hps\">herramienta de gesti\u00f3n de<\/span> <span class=\"hps\">base de datos<\/span> <span class=\"hps\">con todas las funciones<\/span> <span class=\"hps\">escritas en<\/span> <span class=\"hps\">PHP.<\/span> <\/span><\/p>\n<p>Adminer no es un proyecto de muchos archivos. Tan solo tiene un \u00fanico archivo con todas las opciones de phpMyAdmin. La instalaci\u00f3n es muy sencilla, tan solo tienes que descargar el archivo y subirlo al servidor. Una vez subido, acceder a trav\u00e9s del navegador a la ruta.<\/p>\n<p>Esta herramienta puede ser muy \u00fatil cuando necesitamos accedar a una base de datos sin tener url de acceso.<\/p>\n<p><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Adminer<\/span> <span class=\"hps\">est\u00e1 disponible para<\/span> <span class=\"hps\">MySQL<\/span><span>, PostgreSQL<\/span>, SQLite, MS <span class=\"hps\">SQL<\/span>, Oracle, <span class=\"hps\">SimpleDB<\/span>, <span class=\"hps\">Elasticsearch<\/span> <span class=\"hps\">y<\/span> <span class=\"hps\">MongoDB<\/span>.<\/span><\/p>\n<p><strong>Caracter\u00edsticas o posibilidades<\/strong><\/p>\n<ul>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Conectarse a un<\/span> <span class=\"hps\">servidor de<\/span> <span class=\"hps\">base de datos<\/span> <span class=\"hps\">con nombre de usuario<\/span> <span class=\"hps\">y contrase\u00f1a<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Seleccione<\/span> <span class=\"hps\">una base de datos<\/span> <span class=\"hps\">existente o crear<\/span> <span class=\"hps\">uno nuevo<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Lista de<\/span> <span class=\"hps\">campos<\/span>, \u00edndices, <span class=\"hps\">claves externas y<\/span> <span class=\"hps\">factores desencadenantes de<\/span> <span class=\"hps\">la tabla<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Modificar de<\/span> <span class=\"hps\">nombre,<\/span> <span class=\"hps\">el motor<\/span>, el cotejamiento, <span class=\"hps\">AUTO_INCREMENT<\/span> <span class=\"hps\">y<\/span> <span class=\"hps\">comentario<\/span> <span class=\"hps\">de la tabla<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Alterar<\/span> <span class=\"hps\">columnas de las tablas<\/span><\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Agregar y<\/span> <span class=\"hps\">eliminar tablas<\/span> <span class=\"hps\">y columnas<\/span><br \/>\n<\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Crear,<\/span> <span class=\"hps\">modificar<\/span>, <span class=\"hps\">eliminar y<\/span> <span class=\"hps\">buscar por<\/span> <span class=\"hps\">\u00edndices<\/span>, incluyendo <span class=\"hps\">el texto completo<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Crear,<\/span> <span class=\"hps\">modificar, quitar<\/span> <span class=\"hps\">enlaces<\/span> <span class=\"hps\">de<\/span> <span class=\"hps\">claves externas<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Crear,<\/span> <span class=\"hps\">modificar<\/span>, <span class=\"hps\">eliminar y<\/span> <span class=\"hps\">seleccionar <\/span><span class=\"hps\">vistas<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Crear,<\/span> <span class=\"hps\">modificar<\/span>, <span class=\"hps\">eliminar y<\/span> <span class=\"hps\">llamar a procedimientos<\/span> <span class=\"hps\">almacenados y funciones<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Crear,<\/span> <span class=\"hps\">modificar y eliminar<\/span> <span class=\"hps\">los factores desencadenantes<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Datos de la Lista<\/span> <span class=\"hps\">de las tablas<\/span> <span class=\"hps\">con<\/span> <span class=\"hps\">la b\u00fasqueda<\/span>, agregar, <span class=\"hps\">clasificar\u00a0<\/span> <span class=\"hps\">resultados<\/span><\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Insertar<\/span> <span class=\"hps\">nuevos registros,<\/span> <span class=\"hps\">actualizar y<\/span> <span class=\"hps\">eliminar las ya<\/span> <span class=\"hps\">existentes<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Soporta todos los<\/span> <span class=\"hps\">tipos de datos<\/span><\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Ejecutar<\/span> <span class=\"hps\">cualquier comando<\/span> <span class=\"hps\">SQL<\/span> <span class=\"hps\">de un<\/span> <span class=\"hps\">campo de texto o<\/span> <span class=\"hps\">un archivo<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Estructura de la tabla<\/span> <span class=\"hps\">de exportaci\u00f3n<\/span><span>, datos<\/span><span>, opiniones<\/span>, rutinas, <span class=\"hps\">las bases de datos<\/span> <span class=\"hps\">a<\/span> <span class=\"hps\">SQL o<\/span> <span class=\"hps\">CSV<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Esquema de la base<\/span> <span class=\"hps\">de impresi\u00f3n<\/span> <span class=\"hps\">conectadas por<\/span> <span class=\"hps\">las claves externas<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Mostrar<\/span> <span class=\"hps\">los procesos y poderlos matar<br \/>\n<\/span><\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Visualici\u00f3n de<\/span> <span class=\"hps\">los usuarios y<\/span> <span class=\"hps\">los derechos<\/span> <span class=\"hps\">con posibilidad de cambiarlos<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Las variables<\/span> <span class=\"hps\">de visualizaci\u00f3n<\/span>, con <span class=\"hps\">enlaces a la documentaci\u00f3n<\/span> <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Gesti\u00f3n<\/span> <span class=\"hps\">de eventos y<\/span> <span class=\"hps\">particiones de tabla<\/span> <span class=\"hps atn\">(<\/span>MySQL <span class=\"hps\">5.1<\/span>) <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Esquemas<\/span>, <span class=\"hps\">secuencias<\/span>, <span class=\"hps\">tipos de usuarios<\/span> <span class=\"hps atn\">(<\/span>PostgreSQL) <\/span><\/li>\n<li><span id=\"result_box\" lang=\"es\"><span class=\"hps\">Amplias<\/span> <span class=\"hps\">opciones de personalizaci\u00f3n<\/span><\/span><\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.adminer.org\/\" target=\"_blank\">Ver m\u00e1s informaci\u00f3n y descarga<\/a><\/p>\n<p><a href=\"http:\/\/www.prestashop.com\/forums\/topic\/217943-free-module-ninja-tools-developer-tools\/\" target=\"_blank\">Ver m\u00f3dulo para Prestashop<\/a><\/p>\n<p>Ver plugin para WordPress<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Adminer (antes phpMinAdmin) es una herramienta de gesti\u00f3n de base de datos con todas las funciones escritas en PHP. Adminer no es un proyecto de muchos archivos. Tan solo tiene un \u00fanico archivo con todas las opciones de phpMyAdmin. La instalaci\u00f3n es muy sencilla, tan solo tienes que descargar el archivo y subirlo al servidor. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6404,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,18],"tags":[],"class_list":["post-6403","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-herramientas","category-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Adminer - Jose Aguilar Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adminer - Jose Aguilar Blog\" \/>\n<meta property=\"og:description\" content=\"Adminer (antes phpMinAdmin) es una herramienta de gesti\u00f3n de base de datos con todas las funciones escritas en PHP. Adminer no es un proyecto de muchos archivos. Tan solo tiene un \u00fanico archivo con todas las opciones de phpMyAdmin. La instalaci\u00f3n es muy sencilla, tan solo tienes que descargar el archivo y subirlo al servidor. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jose-aguilar.com\/blog\/adminer\/\" \/>\n<meta property=\"og:site_name\" content=\"Jose Aguilar Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/joseaguilarblog\" \/>\n<meta property=\"article:published_time\" content=\"2014-08-04T19:48:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-08-04T11:56:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2014\/08\/adminer_logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"230\" \/>\n\t<meta property=\"og:image:height\" content=\"140\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jose Aguilar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:site\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jose Aguilar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/adminer\/\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/adminer\/\",\"name\":\"Adminer - Jose Aguilar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2014\/08\/adminer_logo.jpg\",\"datePublished\":\"2014-08-04T19:48:47+00:00\",\"dateModified\":\"2016-08-04T11:56:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jose-aguilar.com\/blog\/adminer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#primaryimage\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2014\/08\/adminer_logo.jpg\",\"contentUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2014\/08\/adminer_logo.jpg\",\"width\":230,\"height\":140},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.jose-aguilar.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adminer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/\",\"name\":\"Jose Aguilar Blog\",\"description\":\"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\",\"name\":\"Jose Aguilar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"caption\":\"Jose Aguilar\"},\"description\":\"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.\",\"sameAs\":[\"https:\/\/plus.google.com\/114357189801512615537\"],\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Adminer - Jose Aguilar Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"es_ES","og_type":"article","og_title":"Adminer - Jose Aguilar Blog","og_description":"Adminer (antes phpMinAdmin) es una herramienta de gesti\u00f3n de base de datos con todas las funciones escritas en PHP. Adminer no es un proyecto de muchos archivos. Tan solo tiene un \u00fanico archivo con todas las opciones de phpMyAdmin. La instalaci\u00f3n es muy sencilla, tan solo tienes que descargar el archivo y subirlo al servidor. [&hellip;]","og_url":"https:\/\/www.jose-aguilar.com\/blog\/adminer\/","og_site_name":"Jose Aguilar Blog","article_publisher":"https:\/\/www.facebook.com\/joseaguilarblog","article_published_time":"2014-08-04T19:48:47+00:00","article_modified_time":"2016-08-04T11:56:39+00:00","og_image":[{"width":230,"height":140,"url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2014\/08\/adminer_logo.jpg","type":"image\/jpeg"}],"author":"Jose Aguilar","twitter_card":"summary_large_image","twitter_creator":"@JoseAguilarBlog","twitter_site":"@JoseAguilarBlog","twitter_misc":{"Escrito por":"Jose Aguilar","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.jose-aguilar.com\/blog\/adminer\/","url":"https:\/\/www.jose-aguilar.com\/blog\/adminer\/","name":"Adminer - Jose Aguilar Blog","isPartOf":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#primaryimage"},"image":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2014\/08\/adminer_logo.jpg","datePublished":"2014-08-04T19:48:47+00:00","dateModified":"2016-08-04T11:56:39+00:00","author":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11"},"breadcrumb":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jose-aguilar.com\/blog\/adminer\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#primaryimage","url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2014\/08\/adminer_logo.jpg","contentUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2014\/08\/adminer_logo.jpg","width":230,"height":140},{"@type":"BreadcrumbList","@id":"https:\/\/www.jose-aguilar.com\/blog\/adminer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.jose-aguilar.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Adminer"}]},{"@type":"WebSite","@id":"https:\/\/www.jose-aguilar.com\/blog\/#website","url":"https:\/\/www.jose-aguilar.com\/blog\/","name":"Jose Aguilar Blog","description":"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11","name":"Jose Aguilar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","caption":"Jose Aguilar"},"description":"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.","sameAs":["https:\/\/plus.google.com\/114357189801512615537"],"url":"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/"}]}},"_links":{"self":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/6403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/comments?post=6403"}],"version-history":[{"count":0,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/6403\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media\/6404"}],"wp:attachment":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media?parent=6403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/categories?post=6403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/tags?post=6403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}