{"id":14402,"date":"2023-01-27T12:51:40","date_gmt":"2023-01-27T10:51:40","guid":{"rendered":"https:\/\/www.espai.es\/blog\/?p=14402"},"modified":"2023-01-27T14:38:30","modified_gmt":"2023-01-27T12:38:30","slug":"conectar-a-una-base-de-datos-con-mysql-workbench","status":"publish","type":"post","link":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/","title":{"rendered":"Conectar a una base de datos con Mysql Workbench"},"content":{"rendered":"<p>Hola a todos y bienvenidos a un nuevo art\u00edculo del blog. Hoy vamos a ver c\u00f3mo Conectar a una base de datos con Mysql Workbench, que es una herramienta muy \u00fatil para este prop\u00f3sito.<\/p>\n<p>Pero antes de comenzar&#8230;<\/p>\n<p>&nbsp;<\/p>\n<h2>\u00bfQu\u00e9 es una base de datos?<\/h2>\n<p>Es un programa que nos permite almacenar informaci\u00f3n. Algo as\u00ed como un fichero de texto que tiene estructura, es decir la informaci\u00f3n no est\u00e1 almacenada de manera \u00absecuencial\u00bb como en un fichero, sino dividida en <strong>tablas<\/strong>.<\/p>\n<p>Una <strong>tabla<\/strong> est\u00e1 formada por <strong>filas<\/strong> y <strong>columnas<\/strong>. Una columna por ejemplo ser\u00eda el nombre de una persona, otra su apellido, otra la edad&#8230;<\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_14413\" style=\"width: 1234px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_8.png\" rel=\"attachment wp-att-14413\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-14413\" class=\"wp-image-14413 size-full\" src=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_8.png\" alt=\"mysql ejemplo de tabla\" width=\"1224\" height=\"364\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_8.png 1224w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_8-300x89.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_8-1024x305.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_8-768x228.png 768w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_8-700x208.png 700w\" sizes=\"auto, (max-width: 1224px) 100vw, 1224px\" \/><\/a><p id=\"caption-attachment-14413\" class=\"wp-caption-text\">Ejemplo de tabla<\/p><\/div>\n<p>&nbsp;<\/p>\n<p>Tambi\u00e9n contiene filas, que ser\u00edan en nuestro ejemplo una por cada persona. Pedro-Garcia-33 ser\u00eda una fila, Mar\u00eda-Lopez-44 ser\u00eda otra.<\/p>\n<p>La ventaja de almacenar la informaci\u00f3n de esta forma es que nos permite hacer b\u00fasquedas muy r\u00e1pidas. No importar\u00eda tener 10 millones de personas guardadas en la tabla, tardar\u00edamos milisegundos en encontrarlas.<\/p>\n<p>Despu\u00e9s de esta breve intro, vamos al programa<\/p>\n<p>&nbsp;<\/p>\n<h2>\u00bfC\u00f3mo consigo MySql Workbench?<\/h2>\n<p>&nbsp;<\/p>\n<p>Haz click <a href=\"https:\/\/dev.mysql.com\/downloads\/workbench\/\">aqu\u00ed<\/a> para descargarlo. En mi caso usar\u00e9 la versi\u00f3n de Windows, pero tienes tambi\u00e9n para Mac y Linux.<\/p>\n<p><a href=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_1.png\" rel=\"attachment wp-att-14403\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14403\" src=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_1.png\" alt=\"mysql descarga\" width=\"1183\" height=\"754\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_1.png 1183w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_1-300x191.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_1-1024x653.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_1-768x489.png 768w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_1-700x446.png 700w\" sizes=\"auto, (max-width: 1183px) 100vw, 1183px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Despu\u00e9s de este paso, la instalaci\u00f3n es muy sencilla. Solamente pulsa siguiente-siguiente\u00a0 y ya lo tienes.<\/p>\n<p>&nbsp;<\/p>\n<h2>\u00bfYa est\u00e1?<\/h2>\n<p>&nbsp;<\/p>\n<p>Pues&#8230; No. Antes de conectar a una base de datos con Mysql Workbench necesitamos una base de datos a la que conectar.<\/p>\n<p>Workbench es un \u00abcliente\u00bb de base de datos, lo que significa que se conecta a una base de datos que <strong>YA<\/strong> existe. Lo m\u00e1s f\u00e1cil para conseguir una es instalar \u00abXampp\u00bb. Este programa es descargable <a href=\"https:\/\/www.apachefriends.org\/es\/download.html\">aqu\u00ed<\/a>.<\/p>\n<p><a href=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_2.png\" rel=\"attachment wp-att-14404\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14404\" src=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_2.png\" alt=\"mysql instalacion de xampp\" width=\"1000\" height=\"847\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_2.png 1000w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_2-300x254.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_2-768x650.png 768w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_2-700x593.png 700w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Una vez instalado (tambi\u00e9n siguiente &#8211; siguiente) tendr\u00edas que abrir el panel de control:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_3.png\" rel=\"attachment wp-att-14405\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14405\" src=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_3.png\" alt=\"mysql abrir panel de control xampp\" width=\"440\" height=\"402\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_3.png 440w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_3-300x274.png 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>y con esto, ya tenemos una base de datos instalada. El panel de control (de xampp) tendr\u00e1 este aspecto:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_4.png\" rel=\"attachment wp-att-14406\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14406\" src=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_4.png\" alt=\"mysql iniciar base de datos desde xampp\" width=\"835\" height=\"543\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_4.png 835w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_4-300x195.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_4-768x499.png 768w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_4-400x260.png 400w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_4-700x455.png 700w\" sizes=\"auto, (max-width: 835px) 100vw, 835px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Haz click en el bot\u00f3n marcado en rojo. Cuando est\u00e9 iniciado MySql, te saldr\u00e1 en verde (a la izquierda) y el bot\u00f3n se convertir\u00e1 en un \u00abStop\u00bb.<\/p>\n<p>&nbsp;<\/p>\n<p>Con esto ya tienes una base de datos funcionando, ahora conectaremos a ella.<\/p>\n<h2>Iniciamos Workbench<\/h2>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_5.png\" rel=\"attachment wp-att-14407\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14407\" src=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_5.png\" alt=\"mysql iniciar programa\" width=\"980\" height=\"800\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_5.png 980w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_5-300x245.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_5-768x627.png 768w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_5-700x571.png 700w\" sizes=\"auto, (max-width: 980px) 100vw, 980px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>La primera ventana que veremos es esta:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_6.png\" rel=\"attachment wp-att-14408\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14408\" src=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_6.png\" alt=\"conectar a mysql desde workbench\" width=\"765\" height=\"735\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_6.png 765w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_6-300x288.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_6-700x673.png 700w\" sizes=\"auto, (max-width: 765px) 100vw, 765px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Esta es la ventana de \u00abselecci\u00f3n\u00bb donde escogemos a que base de datos conectar. Puede ser que tengamos muchas conexiones, en nuestro ordenador o incluso en otros, de la red local o de internet&#8230; Pero de momento solo tenemos 1, la que pone\u00bblocal\u00bb. Est\u00e1 en nuestro ordenador y corresponde con el xampp que acabamos de instalar.<\/p>\n<p>&nbsp;<\/p>\n<h2>Divisi\u00f3n de la ventana de Workbench<\/h2>\n<p>Si pulsas en ese bot\u00f3n (marcado en rojo) te aparecer\u00e1 esta ventana:<\/p>\n<p><a href=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_7.png\" rel=\"attachment wp-att-14411\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14411\" src=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_7.png\" alt=\"mysql - division de la ventana\" width=\"1914\" height=\"1024\" srcset=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_7.png 1914w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_7-300x161.png 300w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_7-1024x548.png 1024w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_7-768x411.png 768w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_7-1536x822.png 1536w, https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_7-700x375.png 700w\" sizes=\"auto, (max-width: 1914px) 100vw, 1914px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Cada secci\u00f3n se encarga de algo diferente, vamos a hacer un resumen r\u00e1pido.<\/p>\n<ol>\n<li>Lista de \u00abesquemas\u00bb o bases de datos. En mi caso tengo 4, pero de serie con xampp solo vienen las 2 \u00faltimas.\u00a0 Cada base de datos que crees se ver\u00e1 aqu\u00ed.<\/li>\n<li>Panel de \u00abscripts\u00bb. Una base de datos (relacional, que es el tipo m\u00e1s com\u00fan) se consulta usando el lenguaje SQL. En esta ventana escribir\u00edamos este SQL. Si quieres ver un ejemplo de este lenguaje, click <a href=\"https:\/\/www.w3schools.com\/sql\/sql_examples.asp\">aqu\u00ed<\/a>.<\/li>\n<li>Este panel muestra informaci\u00f3n adicional, pero por el momento no lo necesitamos.<\/li>\n<li>Cuando seleccionemos una tabla de la base de datos, aqu\u00ed veremos los detalles de esa tabla. Por ejemplo, qu\u00e9 columnas contiene y que tama\u00f1o tiene cada una.<\/li>\n<li>Output es la ventana donde Workbench nos informar\u00e1 de los errores. SQL es un lenguaje sencillo pero como todo, es posible cometer errores que aparecer\u00e1n aqu\u00ed.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>Y hasta aqu\u00ed el art\u00edculo de hoy, en la segunda parte veremos como crear una base de datos y haremos algunas consultas en lenguaje SQL.<\/p>\n<p>&nbsp;<\/p>\n<p>\u00a1Un saludo y hasta la pr\u00f3xima!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hola a todos y bienvenidos a un nuevo art\u00edculo del blog. Hoy vamos a ver c\u00f3mo Conectar a una base de datos con Mysql Workbench, que es una herramienta muy \u00fatil para este prop\u00f3sito. Pero antes de comenzar&#8230; &nbsp; \u00bfQu\u00e9 es una base de datos?&#8230;<\/p>\n","protected":false},"author":3,"featured_media":14415,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_ef_editorial_meta_date_first-draft-date":"","_ef_editorial_meta_paragraph_assignment":"","_ef_editorial_meta_checkbox_needs-photo":"","_ef_editorial_meta_number_word-count":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[379,5],"tags":[385,842,387],"class_list":["post-14402","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-productividad","category-programacion","tag-bases-de-datos","tag-mysql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Conectar a una base de datos con Mysql Workbench - Blog Escola Espai<\/title>\n<meta name=\"description\" content=\"Hola y bienvenidos, en este art\u00edculo del blog de Espai veremos su instalaci\u00f3n y c\u00f3mo conectar a una base de datos con Mysql Workbench\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conectar a una base de datos con Mysql Workbench - Blog Escola Espai\" \/>\n<meta property=\"og:description\" content=\"Hola y bienvenidos, en este art\u00edculo del blog de Espai veremos su instalaci\u00f3n y c\u00f3mo conectar a una base de datos con Mysql Workbench\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Escola Espai\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-27T10:51:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-27T12:38:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Escobar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Escobar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/\"},\"author\":{\"name\":\"Escobar\",\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602\"},\"headline\":\"Conectar a una base de datos con Mysql Workbench\",\"datePublished\":\"2023-01-27T10:51:40+00:00\",\"dateModified\":\"2023-01-27T12:38:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/\"},\"wordCount\":674,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg\",\"keywords\":[\"bases de datos\",\"mysql\",\"sql\"],\"articleSection\":[\"Productividad\",\"Programaci\u00f3n\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/\",\"url\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/\",\"name\":\"Conectar a una base de datos con Mysql Workbench - Blog Escola Espai\",\"isPartOf\":{\"@id\":\"https:\/\/www.espai.es\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg\",\"datePublished\":\"2023-01-27T10:51:40+00:00\",\"dateModified\":\"2023-01-27T12:38:30+00:00\",\"author\":{\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602\"},\"description\":\"Hola y bienvenidos, en este art\u00edculo del blog de Espai veremos su instalaci\u00f3n y c\u00f3mo conectar a una base de datos con Mysql Workbench\",\"breadcrumb\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#primaryimage\",\"url\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg\",\"contentUrl\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg\",\"width\":1000,\"height\":500,\"caption\":\"mysql portada\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.espai.es\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conectar a una base de datos con Mysql Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.espai.es\/blog\/#website\",\"url\":\"https:\/\/www.espai.es\/blog\/\",\"name\":\"Blog Escola Espai\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.espai.es\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602\",\"name\":\"Escobar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g\",\"caption\":\"Escobar\"},\"sameAs\":[\"http:\/\/www.espai.es\"],\"url\":\"https:\/\/www.espai.es\/blog\/author\/escobar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conectar a una base de datos con Mysql Workbench - Blog Escola Espai","description":"Hola y bienvenidos, en este art\u00edculo del blog de Espai veremos su instalaci\u00f3n y c\u00f3mo conectar a una base de datos con Mysql Workbench","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:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/","og_locale":"es_ES","og_type":"article","og_title":"Conectar a una base de datos con Mysql Workbench - Blog Escola Espai","og_description":"Hola y bienvenidos, en este art\u00edculo del blog de Espai veremos su instalaci\u00f3n y c\u00f3mo conectar a una base de datos con Mysql Workbench","og_url":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/","og_site_name":"Blog Escola Espai","article_published_time":"2023-01-27T10:51:40+00:00","article_modified_time":"2023-01-27T12:38:30+00:00","og_image":[{"width":1000,"height":500,"url":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg","type":"image\/jpeg"}],"author":"Escobar","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Escobar","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#article","isPartOf":{"@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/"},"author":{"name":"Escobar","@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602"},"headline":"Conectar a una base de datos con Mysql Workbench","datePublished":"2023-01-27T10:51:40+00:00","dateModified":"2023-01-27T12:38:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/"},"wordCount":674,"commentCount":0,"image":{"@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg","keywords":["bases de datos","mysql","sql"],"articleSection":["Productividad","Programaci\u00f3n"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/","url":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/","name":"Conectar a una base de datos con Mysql Workbench - Blog Escola Espai","isPartOf":{"@id":"https:\/\/www.espai.es\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg","datePublished":"2023-01-27T10:51:40+00:00","dateModified":"2023-01-27T12:38:30+00:00","author":{"@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602"},"description":"Hola y bienvenidos, en este art\u00edculo del blog de Espai veremos su instalaci\u00f3n y c\u00f3mo conectar a una base de datos con Mysql Workbench","breadcrumb":{"@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#primaryimage","url":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg","contentUrl":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg","width":1000,"height":500,"caption":"mysql portada"},{"@type":"BreadcrumbList","@id":"https:\/\/www.espai.es\/blog\/2023\/01\/conectar-a-una-base-de-datos-con-mysql-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.espai.es\/blog\/"},{"@type":"ListItem","position":2,"name":"Conectar a una base de datos con Mysql Workbench"}]},{"@type":"WebSite","@id":"https:\/\/www.espai.es\/blog\/#website","url":"https:\/\/www.espai.es\/blog\/","name":"Blog Escola Espai","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.espai.es\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602","name":"Escobar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g","caption":"Escobar"},"sameAs":["http:\/\/www.espai.es"],"url":"https:\/\/www.espai.es\/blog\/author\/escobar\/"}]}},"jetpack_featured_media_url":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2023\/01\/mysql_workbenc_portada.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts\/14402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/comments?post=14402"}],"version-history":[{"count":4,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts\/14402\/revisions"}],"predecessor-version":[{"id":14410,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts\/14402\/revisions\/14410"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/media\/14415"}],"wp:attachment":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/media?parent=14402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/categories?post=14402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/tags?post=14402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}