Adding a MyODBC data source

Open Database Connectivity (ODBC) is a standard database access method that allows you to access and modify data from any application, regardless of which database management system is handling the data.

To add a MyODBC data source:

1. On the left navigation panel, go to the section Services > ODBC Data Source, then click Add MyODBC Data Source. The ODBC Data Source Add page is displayed.

2. Specify the information on this page as explained in the table below.

3. Click Add. The MyODBC data source is added and is displayed on the List OBDC Data Source page.

MyODBC data source options
Option | Description
Data Source Name (DSN) | The name used by your script to connect to the source database.
ODBC Driver Name | MySQL ODBC (MyODBC) Driver is the default driver.
DSN Description | The description of the data source.
Host/Server Name (or IP) | The host name or IP Address of the server on which the MySQL database is located. Its default value is localhost, that is, the server on which the site is currently hosted.
Database Name | The name of the MySQL database that you want to use as the default database.
User | The login name required to access the database.
Password | The password required to access the database. Note: This option is displayed only while adding a new MyODBC data source or changing the configuration of an existing one.
Port | The port number used to access the server on which the MySQL database is located. By default, MySQL uses port 3306 to service requests. Note: This field accepts port numbers only from 0 to 99999.