How to setup MySQL database connection

In this chapter you can learn how to connect to a given database. This step shows you how you can import contacts from your own database into the Ozeki Bulk Messenger software.

Step 1 - Create new database connection

The first step of establishing a new connection is to click the Create new Connection button located on the upper side of the screen. You can see where to click on Figure 1.

create new connection
Figure 1 - Create new connection

Step 2 - Type of database

Now you need to choose which type of connection method you wish to use. In this case you need to connect to an already existing application, so please choose the application option. You can see which button you need to choose on Figure 2.

connection method
Figure 2 - Connection method

Here you get to choose which kind of application you wish to connect to. In this case, you want to connect to MySQL which is a database management software. To establish connection with it, choose the Database option, as you can see on Figure 3.

application type
Figure 3 - Application type

In this step, you need to choose what will you use the connection for. If you wish to use it for messaging, choose the SQL messaging option here. Click it and it will take you to the next step. You can see where to click on Figure 4.

sql messaging
Figure 4 - SQL messaging

Now you need to specify what application you will use the connection with. In this case, you will use it with the MySQL Database Management software. Click the Install button to proceed to the next step. On Figure 5, you can see where to click.

sql messaging
Figure 5 - SQL messaging

Step 3 - Database connection details

There are two options for this: you can give the data below the General menu, or you can give the connection string below the Advanced menu. In case you give the connection string, it overwrites the data given below the General menu.

  • Server: The IP address of the database server (e.g. 192.168.112.121).
  • Database: The name of the database that stores the contacts (e.g. ozeki).
  • User: The username with which you can connect to the database (e.g. ozeki).
  • Password: The password that belongs to the previously given username (e.g. qwe123).

sql messaging
Figure 6 - SQL messaging

In this example we give the connection string under the Advanced menu
You can use the following connection string:
Server=192.168.112.121; Database=ozeki; Uid=ozeki; Pwd=oqwe123;

If the connection is successful, a green tick will appear under State.
Click to the Open button to go to the details page of this connection

click to open
Figure 7 - Click to Open

Here in the event log, you could easily supervise all the actions on your connection, whether it is incoming or outgoing data packages. It will also show that you have connected successfully to the MySQL Database, as you can see on Figure 8.

event log
Figure 8 - Event log

Step 4 - Testing the database connection

If you click to the Test button, you can give the database table in which you store your contact lists.
Click to the Execute button to list the phone numbers that are stored in the given database's table.

test the database
Figure 9 - Test the database

More information