This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_install_meta_windows [2025/05/09 11:50] admin |
niota-docs:niota_install_meta_windows [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== Windows - setup MySQL ===== | ===== 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. | + | 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 | Execute tasks listed down below step by step in the given order | ||
| Line 14: | Line 14: | ||
| e.g. rename “niota-meta-80_v2.1.21308” to “niota-meta_v2” | 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''** | * navigate to the mysql-<version> - folder and check the configured port in configuration file **''my.ini''** | ||
| Line 23: | Line 21: | ||
| If there is no **''my.ini''** at all, you can create one with a simple text editor. | If there is no **''my.ini''** at all, you can create one with a simple text editor. | ||
| - | * set your ''data'' directory. | + | * 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. | + | 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 | * open windows command prompt in admin mode | ||
| Line 75: | Line 73: | ||
| * remove all test databases and access to it | * 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. | + | 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 | **Recommendation:** Start N-MDDB in a console mode before you install it as a service. To achieve this run | ||
| Line 89: | Line 87: | ||
| 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. | 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. | ||
| - | === Windows - install MySQL as service === | + | ==== install MySQL as service ==== |
| <code> | <code> | ||