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:
- MYSQL modify the password in several ways(Views: 1925)
- Is Your Website Ready For Black Friday?(Views: 2617)
- MySQL int (M) instruction(Views: 1910)
- What Operating System should I install on my server?(Views: 2277)
- What is a MySQL database?(Views: 2306)