navicat Software Settings connect to MySQL databasescope of application and demonstration use toolsscope of application: MySQL all series (including MySQL under Linux and Windows system)
Demo using tool: Navicat 8.0 MySQL
Demo system: Windows2003 systemnavicat Connect MySQL Database Setup method/step
1th : Download and install Navicat software, successfully installed on your PC, after successful installation, open the Navicat menu in the Start menu group Navicat For MySQL "and click Open.
2nd Step : Click Connect in the upper-left corner of the Navicat software, and the connection name is entered in the Connection window as follows.
Connection Name: Both English and Chinese can be entered freely.
Hostname/IP address: Enter the MySQL database IP address, then enter "localhost " or " 127.0.0.1 ".
Port: Enter the port number of the MySQL database, the default is "3306 ".
User name: MySQL login name.
Password: MySQL login password.
3rd Step : After the connection information for MySQL is determined, click the "Connect Test" button, and then click OK if you are prompted to "connect successfully". If the connection is not successful, check that the setting information is correct.
4th : After the Connection Settings window is determined, a name just in the connection settings appears on the left side, double click or right-click on this name to "open connection" to access all operations on MySQL data.
