{"id":2310,"date":"2020-04-15T01:40:36","date_gmt":"2020-04-15T01:40:36","guid":{"rendered":"https:\/\/support.mpsoftwarecmms.com\/?page_id=2310"},"modified":"2024-07-31T11:40:15","modified_gmt":"2024-07-31T17:40:15","slug":"creacion-de-bases-de-datos-nuevas","status":"publish","type":"page","link":"https:\/\/support.mpsoftwarecmms.com\/en_us\/creacion-de-bases-de-datos-nuevas\/","title":{"rendered":"Creation of new databases"},"content":{"rendered":"
<\/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

Home<\/a> \/ About the installation, databases and the environment<\/a><\/p>\n

Creation of new databases<\/strong><\/h2>\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

Index<\/strong>
\n<\/a><\/h4>\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

Basic concepts about the creation of new databases<\/a>
\nWhat is a access to the database?<\/a>
\nSelection of the Database when you enter the application<\/a>
\nHow do I create a new database?<\/a>
\n\u2013 Streamlined for the creation of databases on your local computer <\/a>
\n\u2013 Advanced option for the creation of databases in the cloud or on a network (Firebird, SQL, MySQL, MariaDB, Oracle, Cloud and Hosting) <\/a><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/span><\/span><\/span><\/span><\/span>
<\/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

Related topics<\/strong><\/h4>\n

\u25b8 Types of databases and where you can stay<\/a>
\n\u25b8 Access to the database engine when hired Cloud or Hosting<\/a>
\n\u25b8 Uses the database of examples to practice and learn the System<\/a>
\n\u25b8 Introduction to data migration from previous versions<\/a>
\n\u25b8 How do I migrate the information from previous versions?<\/a>
\n\u25b8 Migration of databases without warranty<\/a>
\n\u25b8 Reason to register the users who will have access to each database<\/a>
\n\u25b8 What happens if I do not log users?<\/a>
\n\u25b8 Who is the admin user of the databases?<\/a>
\n\u25b8 Register users and assign user profiles<\/a>
\n\u25b8 Create custom access levels<\/a>
\n\u25b8 Log of transactions<\/a>
\n\u25b8 Connection of the programs installed on your computer with the database<\/a>
\n\u25b8 Create a shortcut in your pc to connect to a database<\/a>
\n\u25b8 Connection of the database with mobile devices<\/a><\/p>\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<\/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

Basic concepts about the creation of new databases<\/strong><\/h4>\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

To do the full installation of the program, it is installed on your computer, a database of examples that will allow you to start navigating through the program and become familiar with it quickly. About this database you will be able to make changes, add equipment, add parts, etc., allowing you to make tests and making it easier for the learning.<\/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\t
<\/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\r\n
\r\n\t
\r\n\t\t

Once you decide to initiate the deployment, you will need to create a new database with all the records in white where you'll start to upload your information or, if you are already a user .<\/h4>\n

To do this, you must have defined the database engine and your location<\/a>whether you want to host on your computer, in a virtual machine, in all kinds of networks (Wan, Lan, Wlan, Vlan, etc), on a server in the cloud, etc<\/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
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Multi Databases:<\/strong><\/p>\n

The System allows you create multiple databases to independently control the maintenance of various industrial plants, buildings, areas, etc..<\/p>\n

The management of separate databases, it is desirable for ease of administration and depends on the structure and organization of the maintenance of each company or corporate. For example, a large corporate hotels, surely it will be more convenient to manage a separate database for each hotel. Or, it is also possible that, in the case of an industrial plant, the management of the maintenance of the vehicle fleet to handle a separate area of the area responsible for the maintenance of the facilities. But as already mentioned, this way of organising the information in separate databases is optional and depends on the structure of the maintenance of each company or corporate.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

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

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

In the application Manager Databases and users MP also lets you determine who will have permission to access each database.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\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\r\n
\r\n\t
\r\n\t\t

What is a access to the databases?<\/strong><\/h4>\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

When you create a database, it automatically creates an access to the database. Access is a file that contains encoded all information regarding the IP address or name of the server where the database resides. This information is also recorded in a QR code, which will facilitate the connection of mobile devices to the database (The QR code is available for MySQL databases, SQL, Oracle, MariaDB, and Cloud. The QR code is not available for databases Firebird).<\/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\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
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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\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>
<\/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
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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\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>
<\/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

Selection of the Database when you enter the application<\/strong><\/h4>\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

When you run any of the programs in the suite of the MP, the first thing that appears is a window requesting the user to select the access database that you want to work.<\/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\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
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/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
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

To the right you can see the information of the access to each database.<\/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 \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

The QR code that appears in the window will be of great utility to facilitate the connection of mobile devices to the database. For more information, see connection of mobile applications MPmobile<\/u><\/span> and MPsolicitudes<\/u><\/span> (The QR code is available for MySQL databases, SQL, Oracle, MariaDB, and Cloud. The QR code is not available for databases Firebird).<\/p>\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<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

To the right you can see the information of the access to each database.<\/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 \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

The QR code that appears in the window will be of great utility to facilitate the connection of mobile devices to the database. For more information, see connection of mobile applications MPmobile<\/u><\/span> and MPsolicitudes<\/u><\/span> (The QR code is available for MySQL databases, SQL, Oracle, MariaDB, and Cloud. The QR code is not available for databases Firebird).<\/p>\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<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Once you have selected the database, the main menu appears. At the bottom of the main menu, appears the name of the selected database, the type of the database and the IP of the server in which it is located, as well as the name of the user.<\/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\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

If you want to change the database, double-click on the name of the database to present again the selector database.<\/p>\n

Also the icon of tools located in the top right corner of the screen allows us to change the database.<\/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\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\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

How do I create a new database?<\/strong><\/h4>\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

There are two options to create new databases.<\/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

Option 1. <\/strong>\u2013 From the applications in the Suite of the 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\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Note:<\/strong> Depending on the application you choose, you'll create a new database for the application. For example, if you do it from the application Inventory of spare Parts, from there you'll be able to create a new database for the Inventory of spare Parts.<\/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

Option 2. <\/strong>\u2013 From the desktop application Manager Databases and Users.<\/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\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
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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\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>
<\/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
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/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\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>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Below, we'll walk you through the creation of BD from the applications in the Suite and what it explains, and applies equally when we create a database from the Database Administrator and Users.<\/p>\n

The Database Administrator and Users, in addition to creating databases, it enables you to management a more complete database, with tools that allows you to edit a connection, to register users and set permissions for each user, make backups, etc<\/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

Step 1.\u00a0 When you run the program, select the option \u201cStart using my databases.\u201d<\/strong><\/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\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Step 2. Click on the button\u00a0Next.<\/strong><\/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\t\r\n
\r\n\t
\r\n\t\t

Step 3. Click on the button Add<\/strong> a database.
\n<\/strong><\/p>\n

\"\"<\/p>\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<\/div><\/div>

<\/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

Step 3. Click on the button Add<\/strong> a database.
\n<\/strong><\/p>\n

\"\"<\/p>\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<\/div><\/div>

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

Step 4.
\nChoose the Streamlined<\/a> if you're not familiar with the operation of the servers and database engines, and do not intend to share your database with other users.<\/p>\n

Choose the Advanced option<\/a> if you're going to share your databases in the cloud or on your company's network with other users.<\/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\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Step 5. Click on the button Next.
\n<\/strong><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\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\r\n
\r\n\t
\r\n\t\t

Streamlined for the creation of databases on your local computer<\/strong><\/h4>\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

When choosing this option will automatically create a database type Firebird into your computer. You only need to assign a name to the database, and a brief description to start working with her.<\/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\t
<\/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\r\n
\r\n\t
\r\n\t\t

This option is useful, and the more practice if you're not familiar with the handling of servers and database engines<\/a> and do not intend to share your database with other users.<\/h4>\n

If you are sharing your database with other users, our recommendation is that you use the advanced option<\/a>by placing it from the start it on a server with their respective database engine<\/a>.<\/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
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Notwithstanding the above recommendation, it is worth mentioning that if you created your database with the streamlined and later you want to change the location of the database or convert it to another database engine<\/a>, MP lets you do it.<\/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

When you select this option, the following screen appears:<\/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\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\n\t
\n\t\t
\n\t\t\t
\n

The IP 127.0.0.1 refers to the database is to be created on the hard disk of your computer where you are performing the process of creation of the database.<\/p>\n

The name of the database refers to the name of the database file type Firebird with extension .fdb that will be created on your computer. See characters and permitted length.<\/a><\/p>\n

Click next and a new window will appear that allows you to supplement with a brief description of the database. This description is up to 50 characters long and does not have limitations in terms of special characters:<\/p>\n<\/div>\n\t\t<\/div>\n\t<\/div>\n

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

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

Important consideration if you're going to use the Engine for Firebird Database<\/a><\/p><\/div>\n\t\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\r\n
\r\n\t
\r\n\t\t

Advanced option for the creation of databases in the cloud or on a network <\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n
\r\n\t
\r\n\t\t

(Firebird, SQL, MySQL, MariaDB, and Oracle)<\/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\n\n\n\n\n\n\n\n
You get to choose the server database engine<\/a> your preference and the location of your databases:<\/strong><\/td>\n<\/tr>\n
Free to use:<\/td>\n<\/td>\nThe Databases can be hosted on:<\/strong>
\n\u2013 The user's PC
\n\u2013 Virtual teams
\n\u2013 All type of networks (Wan, Lan, Wlan, Vlan, etc)
\n\u2013 Servers or web hosting in the cloud
\n\u2013 In our servers in the cloud if you hired the service MPcloud<\/a> or MPhosting<\/a><\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nFirebird<\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nMySQL<\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nMariaDB<\/td>\n<\/tr>\n
Owner or business:<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nMicrosoft SQL-Server<\/td>\n<\/tr>\n
<\/td>\n\"\"<\/td>\nOracle<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\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

If you have a network in your company, most likely already have some of the database engines supported. Not to be so, before you continue with the creation of a database, it is necessary to install and configure one of the database engines that are compatible with the Suite.<\/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\t
<\/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\r\n
\r\n\t
\r\n\t\t

Your IT department or systems will be able to advise you with respect to the database engine you use and indicate the location for the database, in accordance with the infrastructure and policies IT company<\/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
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Before proceeding with the creation of your database, it is important to take into account certain peculiarities that you'll need to configure depending on the database engine you want to use.<\/em><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

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

Click on the following links to learn more about the configurations that are required on your database engine:<\/p>\n

Important consideration if you're going to use the Engine for Firebird Database<\/a>
\nGuide of connection with the Database Engine, SQL<\/a>
\nGuide of connection with the Database Engine MySQL and MariaDB<\/a>
\nGuide to connecting with the Engine of Oracle Database<\/a>\n<\/p><\/div>\n\t\t<\/div>\n\t<\/div>\n

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

Note:
\nIf hired, the hosting service in the cloud Cloud<\/a> and Hosting<\/a>, you don't need to configure anything. The database engine is configured to start to create your databases.<\/p>\n

Once considered the above, and made the relevant configurations in your database engine, selected in the next window, the database engine to use, and click Next.<\/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\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

In all cases, including Cloud<\/a> and Hosting<\/a>you will get the following window prompts you for the information of the server and the database engine:<\/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\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
\r\n\t\t
<\/i><\/div>\r\n\t<\/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
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Service Cloud \/ Hosting:<\/u><\/em><\/strong><\/p>\n

In the case that you have hired the service<\/em><\/strong> Cloud<\/a> or Hosting<\/a>the Technical Support team provides you with this information in your detail of purchase, same, that we will send you at the time of contracting the service.
\n<\/em><\/strong><\/p>\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<\/div><\/div>
<\/div><\/div>\n\t
\n\t\t
\n\t\t\t
\n

In the first field, enter the IP address of your server or database server name where it will be located in your data-base of MT. In the particular case of Oracle<\/a>, you must write down the System ID of the Oracle service. What is this?<\/a><\/p>\n

In the following two fields, write down the name of a user name and password with permissions and privileges to create the database in the selected engine. For more information, see What is this?<\/a><\/p>\n

In the last field enter the name you assign to the database. See characters and permitted length.<\/a>. When you press next, you will have another field of up to 50 characters that will allow a broader description and complete database.<\/p>\n<\/div>\n\t\t<\/div>\n\t<\/div>\n

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

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

In the event you want to host your database in a server in the cloud or web hosting of your preference different to Cloud<\/a> or Hosting<\/a>you can also do it. Most of the service providers of web hosting include the database engine MySQL. Check with your service provider who will be able to tell you if your service contract includes a database engine, as well as the IP of the server, user, password, and capacity for data storage.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\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
<\/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 the answer to your doubts or questions?<\/h1>\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>
\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
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Additionally, we offer training courses<\/strong><\/h2>\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

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><\/p>\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
<\/div><\/div>Contact us<\/span><\/a>\r\n
\r\n\t
\r\n\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

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

Server IP, user name and password of the database engine<\/strong><\/h3>\r\n\t\t

\r\n\r\n

Today, virtually all companies have at least one IT professional who is responsible for, among many other functions to manage the data and servers of the company. Among their functions include the administration of a database engine, which, for security reasons, has access by means of a user name and a password. If not, any person could enter the network, and provide high-databases, query, modify and even delete confidential information of the company.<\/p>\r\n\r\n

For example:<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
DATABASE ENGINE<\/strong><\/td>\r\nADMINISTRATOR USER BY DEFAULT<\/strong><\/td>\r\nPASSWORD\r\n<\/strong>(Known only to the manager of IT)<\/strong><\/td>\r\n<\/tr>\r\n
MySQL<\/td>\r\nroot<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
Microsoft SQL-Server<\/td>\r\nsa<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
Oracle<\/td>\r\nSystem<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
MariaDB<\/td>\r\nroot<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
Firebird<\/td>\r\nSYSDBA<\/td>\r\n******<\/td>\r\n<\/tr>\r\n<\/table>\r\n

When you create a database, or a new connection on the MP, the program prompts you for the server name or IP where you will create or is the database to which you want to connect to, as well as a user name and password.<\/p>\r\n

The username and password that here we ask, are precisely those that allow access to the <\/em>database engine <\/em>permissions privileges to create the database. <\/em><\/h4>\r\n

\r\n\t\t\t\r\n

\r\n

Now, the administrator of the database can also create different user accounts to allow access to more people by giving them privileges and permissions custom.<\/p>\r\n\r\n

With the aim of not to use the administrator user of IT and its respective password each time that the department of maintenance required to create a database or a connection to an existing database, it is recommended that the IT administrator create a user account specifically for the maintenance department.<\/em><\/h4>\r\n

A single user account to the database engine is sufficient for the creation and connection of multiple databases.<\/p>\r\n\r\n

The username and password that here is requested, you do not have any relationship with the licenses of use are acquired or the amount of users that can access the database, so that a single user account can be enough, because in this case it refers specifically to the user and password of the database engine.<\/p>\r\n\t\t \r\n <\/div>\r\n<\/div>
\n

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

What is a access to the database?<\/strong><\/h3>\r\n\t\t

\r\n\r\n

When you create a database, it automatically creates an access to the database. Access is a file that contains encoded all information regarding the IP address or name of the server where the database resides. This information is also recorded in a QR code, which will facilitate the connection of mobile devices to the database.<\/p>\r\n\t\t \r\n <\/div>\r\n<\/div>\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<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>","protected":false},"excerpt":{"rendered":"Inicio \/ Acerca de la instalaci\u00f3n, bases de datos y el entorno Creaci\u00f3n de bases...","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\/2310"}],"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=2310"}],"version-history":[{"count":83,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/2310\/revisions"}],"predecessor-version":[{"id":7477,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/2310\/revisions\/7477"}],"wp:attachment":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/media?parent=2310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}