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.