===== Windows - setup MySQL =====
Setup requires that you have already downloaded the pre-configure or the **official** MySQL DBMS. If MySQL server is already running and listening on the same port as you want to run niota then you have to change your niota MySQL port or stop the other MySQL server.

Execute tasks listed down below step by step in the given order

  * unzip downloaded zip-file
  * move extracted folder to target location
  * rename the folder to your needs
 
**Recommendation:**
----
Remove the detailed version info. 

e.g. rename “niota-meta-80_v2.1.21308” to “niota-meta_v2”
----
 
  * navigate to the mysql-<version> - folder and check the configured port in configuration file **''my.ini''**

Default port 3306 is configured. If you have to change this, then set your desired port number here. If you change the port for N-MDDB you must edit also your **''connections.php''** file in N-PAPP and set this port number here as well.

If there is no **''my.ini''** at all, you can create one with a simple text editor.

  * set your **''data''** directory.

In case nothing is set, data directory will be placed directly under the **''<MySQL-root folder>/data''**. If you want to change this, add the **''datadir=<path>''** setting to you **''my.ini''** file.

  * open windows command prompt in admin mode
  * navigate to your mysql-folder into the \bin\ - subfolder
  * initialize your data directory by ''mysqld --console --initialize''
 
  * run command: mysqld --install <servicename>
 
<code - my.ini_sample>

   [mysqld]
   datadir="C:/MySQLFarm/niota-meta-v3/data/"
   log_bin_trust_function_creators=1
   port=3367
   character-set-server = utf8mb4
			
   log_bin_trust_function_creators = 1
		
   [client]
   port=3367
</code>

<code initdata.sql>
...\bin> mysqld --initialize --console
</code>

After this you my find a lot of files in our data folder and a generated password for your local root user.

<code>
something like this.....

2025-05-04T13:03:37.806731Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-05-04T13:03:38.163275Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-05-04T13:03:40.008905Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: T5:und.yAQXe

</code>

This root password is a one time password and is not valid to sign in. It can only be used to set the password to a new password.
Use command "mysql_secure_installation" to set the password. Tool "mysql_secure_installation" uses ''[client]'' parameter - section from ''my.ini'' configuration file

**Take care to run mysql server either as service or in console mode when you start ''mysql_secure_installation''. This tool needs an up and running MySQL Server**

<code>
...\bin\mysql_secure_installation
</code>

  * change your password to a secure password
  * remove all anonymous users
  * remove all test databases and access to it

Now you should be able to sign in to then new MySQL DBMS via a client tool. To check this out start the **''mysqld''** in console mode and try to connect via a client tool like MySQL workbench or MariaDB or similar.

**Recommendation:** Start N-MDDB in a console mode before you install it as a service. To achieve this run 
<code>
mysqld --console
</code>

press CTRL+C to quit MySQL console mode




If you could successfully log in to the MySQL server with root user and your newly set password the configuration is ready to be installed as a service.

==== install MySQL as service ====

<code>
...\bin> mysqld --install MySQL_niota_610
</code>

**Recommendation:** Add the primary N-PAPP version number or/and the primary N-MDDB version to the service name.
 So possible servicenames would be

  * ''MySQL_niota_402'' --- niota php-application 4.0.x 
  * ''MySQL_niota_411'' --- niota php-application 4.1.x 
  * ''MySQL_niota_610'' --- niota php-application 6.1.x 

**In case install as a service is denied, it is most likely that you have not started command window in administration mode!!!**

<code>
Install/Remove of the Service Denied!
</code>

This naming conventions can be useful if you want to upgrade N-PAPP to a higher release and run the active release and the next release in parallel.

  * Set description of service with sc (service control manager) command 
  * run command: sc description <servicename> "description"

<code>
...\bin>sc description MySQL_niota_610 "niota 6.1.x metadata"
</code>

  * go to windows services and start the service
  * verify that newly installed service switches to "Running" status and keeps running

<code>
...\bin>sc start MySQL_niota_v610
</code>

{{:niota-docs:pasted:20250508-145111.png}}