Creating a MySQL database instance

If you do not have a database server: Download MySQL Database server and install it.
You can find all the required information on MySQL website.

If you do have a database server but do not have a database for n-gen CMS:
Logon to the DB server with Admin privileges (root) and write the below SQL-statements:

 

CREATE DATABASE [myDbName];
USE [myDbName];

CREATE USER '[myDbUserName]'@'localhost' IDENTIFIED BY '[myDbUserPassword]';
GRANT USAGE ON [myDbName].* to '[myDbUserName]'@'localhost' IDENTIFIED BY '[myDbUserPassword]';
GRANT ALL ON '[myDbName]'.* to '[myDbUserName]'@'localhost';

Substitute the values within [] with your own values.

Note: The database server does not have to reside on the same physical or virtual server as your web server (MS IIS). It does not even have to run on the same Windows OS as your production server. Most of the n-gen.net development has been done on MySQL running on various Linux distributions or Maria DB running on Synology DSM. You can even run your database server on a headless 30 € Raspberry Pi as long as your website is not too busy. The only thing is that you have to have a stable always-on connection to make your web site available at all times.