Have the tools to manage a database It is essential when accessing information of interest or importance, especially when it is for work reasons. For this reason, there is nothing better in these cases than connecting and synchronizing two (or more) computers to a MySQL Server database.
On the web you can find endless software that will help you make connections between different computers for the access, extraction and manipulation of content stored in a database. However, this is where you will find the best.
One database, two computers
If such is the case that, you keep a database connected to a computer, but it is time to expand access capacity to this information and you want to know how to do it, you are in the right place. Where you can even download, install, configure and use MySQL on your Mac OS X Lion.
A look at Xampp
It is one of the best free software for this type of work. One of its main characteristics is that it is cross-platform, so whatever your operating system is, you shouldn’t have major problems installing and using it on different computers.
You can download this program by accessing the official Xampp website, safely, guaranteeing its correct operation. Once downloaded, proceed with its installation and here you will learn how to connect two or more computers to the database.
Having installed Xampp, when you run it, you will find that the interface of this useful program consists of a small window.
In the section that corresponds to MySQL, you will click on the “Config” button and, later, you will select the “my.ini” option. This action will cause a text file to open, which contains valuable information about the allowed settings for remote access to the database.
Locate a section of the configuration identified with the following: # bind-adress = 0.0.0.0, this could also be found with a local IP configuration (something like: 127.0.0.1).
You may also be interested in:
The next thing you will proceed to do is delete the numeral (#) from the command or section previously indicated, which will allow different types of connections to the database. Next, click on “File”, “Save” and close the file.
- Click on the “Stop” button.
- A new window will appear on your screen, in which you will click “Yes” or “OK”.
- Click on “Start.”
Login to phpMyAdmin
Once the previous procedure is finished, it is time to enter phpMyAdmin to, again, make the pertinent configurations and, in this way, allow another computer to access the database.
- Access your browser.
- Type the following: localhost: 80 /
- Click on phpMyAdmin.
- Access the “User Accounts” option.
- You will see the “Root” user, which is a default user.
- Click on “Edit Privileges.”
- Go to “Account Information”.
- In the “Host Name” section, you must put the following:%.%.%.%
- Click on “Continue.”
More specific access
The above would allow any user to have access to the database, which would generate certain risk in the information contained.
If, on the other hand, you want to grant more specific access, for example, to computers connected to the same network, you simply have to know the gateway to which the database or your computer is connected and put it in the hostname. An example of what would be left in that section would be the following: 192.168.0.%
Single connection between computers
Now, if your desire is to establish a connection between another computer with the database, or import and export SQL databases, you simply must have knowledge of the IP address of said computer and provide that information to phpMyAdmin in the section “Host Name”.
How do you know the IP address? Easy, go to that computer, click on the start menu, type “cmd” and press the “Enter” key or click on the “Command Prompt” application.
Execute the command “ipconfig”. Next, locate the section “IPv4 Address” and, in that way, you will identify the IP address corresponding to that computer.
You may also be interested in:
With these simple steps, you will have already established and configured, by means of MySQL the configuration of two or more computers to a database, so that they can manage the information contained in a fast and efficient way. Now that you know how to connect two computers to a MySQL Server database, it only remains to continue the journey.
I'm sorry this content was not useful for you!
Let me improve this content!
Tell me, how can I improve this content?