{"id":3258,"date":"2020-07-28T01:33:14","date_gmt":"2020-07-28T01:33:14","guid":{"rendered":"https:\/\/support.mpsoftwarecmms.com\/?page_id=3258"},"modified":"2025-05-21T19:12:39","modified_gmt":"2025-05-22T01:12:39","slug":"guia-de-conexion-con-el-motor-de-base-de-datos-mysql-y-mariadb","status":"publish","type":"page","link":"https:\/\/support.svisioncmms.com\/en_us\/guia-de-conexion-con-el-motor-de-base-de-datos-mysql-y-mariadb\/","title":{"rendered":"Guia de conexi\u00f3n con el motor de base de datos MySQL y MariaDB"},"content":{"rendered":"<div id=\"rowone\"  data-column-margin=\"default\" data-midnight=\"dark\"  class=\"wpb_row vc_row-fluid vc_row standard_section\"  style=\"padding-top: 0px; padding-bottom: 0px; \"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-overlay=\"false\"><div class=\"inner-wrap\"><div class=\"row-bg\"  style=\"\"><\/div><\/div><div class=\"row-bg-overlay\" ><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\">\n\t<div style=\"margin-top: -30px; \" class=\"vc_col-sm-12 wpb_column column_container vc_column_container col neg-marg no-extra-padding inherit_tablet inherit_phone\"  data-t-w-inherits=\"default\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\" >\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t\t<div class=\"wpb_wrapper\">\n\t\t\t\t<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 35px;\" class=\"divider\"><\/div><\/div><div class=\"iwithtext\"><div class=\"iwt-icon\">  <\/div><div class=\"iwt-text\"> \n<h1><strong>Bases de datos<br \/>\n<\/strong><\/h1>\n <\/div><div class=\"clear\"><\/div><\/div><div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\r\n<div class=\"wpb_text_column wpb_content_element\" >\r\n\t<div class=\"wpb_wrapper\">\r\n\t\t<h2><strong>Guia de conexi\u00f3n con el motor de base de datos MySQL y MariaDB<\/strong><\/h2>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 60px;\" class=\"divider\"><\/div><\/div><div id=\"fws_6a0494e56a092\" data-midnight=\"\" data-column-margin=\"default\" class=\"wpb_row vc_row-fluid vc_row inner_row standard_section\"  style=\"padding-top: 0px; padding-bottom: 0px; \"><div class=\"row-bg-wrap\"> <div class=\"row-bg\" ><\/div> <\/div><div class=\"row_col_wrap_12_inner col span_12  left\">\n\t<div  class=\"vc_col-sm-12 wpb_column column_container vc_column_container col child_column no-extra-padding inherit_tablet inherit_phone\"   data-t-w-inherits=\"default\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\">\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<a class=\"nectar-button small see-through extra-color-2\"  style=\"\"  href=\"https:\/\/support.svisioncmms.com\/en_us\/creacion-de-bases-de-datos-nuevas\/#ligasbases\" data-color-override=\"false\" data-hover-color-override=\"false\" data-hover-text-color-override=\"#fff\"><span>Regresar a: Creaci\u00f3n de bases de datos nuevas<\/span><\/a>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div><div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t<div id=\"creacionbases1\"  data-column-margin=\"default\" data-midnight=\"dark\"  class=\"wpb_row vc_row-fluid vc_row standard_section\"  style=\"padding-top: 0px; padding-bottom: 0px; \"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-overlay=\"false\"><div class=\"inner-wrap\"><div class=\"row-bg\"  style=\"\"><\/div><\/div><div class=\"row-bg-overlay\" ><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\">\n\t<div  class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone\"  data-t-w-inherits=\"default\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\" >\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t\t<div class=\"wpb_wrapper\">\n\t\t\t\t\r\n<div class=\"wpb_text_column wpb_content_element\" >\r\n\t<div class=\"wpb_wrapper\">\r\n\t\t<p>La particularidad de bases de datos de MySQL y MariaDB es que se pueden crear en un servidor Web o una Intranet. La mayor\u00eda de los proveedores de servicios de web hosting incluyen el motor de base de datos MySQL. Consulta a tu proveedor del servicio.<\/p>\n<p>En el caso de hospedar tus bases de datos en la Web, por seguridad y administraci\u00f3n del manejador Web, primero se tienen que generar las bases de datos sin ninguna estructura desde el administrador de su Hosting. Una vez creada la base de datos con un manejador de base de datos tipo Plesk, phpmyadmin, workbench, etc., en la aplicaci\u00f3n de SVISION se marca la casilla para crear la estructura de las bases de datos con las tablas y campos necesarios. \u00a0El nombre de la base de datos que aqu\u00ed se teclee, debe ser el mismo nombre de la base de datos creada previamente desde el administrador de su Hosting.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 40px;\" class=\"divider\"><\/div><\/div><div class=\"img-with-aniamtion-wrap\" data-max-width=\"50%\" data-max-width-mobile=\"default\" data-border-radius=\"none\" data-shadow=\"none\" data-animation=\"fade-in\" >\r\n      <div class=\"inner\">\r\n        <div class=\"hover-wrap\" data-hover-animation=\"none\"> \r\n          <div class=\"hover-wrap-inner\">\r\n            <img class=\"img-with-animation skip-lazy gris\" data-delay=\"0\" height=\"730\" width=\"1111\" data-animation=\"fade-in\" src=\"https:\/\/support.svisioncmms.com\/wp-content\/uploads\/2025\/05\/casilla_mysql.jpg\" alt=\"\" srcset=\"https:\/\/support.svisioncmms.com\/wp-content\/uploads\/2025\/05\/casilla_mysql.jpg 1111w, https:\/\/support.svisioncmms.com\/wp-content\/uploads\/2025\/05\/casilla_mysql-300x197.jpg 300w, https:\/\/support.svisioncmms.com\/wp-content\/uploads\/2025\/05\/casilla_mysql-1024x673.jpg 1024w, https:\/\/support.svisioncmms.com\/wp-content\/uploads\/2025\/05\/casilla_mysql-768x505.jpg 768w, https:\/\/support.svisioncmms.com\/wp-content\/uploads\/2025\/05\/casilla_mysql-18x12.jpg 18w\" sizes=\"(min-width: 1450px) 75vw, (min-width: 1000px) 85vw, 100vw\" \/>\r\n          <\/div>\r\n        <\/div>\r\n      <\/div>\r\n    <\/div><div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 50px;\" class=\"divider\"><\/div><\/div><div class=\"vc_separator wpb_content_element vc_separator_align_center vc_sep_width_80 vc_sep_border_width_3 vc_sep_pos_align_center vc_separator-has-text\" ><span class=\"vc_sep_holder vc_sep_holder_l\"><span  style=\"border-color:#ffbb00;\" class=\"vc_sep_line\"><\/span><\/span><h4>Si la base de datos est\u00e1 en tu Intranet, NO ES NECESARIO MARCAR LA CASILLA ni crear las bases de datos previamente ya que el proceso completo lo hace SVISION<\/h4><span class=\"vc_sep_holder vc_sep_holder_r\"><span  style=\"border-color:#ffbb00;\" class=\"vc_sep_line\"><\/span><\/span>\n<\/div><div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\r\n<div class=\"wpb_text_column wpb_content_element\" >\r\n\t<div class=\"wpb_wrapper\">\r\n\t\t<p>Otro escenario especial en el cual esta casilla podr\u00eda ser habilitada, es cuando por razones de seguridad en el servidor de base de datos, el administrador de IT ha creado la base de datos en blanco sin estructura y te asigna como usuario\u00a0 de dicha base con los permisos necesarios para que en ella se registre la estructura de tablas requeridas por SVISION.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 60px;\" class=\"divider\"><\/div><\/div><div id=\"fws_6a0494e56df5c\" data-midnight=\"\" data-column-margin=\"default\" class=\"wpb_row vc_row-fluid vc_row inner_row standard_section\"  style=\"padding-top: 0px; padding-bottom: 0px; \"><div class=\"row-bg-wrap\"> <div class=\"row-bg\" ><\/div> <\/div><div class=\"row_col_wrap_12_inner col span_12  left\">\n\t<div  class=\"vc_col-sm-12 wpb_column column_container vc_column_container col child_column no-extra-padding inherit_tablet inherit_phone\"   data-t-w-inherits=\"default\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\">\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<a class=\"nectar-button small see-through extra-color-2\"  style=\"\"  href=\"https:\/\/support.svisioncmms.com\/en_us\/creacion-de-bases-de-datos-nuevas\/#ligasbases\" data-color-override=\"false\" data-hover-color-override=\"false\" data-hover-text-color-override=\"#fff\"><span>Regresar a: Creaci\u00f3n de bases de datos nuevas<\/span><\/a>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div><div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 60px;\" class=\"divider\"><\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t<div id=\"fws_6a0494e56ed2d\"  data-column-margin=\"default\" data-midnight=\"light\" data-top-percent=\"5%\" data-bottom-percent=\"5%\"  class=\"wpb_row vc_row-fluid vc_row full-width-section  vc_row-o-equal-height vc_row-flex  vc_row-o-content-middle standard_section\"  style=\"padding-top: calc(100vw * 0.05); padding-bottom: calc(100vw * 0.05); \"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-overlay=\"true\"><div class=\"inner-wrap\"><div class=\"row-bg using-bg-color\"  style=\"background-color: #4497ea; \"><\/div><\/div><div class=\"row-bg-overlay\" style=\"background-color:#4497ea;  opacity: 0.95; \"><\/div><\/div><div class=\"row_col_wrap_12 col span_12 light left\">\n\t<div  class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone\"  data-t-w-inherits=\"default\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\" >\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t\t<div class=\"wpb_wrapper\">\n\t\t\t\t<div id=\"fws_6a0494e56f3f9\" data-midnight=\"\" data-column-margin=\"default\" class=\"wpb_row vc_row-fluid vc_row inner_row standard_section\"  style=\"padding-top: 0px; padding-bottom: 0px; \"><div class=\"row-bg-wrap\"> <div class=\"row-bg\" ><\/div> <\/div><div class=\"row_col_wrap_12_inner col span_12  left\">\n\t<div  class=\"vc_col-sm-2 wpb_column column_container vc_column_container col child_column no-extra-padding inherit_tablet inherit_phone\"   data-t-w-inherits=\"default\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\">\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t<div  class=\"vc_col-sm-8 wpb_column column_container vc_column_container col child_column centered-text padding-2-percent inherit_tablet inherit_phone\"   data-t-w-inherits=\"default\" data-bg-cover=\"\" data-padding-pos=\"left-right\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\">\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\r\n<div class=\"wpb_text_column wpb_content_element\" >\r\n\t<div class=\"wpb_wrapper\">\r\n\t\t<h1>Can&#039;t find the answer to your doubts or questions?<\/h1>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t<div  class=\"vc_col-sm-2 wpb_column column_container vc_column_container col child_column no-extra-padding inherit_tablet inherit_phone\"   data-t-w-inherits=\"default\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\">\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t<div id=\"fws_6a0494e5703c0\"  data-column-margin=\"default\" data-midnight=\"light\" data-top-percent=\"2%\"  class=\"wpb_row vc_row-fluid vc_row full-width-section standard_section\"  style=\"padding-top: calc(100vw * 0.02); padding-bottom: 0px; \"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-overlay=\"true\"><div class=\"inner-wrap\"><div class=\"row-bg using-bg-color\"  style=\"background-color: #000cb5; \"><\/div><\/div><div class=\"row-bg-overlay\" style=\"background-color:#000cb5;  opacity: 0.95; \"><\/div><\/div><div class=\"row_col_wrap_12 col span_12 light left\">\n\t<div  class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone\"  data-t-w-inherits=\"default\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\" >\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t\t<div class=\"wpb_wrapper\">\n\t\t\t\t<div id=\"fws_6a0494e570ac1\" data-midnight=\"\" data-column-margin=\"default\" class=\"wpb_row vc_row-fluid vc_row inner_row standard_section\"  style=\"padding-top: 0px; padding-bottom: 0px; -webkit-transform:  translateY(-100px); transform:  translateY(-100px);\"><div class=\"row-bg-wrap\"> <div class=\"row-bg\" ><\/div> <\/div><div class=\"row_col_wrap_12_inner col span_12  left\">\n\t<div style=\" color: #ffffff;\" class=\"vc_col-sm-6 wpb_column column_container vc_column_container col child_column centered-text padding-6-percent inherit_tablet inherit_phone\" data-cfc=\"true\"  data-t-w-inherits=\"default\" data-shadow=\"medium_depth\" data-border-radius=\"15px\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\">\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t\r\n<div class=\"wpb_text_column wpb_content_element\" >\r\n\t<div class=\"wpb_wrapper\">\r\n\t\t<h4>Additionally, we offer training courses<\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 15px;\" class=\"divider\"><\/div><\/div>\r\n<div class=\"wpb_text_column wpb_content_element\" >\r\n\t<div class=\"wpb_wrapper\">\r\n\t\t<h4><span lang=\"es\">Our flexible options of online training and face-to-face will provide you with all the knowledge necessary to understand and implement your software maintenance.<\/span><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t<div style=\" color: #ffffff;\" class=\"vc_col-sm-6 wpb_column column_container vc_column_container col child_column centered-text padding-6-percent inherit_tablet inherit_phone\" data-cfc=\"true\"  data-t-w-inherits=\"default\" data-shadow=\"medium_depth\" data-border-radius=\"10px\" data-bg-cover=\"\" data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-hover-bg=\"\" data-hover-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\">\n\t\t<div class=\"vc_column-inner\" ><div class=\"column-bg-overlay-wrap\" data-bg-animation=\"none\"><div class=\"column-bg-overlay\"><\/div><\/div>\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<a class=\"nectar-button large see-through-2\"  style=\"margin-top: 30px; margin-bottom: 1px; border-color: #ffffff; color: #ffffff;\" target=\"_blank\" href=\"https:\/\/svisioncmms.com\/es\/contact\" data-color-override=\"#ffffff\"  data-hover-color-override=\"#ffffff\" data-hover-text-color-override=\"#000000\"><span>Contact us<\/span><\/a>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>","protected":false},"excerpt":{"rendered":"Bases de datos Guia de conexi\u00f3n con el motor de base de datos MySQL y...","protected":false},"author":11,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/support.svisioncmms.com\/en_us\/wp-json\/wp\/v2\/pages\/3258"}],"collection":[{"href":"https:\/\/support.svisioncmms.com\/en_us\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/support.svisioncmms.com\/en_us\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/support.svisioncmms.com\/en_us\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/support.svisioncmms.com\/en_us\/wp-json\/wp\/v2\/comments?post=3258"}],"version-history":[{"count":9,"href":"https:\/\/support.svisioncmms.com\/en_us\/wp-json\/wp\/v2\/pages\/3258\/revisions"}],"predecessor-version":[{"id":7833,"href":"https:\/\/support.svisioncmms.com\/en_us\/wp-json\/wp\/v2\/pages\/3258\/revisions\/7833"}],"wp:attachment":[{"href":"https:\/\/support.svisioncmms.com\/en_us\/wp-json\/wp\/v2\/media?parent=3258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}