Home > Documentation > MS Excel to MySQL > Tutorial

Step 2 of 5. Connect to MySQL

If "Move to MySQL server directly" option has been selected on the first window, this page appears next to enter the necessary settings for connection with the server. Excel to MySQL migration tool can connect to MySQL server using local or remote mode. Local mode is used to connect server launched on the same machine where Excel-to-MySQL is running. Remote mode allows to connect server launched on another computer.

By default MS Excel to MySQL converter uses local connection mode. To use remote connection select "Remote" radio button and specify host and port values. Host can be either network name or IP address. Port value is necessary only if it differs from the default 3306. If you need to specify custom port for local connection, select "Remote" and type "localhost" or "127.0.0.1" into "Host" box.

Finally, user name and password are entered. If the target server allows anonymous connection, these fields can be empty.

Have questions? Contact us