This string includes the options used to connect with basic user ID and password authentication.
Note: The strings demonstrated in this section use the DSN-less format. For additional formats, see "Using a connection string". 
DRIVER=DataDirect 8.0 MySQL Wire Protocol;HostName=host_name;PortNumber=3306;
Database=database_name;LogonID=user_name;Password=password;
[attribute=value[;...]];

where:

host_name

specifies the name or the IP address of the server to which you want to connect.

database_name

specifies the name of the database to which you want to connect.

user_name

specifies your username.

password

specifies your password.

attribute=value

specifies connection option settings. Multiple connection option attributes are separated by a semi-colon.

The following example connection string includes the options for connecting with the user ID/password authentication.

DRIVER=DataDirect 8.0 MySQL Wire Protocol;HostName=MyServer;PortNumber=3306;
Database=PAYROLL;LogonID=jsmith;Password=secret;