Home > Documentation > SQL Server to MySQL > Tutorial

Step 3 of 7. Connect to MySQL

If "Move to MySQL server directly" option has been selected on the first wizard page, the converter displays this page to get connection settings for MySQL server. SQL Server to MySQL converter can connect to MySQL server using local or remote mode. Local mode is used to connect MySQL launched on the same machine where the program is running. Remote mode allows to connect MySQL launched on another computer.

By default SQL Server 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.

The sufficient privileges are required to create new database on MySQL server. Otherwise it is only possible to import MS SQL database contents into an existing MySQL database. See Virtual Server User Notes section for related information.

NOTE: MySQL 4.1.0 uses the authentication protocol based on a password hashing algorithm that is incompatible with that used by SQL Server to MySQL conversion tool. See this article to learn how to resolve the issue.

Have questions? Contact us