This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:software:tim:installation_mysql [2015/12/01 11:40] amanda.zens |
en:software:tim:installation_mysql [2021/07/01 09:52] (current) |
||
---|---|---|---|
Line 6: | Line 6: | ||
\\ | \\ | ||
{{ :software:tim:installationart.jpg?300|}} | {{ :software:tim:installationart.jpg?300|}} | ||
- | After starting installation just follow the instructions of the wizard. Please also accept the licensing agreement after reading its terms. \\ | + | After starting installation, the wizard guides the user through the instructions. After reading the terms of agreement, the licensing agreement must be accepted. \\ |
- | The selection **"Typical"** can be used to make the installation procedure as easy as possible without having to interfere too much. If the installation path of the program has to be changed this can be done by selecting the setting **"Custom"**. \\ | + | The selection **"Typical"** can be used to make the installation procedure as easy as possible without much user input. If the installation path of the program has to be changed this can be done by selecting the setting **"Custom"**. \\ |
\\ | \\ | ||
{{:software:tim:configure_mysql.jpg?300 |}} | {{:software:tim:configure_mysql.jpg?300 |}} | ||
\\ | \\ | ||
- | With regard to the further installation procedure, the instructions of the wizard can be followed until reaching the menu item **"Configure the MySQL Server now"**. At this time, please be sure to set the check mark in the corresponding check box. \\ | + | TO continue the installation procedure, the instructions of the wizard can be followed until the menu option **"Configure the MySQL Server now"**is reached. At this time, the check mark must be placed in the check box. \\ |
\\ | \\ | ||
\\ | \\ | ||
\\ | \\ | ||
- | Only experienced users should uncheck this check box and create an individual my.ini. | + | \\ |
+ | Only experienced users should un-check this check box and create an individual my.ini. | ||
\\ | \\ | ||
Line 21: | Line 22: | ||
---- | ---- | ||
- | ==== Configurating MySQL ==== | + | ==== Configuring MySQL ==== |
{{ :software:tim:konfiguration_auswahl.jpg?300|}} | {{ :software:tim:konfiguration_auswahl.jpg?300|}} | ||
- | Please choose the option **"Detailed Configuration"** when selecting the mode for configuration. This enables you to optimally adapt the database to your own system. \\ | + | The option **"Detailed Configuration"** should be chosen when selecting the mode for configuration. This enables the database to be optimally adapted to the user's system. \\ |
- | {{en:software:tim:memory_usage.jpg?300 |}} | + | {{:software:tim:memory_usage.jpg?300 |}} |
The selection of the server instance can be made on the basis of current hardware settings: | The selection of the server instance can be made on the basis of current hardware settings: | ||
^ Name ^ Type of use ^ | ^ Name ^ Type of use ^ | ||
^ Developer machine | Local installation for testing TIM | | ^ Developer machine | Local installation for testing TIM | | ||
^ Server machine | Productive system or system for testing on a server | | ^ Server machine | Productive system or system for testing on a server | | ||
- | ^ Dedicated MySQL server machine | This is a server only dedicated to databases | | + | ^ Dedicated MySQL server machine | This is a server solely dedicated to databases | |
\\ | \\ | ||
Line 35: | Line 36: | ||
{{:software:tim:database_usage.jpg?300 |}} | {{:software:tim:database_usage.jpg?300 |}} | ||
- | If the database is not required anymore for an application the following point \\ | + | If the database is no longer required for an application the option \\ |
**Transactional Database Only** \\ | **Transactional Database Only** \\ | ||
- | is selectable and the process can be continued by chosing **"Next"**. In the following section the path and the drive for the data used by MySQL can be changed. | + | is selectable and the process can be continued by choosing **"Next"**. In the following section the path and the drive for the data used by MySQL can be changed. |
Please make sure that the selected drive has enough free space to store data when selecting a particular drive! | Please make sure that the selected drive has enough free space to store data when selecting a particular drive! | ||
- | {{ en:software:tim:concurrent_connections.jpg?300|}} | + | {{ :software:tim:concurrent_connections.jpg?300|}} |
- | Default settings for the database connections can be used without making changes because TIM establishes 10 database connections. The rest of these connections are either availalbe as buffers in case of a significantly increased usage or they might be available for other applications like for example Signavio. The next two items | + | Default settings for the database connections can be used without making changes because TIM establishes 10 database connections. The rest of these connections are either available as buffers in case of a significantly increased usage or they might be available for other applications, for example Signavio. The next two items |
*Enable TCP/IP Networking (Port 3306) | *Enable TCP/IP Networking (Port 3306) | ||
*Enable Strict Mode | *Enable Strict Mode | ||
Line 47: | Line 48: | ||
\\ | \\ | ||
{{:software:tim:cahracter_set.jpg?300 |}} | {{:software:tim:cahracter_set.jpg?300 |}} | ||
- | For selecting the mode of encoding please make sure to select UTF8 (please refer to the screenshot!) or otherwise the rendering of "Umlauts" and special characters in TIM might become problematic. | + | When selecting the mode of encoding, UTF8 must be selected (refer to the screenshot!) or else the rendering of "Umlauts" and special characters in TIM may become problematic. |
- | Bei TIM müssen alle Zeichenkodierungen unter UTF-8 laufen! | + | All variable parity encodation in TIM must be made using UTF-8! |
{{ :software:tim:install_service.jpg?300|}} | {{ :software:tim:install_service.jpg?300|}} | ||
- | Im nächsten Schritt kann ausgewählt werden, ob die MySQL Datenbank als Dienst ("Install as Windows Service") installiert werden soll und ob die Datenbank automatisch beim hochfahren des Servers gestartet ("Launch the MySQL Server automatically") werden soll. | + | In the next step the user selects if the MySQL database should be installed as a service ("Install as Windows Service") and if the database should automatically start when the server is booted up ("Launch the MySQL Server automatically"). |
+ | \\ | ||
\\ | \\ | ||
\\ | \\ | ||
- | Beide Auswahlen sollten getroffen werden, wenn es sich um einen Server handelt. Wird die Installation | + | If a server is being used, both options should be chosen. |
- | auf dem Arbeitsrechner vorgenommen, kann die Option "Launch the MySQL Server automatically" | + | If installation is run on a work computer, the option |
- | entfernt werden. | + | "Launch the MySQL Server automatically" can be removed. |
| | ||
- | Bei Unklarheiten, sollten beide Optionen gesetzt werden! | + | Under ambiguous circumstances, both options should be selected! |
\\ | \\ | ||
{{ :software:tim:root_password.jpg?300|}} | {{ :software:tim:root_password.jpg?300|}} | ||
- | Im nächsten Schritt wird das Passwort für den **root** Zugang gesetzt. Root ist ein Benutzer unter Unix, der dem Administrator unter Windows entspricht und die höchste Rechtebene repräsentiert. | + | in the next step, the password for the **root** access will be set. Root is a user in Unix, which corresponds to the Windows administrator and represents the highest access level. |
- | >> Aus Sicherheitsgründen sollte ein Passwort gesetzt werden und der Remotezugang | + | >> For security reasons, a password should be set and the access from remote machines |
- | >> nicht aktiviert werden! Ausserdem sollte kein Annonymer Zugang aktiviert werden! | + | >> should not be activated! Additionally, the creation of an anonymous account should not be activated! |
- | Das Passwort des Rootzugangs sollte dokumentiert werden, da es für die weitere Installation noch | + | The password for root access should be documented, as it will be necessary for further installation processes. |
- | benötigt wird. | + | |
\\ | \\ | ||
- | Danach kann dem Wizard bis zum Ende gefolgt werden und es werden keine weiteren Benutzereingaben mehr benötigt. | + | After this, the wizard can be followed until the installation is complete. No further user inputs will be necessary. |
---- | ---- | ||
- | ==== Anlegen einer Datenbank ==== | + | ==== Cretion of a database ==== |
{{ :software:tim:create_database.jpg?500|}} | {{ :software:tim:create_database.jpg?500|}} | ||
- | Um eine Datenbank anzulegen, muss man in die Commandline von MySQL gehen. Dazu kann man unter \\ | + | In order to create a database, the user must employ the commandline from MySQL. Using \\ |
- | Start -> (Alle) Programme -> MySQL -> MySQL Server 5.1 | + | Start -> (All) Programs -> MySQL -> MySQL Server 5.1 |
- | den **"MySQL Command Line Client"** starten. Nach dem ausführen wird man aufgefordert, das bei der Installation hinterlegte Passwort, einzugeben. Ist man authentifiziert, kann man mit dem Befehl \\ | + | the **"MySQL Command Line Client"** can be started. After the execution, the user will be prompted to enter the password set during the installation process. If the user is authorized, the command \\ |
\\ | \\ | ||
create database tim; | create database tim; | ||
- | eine Datenbank mit dem Namen **"tim"** erstellen. | + | can be used to create a database with the name **tim**. |