Remote connection MySQL database
Process as follows:
1. The MySQL installation folder under the bin directory is added to the system path variable.
2. Registered mysqld database open command to the Windows system service: When typing mysqld mysqld --install or need to use every direct (Optional --console parameter).
3. Using the root user login (if necessary change the root password to access local l) - see previous articles.
4. Giving remote (local area network) root user login privileges and passwords:. Grant all previlige on * * to 'root'@'192.168.153.%' identified by 'pwd'. At this point the server configuration is complete.
5. The remote client (I am a machine), and enter the command line window, type: mysql -u root -p -h 192.168.153.117 Enter the password pwd appear 'mysql>' description after the re-connected after the carriage return You can access the MySQL database on the machine. Note: Because the two machines have been installed MySQL database, so the command tool complete; wonder if there is not a pure broken MySQL client command management tools.
Suggested Reading:
- Points to remember Choosing between SSD and SAS Drives(Views: 2149)
- High Performance & Availability(Views: 2987)
- How to redirect 301 by rewriting URL(Views: 3022)
- LAMP configuration example(Views: 5004)
- The differences among Fedora, RedHat, CentOS and other Linux based OS (Views: 3473)


United States
Canada
Mexico
Panama
Belize
Greenland
Grenada
Puerto Rico
Hong Kong SAR China
Singapore
South Korea
Indonesia
Japan
Malaysia
Pakistan
Turkey
France
Germany
United Kingdom
Netherlands
Czech Republic
Italy
Luxembourg
Switzerland
Brazil
Argentina
Bolivia
Chile
Colombia
Ecuador
French Guiana
Paraguay
Australia
New Zealand
Cook Islands
Fiji
Pitcairn Islands
Solomon Islands
Tonga
Tuvalu