Navicat software sets the applicable scope for connecting to the mysql database and the scope of demonstration tools: All mysql series (including mysql in Linux and Windows)
Demo tool: Navicat 8.0 MySQL
Demo system: Windows2003 system navicat connection to mysql database setting method/stepStep 2: Download and install the navicat software. This is successfully installed on your computer. After the installation is successful, open "navicat for MySQL" under the Navicat menu in the Start Menu group and click open.
Step 2: Click "Connect" in the upper left corner of navicat software. In the connection window, enter the connection name as follows.
Connection name: both Chinese and English.
Host Name/IP Address: Enter the IP address of the mysql database. Enter "localhost" or "127.0.0.1" on the local machine ".
Port: enter the port number of the mysql database. The default value is "3306 ".
Username: mysql username.
Password: mysql logon password.
Step 2: After the mysql-related connection information is confirmed, click "connection test" and click "OK". If "connection successful" is displayed, the connection is normal. If the connection is not "successful", check whether the related information is correct.
Step 2: After confirmation is made in the connection settings window, a name in connection settings is displayed on the left side of the page, as shown in. Double-click or right-click the name and choose "open connection" to access all mysql Data operations.