Setting up MySQL in Windows 11

In this article, we will be showing you how to set up a MySQL connection to Ozeki SMS Gateway in Windows 11. You will see information about the installation of a MySQL server, how to build the database schema for compatibility with Ozeki SMS Gateway, how to set up a Database connection with Ozeki SMS Gateway and how you can send messages with it. It should only take about 7 minutes to watch the provided videos and about 20 minutes to do them on your own computer depending on your network speed and computer performance.

Install MySQL database (video tutorial)

In the following video guide, you will see how to install MySQL on Windows 11. The video starts from the official MySQL website and at the end, you will have a MySQL shell access.

Create database schema (video tutorial)

The next video guide will help you set up your database to be compatible with Ozeki SMS Services. First, you will have to connect to the MySQL server root user at localhost:3306 (Your own MySQL server) and create a database called ozekidb, then create a new user that you grant all privileges to with the name ozekiuser and a password, we used ozekipass in this video.
We will create two tables for incoming and outgoing messages as well and by the end, you will have a fully setup Database Schema.

Connect SMS Gateway to MySQL database (video tutorial)

In this guide, we will use the Ozeki SMS Gateway to add a new SQL messaging connection with a MySQL instance. We will have to enter the details of the MySQL server we set up in the previous steps and in the end, we will have a working connection to our MySQL server.

Send test message (video tutorial)

In this short video guide, we show you how to send SMS messages from the MySQL connection we set up previously.