MySQL workbench is a visual database design tool that integrates SQL development, management, and database design, creation, and maintenance into a simple development environment. It is derived from fabforce.net, he is the successor of dbdesigner 4 and changed the MySQL GUI tool binding. The current version is 5.2 and the first version is 5.0. It should be emphasized that MySQL workbench is developed as the successor of dbdesinger 4.
The following describes how to install and test a remote MySQL database:
1. Install. netframework3.5 when installing MySQL workbench. After installation, you can install MySQL workbench.
2. Click Create connection and give a connection name)
3. Use standard (TCP/IP) Connection Method)
4. Host Name: Remote database address (hostname)
5. Port: port used to access the remote database)
6. User name: username of the remote database)
7. Password: Click (store in value) and enter the password corresponding to the user name)
8. test connection)
9. If the test succeeds, the test succeeds. If the test fails, the test fails.