Authentication ensures that only the authorized users are allowed to connect to a MySQL server.

The MySQL driver supports the User ID/Password authentication. It authenticates the user to the database using a user name and password.

To configure the driver to use user ID/password authentication:

  • Set the Host Name (HostName) option to specify the name or the IP address of the server to which you want to connect.
  • Set the Database Name (Database) option to specify the name of the database to which you want to connect.
  • Set the User Name (LogonID) option to specify your user name.
  • Set the Password option to specify your password.

The following examples show the connection information required to establish a session using user ID/password authentication.

Connection string

DRIVER=DataDirect 8.0 MySQL Wire Protocol;HostName=myserver;PortNumber=3306;
Database=Payroll;LogonID=John;Password=secret

odbc.ini

[MySQL Wire Protocol]
Driver=ODBCHOME/lib/xxmysql28.yy
...
HostName=myserver
...
PortNumber=3306
...
Database=Payroll
...
LogonID=John
...
Password=secret
...