New MySQL Connection
The tool uses TCP/IP protocol for database connection, similar to the connection method used by Navicat and other database tools. If you have other database tools installed, you can refer to their database connection information for filling in.
Server: Enter the server address where the MySQL database is installed. For a local database connection, you can enter localhost, 127.0.0.1, or your computer's IP address. For a remote database connection, enter the server's IP address.
Port: Enter the MySQL port number. The default port number is 3306. If you used a custom port number during installation, please enter that instead.
Username: Enter the username that is allowed to connect to the MySQL database and has the necessary permissions to use the tool (e.g., for CRUD operations).
Password: Enter the corresponding password for the username provided. If the connection fails, double-check that the password is correct.
Database: Enter the name of the database where you want to import data.
Step 1: Fill in the necessary connection information and click "Test Connection".
Step 2: After a successful connection prompt, provide a connection name, select the database you want to import, and click "OK".
Common Issues:
-
ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
Password mismatch: Double-check the password and re-enter it.
-
Host is not allowed to connect to this MySQL server
When connecting to a remote database, ensure that the remote database allows remote connections. Refer to Host is not allowed to connect to this MySQL server for details.