How to Connect to a hosted MySQL Server
Setup a linked List and connect to a MySQL Database
MailList Controller supports 2 different list modes: standard list mode and
linked list mode. The linked list mode can be used if the program should be
used to send out messages only, e.g. when using a hosted MySQL database.
Many users already have a newsletter database using php-subscribe/remove web forms, which fill the information directly to a hosted MySQL database table. The programs email-form-based subscribe/remove functions are not required (and not available) in the linked list mode
MailList Controller opens a linked (external) database in read-only mode!
Setting up a linked list is easy:
- Download and install the required MySQL ODBC Connector from the
- Run MailList Controller as Adminsitrator(!): right-click
on the MailList Controller desktop icon and select "Run as Administrator".
(required on Windows 8, 7 and Vista)
- Click on "New List".
- Fill in the list details and mail account settings as described in the
user manual #3.
- Select List Type: Linked List
- Click on "ODBC" on the database selection dialog.
- Create a new "Computer Data Source". Select "SYSTEM
DSN" and the MySQL ODBC driver.
Its important to use a SYSTEM DSN connection, otherwise the mail service (which runs as "local system" by default) will not be able to access the MySQL database on the hosted server. Fill in the required details and test the connection. If everything is working fine, then save it and close the "Data Source (ODBC)" dialog.
The "Data Source Name" is the name, which identifies the connection. You can type in any name here, e.g. "MyConnection".
The TCP/IP Server is the server name of your hosted MySQL (web server). Please take a look at your hosted control panel or ask your web administrator if you don't know what server name you should enter here.
- Continue as described in the user manual #3.7.
MailList Controller version 9 is written in UNICODE!
Some older versions of the MySQL ODBC Connector won't support unicode, which could result in missing characters,
e.g. a missing char at the end.
- Download and install the MySQL ODBC Connector version 5.1 (or newer)
- Create a new list using the updated MySQL ODBC Connector
- Open the list and verify the fields
- If it still won't show the chars, then:
Change the charset in the "Details>>>" of the MySQL ODBC Connector! (use unicode ... or utf-8)