{"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":"2020-09-09T01:33:51","modified_gmt":"2020-09-09T01:33:51","slug":"guia-de-conexion-con-el-motor-de-base-de-datos-mysql-y-mariadb","status":"publish","type":"page","link":"https:\/\/support.mpsoftwarecmms.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><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t
<\/div><\/div>
\"\" <\/div>
\n

Bases de datos
\n<\/strong><\/h1>\n <\/div>
<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

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><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\tRegresar a: Creaci\u00f3n de bases de datos nuevas<\/span><\/a>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

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

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 del MP se marca la siguiente 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><\/div>
\r\n
\r\n
\r\n
\r\n \"\"\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>
<\/div><\/div>
<\/span><\/span>

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 el MP.<\/h4><\/span><\/span>\n<\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

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 el MP.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\tRegresar a: Creaci\u00f3n de bases de datos nuevas<\/span><\/a>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\r\n
\r\n\t
\r\n\t\t

Can't find a solution?<\/h1>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Please contact our technical support team<\/strong><\/h3>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

\ud83c\uddf2\ud83c\uddfd (52-55) 5364-5661 \/ 5364-5657<\/strong><\/h3>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>How to call from my country?<\/span><\/i><\/a>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

<\/i> SKYPE USER: mp_software<\/a><\/p>\n

<\/i> soporte@mpsoftware.com.mx<\/a><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\r\n
\r\n\t
\r\n\t\t
\n
\n

Horario de atenci\u00f3n de Lunes a Viernes de 8:00 a 18:00hrs<\/p>\n<\/div>\n<\/div>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\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><\/div>
<\/div><\/div>
<\/path> <\/svg><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\r\n
\r\n\t
\r\n\t\t

Participa en nuestro foro de ayuda<\/h3>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Deja una pregunta que tu y otros puedan tener y permite que nuestro equipo de Soporte T\u00e9cnico la responda p\u00fablicamente.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\nIr a Foro de Ayuda<\/span><\/a>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t

\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\r\n
\r\n\t
\r\n\t\t

Preguntas Frecuentes<\/h3>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Consulta nuestro sitio de Preguntas Frecuentes para conocer m\u00e1s sobre los esquemas de suscripci\u00f3n, nuestra amplia gama de opciones de conectividad, entre otros.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\nGo to frequently asked Questions<\/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>\n\t\t

<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\n\t
\n\t\t
\n\t\t\t\n
\r\n \r\n
\u00d7<\/span>
\r\n \r\n

Consideration if you are going to use the engine for Firebird database<\/strong><\/h4>\r\n\t\t\t

\r\n

However, the excellent performance that this database engine provides, it is important to take into account that this database engine is only recommended for users that do NOT want to use the mobile applications MPsolicitudes or MPmobile, because these APPs ARE NOT COMPATIBLE WITH THE ENGINE FIREBIRD DATABASES.<\/p>\r\n \r\n <\/div>\r\n<\/div>\n

\r\n \r\n
\u00d7<\/span>
\r\n \r\n

Name of the database and its location.<\/strong><\/h4>\r\n\t\t\t

\r\n

Regarding the name of the database: The name that you define can't wear white space, and the number of characters allowed maximum is 25, for example Maintenance Plant 1 instead use Hyphens or underscores this: Mantenimiento_Planta_1, in addition to it is not allowed that the name of your database-carry special characters such as these: \u00a1 " # , $ % & ( \u00bf ) ? } { The reason for this is that there are some rules or policies that the database engines prohibit the use of these characters.<\/p>\r\n\t\t\t\t\t\r\n\t\t\t

You'll have another field of up to 50 characters that will allow a broader description and complete database.<\/p>\r\n\t\t\t

Example:<\/p>\r\n\t\t\t\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Name of the database<\/strong><\/td>\r\nName of the access to the database<\/strong><\/td>\r\nLong description of the database<\/strong><\/td>\r\n<\/tr>\r\n
PLANTA_SPEREN_1<\/td>\r\nACCESS TO PLANTA_SPEREN_1<\/td>\r\nPLANT SPEREN PARQUE INDUSTRIAL EXPORTEC II<\/td>\r\n<\/tr>\r\n
PLANTA_SPEREN_2<\/td>\r\nACCESS TO PLANTA_SPEREN_2<\/td>\r\nPLANT SPEREN PARQUE INDUSTRIAL HUEHUETOCA<\/td>\r\n<\/tr>\r\n
PLANTA_SPEREN_3<\/td>\r\nACCESS TO PLANTA_SPEREN_3<\/td>\r\nPLANT SPEREN INDUSTRIAL PARK JILOTEPEC<\/td>\r\n<\/tr>\r\n
HOTEL_Mara_A<\/td>\r\nACCESS TO HOTEL_Mara_A<\/td>\r\nHotel All Inclusive Mara Place, Cancun, QR<\/td>\r\n<\/tr>\r\n
HOTEL_Mara_B<\/td>\r\nACCESS TO HOTEL_Mara_B<\/td>\r\nGran Executive Hotel Mara Place mexico City, Mexico<\/td>\r\n<\/tr>\r\n
HOSPITAL_TRAUMATOLOGIA<\/td>\r\nACCESS TO HOSPITAL_TRAUMATOLOGIA<\/td>\r\nHospital of Traumatology Loma Verdes, Naucalpan<\/td>\r\n<\/tr>\r\n
HOSPITAL_NEUROLOGIA<\/td>\r\nACCESS TO HOSPITAL_NEUROLOGIA<\/td>\r\nNational institute of Neurology and Neurosurgery, CDMX<\/td>\r\n<\/tr>\r\n
FLOTILLA_1<\/td>\r\nACCESS TO FLOTILLA_1<\/td>\r\nFleet Cars and trucks SPEREN EXPORTEC II<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n\t\t\t

After you've created your databases in the MP, these are hosted on the Database Server that you've chosen. For example, the databases created by the streamlined staying in your computer, the path in which you can find is C:\\Windows\\SysWow64 or C:\\Windows\\System32. Regularly are Files with the Extension.FDB<\/p>\r\n\t\t\t

The databases created in the following types of databases: MariaDB, MySQL, SQL-Server, MPcloud and Oracle does not generate Files. The information is stored in multiple tables of schema information, or in special environments of your server.<\/p>\r\n\t\t\t

Regardless of the type of database Server that you manage, we recommend to make backups of your information frequently so that you get a receipt of your information as a preventive measure in case of an emergency, see the section Backup and restore a database.<\/p>\r\n \r\n <\/div>\r\n<\/div>\n\t\t<\/div>\n\t<\/div>\n\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":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/3258"}],"collection":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/comments?post=3258"}],"version-history":[{"count":5,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/3258\/revisions"}],"predecessor-version":[{"id":3397,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/3258\/revisions\/3397"}],"wp:attachment":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/media?parent=3258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}