![]() ![]() ![]() |
Ispirer SQLWays Database Migration Software
Configuring Connection to MySQL using MyODBC
MySQL ODBC driver prompts for more information about connection parameters in the MySQL ODBC Driver - DSN Configuration dialog box upon data source creation
- DSN Information:
- MySQL Connection Parameters:
- Host/Server Name (or IP) - the hostname of the MySQL server.
- Database Name - the name of the default database.
- User - the user name used to connect to MySQL.
- Password - the password for the server user combination.
- Port (if not 3306) - the TCP/IP port to use if server is not localhost. If the port number is not given, the default port (3306) is used
- SQL command on connect - a command that will be executed when connecting to MySQL.
![]() ![]() ![]() |