On this tutorial, I will show you how to create an ODBC Connection to MySQL Server. I am using Windows 10 and my MySQL server is installed on Linux Server. Its pretty easy to create MySQL ODBC Connection from Windows 10.
First, make sure you have the following in hands
- MySQL Server IP address or hostname
- MySQL Server user and password
- Administrator password for Windows (in case you are behind a domain)
Steps to create MySQL ODBC Connection
First, you will need to install MySQL ODBC Connector (ODBC Driver). You can download it from here. Next, open Control Panel and go to Administrative Tools. Click ODBC Data Sources (32 bit or 64 bit) depends on your system.
On the User DSN tab, click Add and then select MySQL ODBC Driver. Make sure MySQL ODBC Driver is listed on the data source driver list. If not listed, check your MySQL ODBC Connector installation.
Press Finish and you will be asked to enter the MySQL ODBC configuration.
If all correct, you should now have a working MySQL ODBC Connection. You can use this connection on other software such as Microsoft Excel, Access, Mapinfo and many others.
Thanks for coming by.