WARNING: THIS ACTION SHOULD ONLY BE TAKEN BY QUALIFIED PERSONAL ONLY!
In some occasions it would be okay to start with an empty MariaDB. E.g. if you would like to do some more testing with a 14 days trail version.
In this post you can see which steps have to be performed to do so.
To delete the database you have to stop the custo diagnostic server (Apache Tomcat Server) in services on your computer or start the application and press <Stop>
Open the file init.sql which is default located in the directory C:\Program Files\custo diagnostic server\mariadb\
Open a power shell window on the following location C:\Program Files\custo diagnostic server\mariadb\bin\ ( You can do so by holding the Shift key and press the right mouse button, in the drop-down menu you'll find "open a powershell windows here")
Type: cmd
The following message willl be shown:
Microsoft Windows [Version 10.0.17763.1697]
© 2018 Microsoft Corporation. All rights reserved.
Enter the following command: mysql -uroot -p
You will be asked to enter a password. Copy the password from the init.sql file. The password is behind the word IDENTIFIED BY, see picture above.
When the password is entered correct the following reply will be shown:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 810
Server version: 10.4.12-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
To show the databases type: show databases;
The active databases will be shown
+------------------------+
| Database |
+------------------------+
| diagdb |
| information_schema |
| mysql |
| performance_schema |
| test |
+------------------------+
5 rows in set (0.001 sec)
MariaDB [(none)]>
Enter the following command to delete the diagdb: drop database diagdb;
If the command has been executes successful you will see the following message:
Query OK, 30 rows affected (0,421 sec)
To check if the database is deleted type: show databases;
The active databases will be shown
+------------------------+
| Database |
+------------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+------------------------+
5 rows in set (0.001 sec)
MariaDB [(none)]>
To create a new database, copy the command line out of the init.sql file(see above picture) and past it on the prompt:
CREATE DATABASE IF NOT EXISTS diagdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
When the command has been executes successful you will see the following message:
Query OK, 0 rows affected (0,001 sec)
To check if the database is there type: show databases;
The active databases will be shown
+------------------------+
| Database |
+------------------------+
| diagdb |
| information_schema |
| mysql |
| performance_schema |
| test |
+------------------------+
5 rows in set (0.001 sec)
MariaDB [(none)]>
Type: exit
And close the PowerShell window.
Restart the custo diagnostic server (Apache Tomcat Server)
You can restart custo diagnostic.
The password is set back to "custo" again
You can also show this VIDEO for a detailed description.