MySQL - Revision history

Harald Friedrich: /* Set up / customize MySQL / MariaDB server and insert TARGET database */

2025-01-22T14:54:13Z

Set up / customize MySQL / MariaDB server and insert TARGET database

← Older revision		Revision as of 16:54, 22 January 2025
Line 13:		Line 13:
	* Create a new empty database “target3001db” (with collation utf8mb3_general_ci) with phpMyAdmin, for example, or in the SQL console:		* Create a new empty database “target3001db” (with collation utf8mb3_general_ci) with phpMyAdmin, for example, or in the SQL console:
	CREATE DATABASE target3001db CHARACTER SET utf8 COLLATE utf8_general_ci;		CREATE DATABASE target3001db CHARACTER SET utf8 COLLATE utf8_general_ci;
	* Download the following SQL file and import it into the new empty database: '''[https://office.ibfriedrich.com/target3001db.~~sql~~ target3001db.~~sql~~]''' (~~100~~ MB). All tables, all functions and all triggers are created automatically.		* Download the following SQL file in a ZIP and import it into the new empty database: '''[https://office.ibfriedrich.com/target3001db.zip target3001db.zip]''' (60 MB). All tables, all functions and all triggers are created automatically.
	* Enter users and rights for the new database. User names and passwords may have a maximum of 16 characters each. The following rights are required: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE and TRIGGER.		* Enter users and rights for the new database. User names and passwords may have a maximum of 16 characters each. The following rights are required: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE and TRIGGER.
	* In TARGET in the component browser in the “Connected to...” menu enter the settings for MySQL. These are also used for MariaDB:		* In TARGET in the component browser in the “Connected to...” menu enter the settings for MySQL. These are also used for MariaDB:

Harald Friedrich: /* Set up / customize MySQL / MariaDB server and insert TARGET database */

2025-01-22T14:47:22Z

Set up / customize MySQL / MariaDB server and insert TARGET database

← Older revision		Revision as of 16:47, 22 January 2025
Line 13:		Line 13:
	* Create a new empty database “target3001db” (with collation utf8mb3_general_ci) with phpMyAdmin, for example, or in the SQL console:		* Create a new empty database “target3001db” (with collation utf8mb3_general_ci) with phpMyAdmin, for example, or in the SQL console:
	CREATE DATABASE target3001db CHARACTER SET utf8 COLLATE utf8_general_ci;		CREATE DATABASE target3001db CHARACTER SET utf8 COLLATE utf8_general_ci;
	* Download the following SQL file and import it into the new empty database: [https://office.ibfriedrich.com/target3001db.sql target3001db.sql] All tables, all functions and all triggers are created automatically.		* Download the following SQL file and import it into the new empty database: '''[https://office.ibfriedrich.com/target3001db.sql target3001db.sql]''' (100 MB). All tables, all functions and all triggers are created automatically.
	* Enter users and rights for the new database. User names and passwords may have a maximum of 16 characters each. The following rights are required: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE and TRIGGER.		* Enter users and rights for the new database. User names and passwords may have a maximum of 16 characters each. The following rights are required: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE and TRIGGER.
	* In TARGET in the component browser in the “Connected to...” menu enter the settings for MySQL. These are also used for MariaDB:		* In TARGET in the component browser in the “Connected to...” menu enter the settings for MySQL. These are also used for MariaDB:
Line 37:		Line 37:
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	You can also make this setting with phpMyAdmin or with the Workbench.<br><br>		You can also make this setting with phpMyAdmin or with the Workbench.<br><br>

	== Does MS-SQL also work instead of MySQL or MariaDB? ==		== Does MS-SQL also work instead of MySQL or MariaDB? ==

Harald Friedrich: /* Install MySQL / MariaDB */

2025-01-22T14:42:39Z

Install MySQL / MariaDB

← Older revision		Revision as of 16:42, 22 January 2025
Line 7:		Line 7:
	== Install MySQL / MariaDB ==		== Install MySQL / MariaDB ==

	You can download the installers here: [https://dev.mysql.com/downloads/mysql MySQL] and [https://mariadb.org/download MariaDB]<br><br>You can install the database on a PC or on a server.		You can download the installers here: [https://dev.mysql.com/downloads/mysql MySQL] and [https://mariadb.org/download MariaDB]<br><br>You can install the database on a PC or on a server.<br><br>

	== Set up / customize MySQL / MariaDB server and insert TARGET database ==		== Set up / customize MySQL / MariaDB server and insert TARGET database ==

Harald Friedrich: /* MySQL / MariaDB: The fast database for multiple workstations */

2025-01-21T11:42:06Z

MySQL / MariaDB: The fast database for multiple workstations

← Older revision		Revision as of 13:42, 21 January 2025
Line 3:		Line 3:
	== MySQL / MariaDB: The fast database for multiple workstations ==		== MySQL / MariaDB: The fast database for multiple workstations ==

	The SQLite database pre-installed with TARGET becomes slow with normal network transfer rates in multi-user operation. If you want to access a shared TARGET 3001! component database in a network with several workstations, you need the components in a ‘’‘MySQL database’‘’ or in a ‘’‘MariaDB’‘’. In our experience, however, the SQLite database has the edge in single-user operation.<br><br>		The SQLite component database pre-installed with TARGET becomes slow with normal network transfer rates in multi-user operation. If you want to access a shared TARGET 3001! component database in a network with several workstations, you need the components in a ‘’‘MySQL database’‘’ or in a ‘’‘MariaDB’‘’. In our experience, however, the SQLite database has the edge in single-user operation.<br><br>

	== Install MySQL / MariaDB ==		== Install MySQL / MariaDB ==

Harald Friedrich at 10:20, 21 January 2025

2025-01-21T10:20:23Z

Show changes

Harald Friedrich: /* Particularities for Windows servers */

2025-01-21T10:18:32Z

Particularities for Windows servers

← Older revision		Revision as of 12:18, 21 January 2025
Line 36:		Line 36:
	mysql> GRANT ALL ON . to root@'%' IDENTIFIED BY '<your-mysql-root-password>';		mysql> GRANT ALL ON . to root@'%' IDENTIFIED BY '<your-mysql-root-password>';
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	You can also make this setting with phpMyAdmin or with the Workbench.		You can also make this setting with phpMyAdmin or with the Workbench.<br><br>
			== Does MS-SQL also work instead of MySQL or MariaDB? ==

			MS-SQL unfortunately does not work.<br><br>

	== Download MySQL ==		== Download MySQL ==

Harald Friedrich: /* Install MySQL / MariaDB */

2025-01-21T10:16:31Z

Install MySQL / MariaDB

← Older revision		Revision as of 12:16, 21 January 2025
Line 8:		Line 8:

	You can download the installers here: [https://dev.mysql.com/downloads/mysql MySQL] and [https://mariadb.org/download MariaDB]<br><br>You can install the database on a PC or on a server.		You can download the installers here: [https://dev.mysql.com/downloads/mysql MySQL] and [https://mariadb.org/download MariaDB]<br><br>You can install the database on a PC or on a server.

			== Set up / customize MySQL / MariaDB server and insert TARGET database ==

			* Create a new empty database “target3001db” (with collation utf8mb3_general_ci) with phpMyAdmin, for example, or in the SQL console:
			CREATE DATABASE target3001db CHARACTER SET utf8 COLLATE utf8_general_ci;
			* Download the following SQL file and import it into the new empty database: [https://office.ibfriedrich.com/target3001db.sql target3001db.sql] All tables, all functions and all triggers are created automatically.
			* Enter users and rights for the new database. User names and passwords may have a maximum of 16 characters each. The following rights are required: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE and TRIGGER.
			* In TARGET in the component browser in the “Connected to...” menu enter the settings for MySQL. These are also used for MariaDB:
			Start TARGET with MySQL database <enter “Yes” here>
			MySQL Server <name or IP of your MySQL/MariaDB server>
			MySQL User <your user name for the MySQL/MariaDB server>
			MySQL Password <your corresponding password>
			MySQL SSH Key <if SSH is used: SSH key file>
			MySQL SSH Cert <if SSH is used: Certificate-File>
			MySQL SSH CA <if SSH is used: Certificate-Authority-File>
			* If you have already created your own user components in the SQLite database, you can execute the menu item “Connected to... / Migration from SQLite to MySQL...” once and select the SQLite database ‘target3001.db’. The synchronization may take a moment. Additional *.db files can be imported later in the “Import / Export” menu.
			* To be on the safe side, you can call up the “Update” menu item again in the component browser.
			=== Particularities for Windows servers ===

			Necessary for Windows servers (with the console):

			$ mysql -u root -p

			or without password: $ mysql -u root

			mysql> use mysql
			mysql> GRANT ALL ON . to root@'%' IDENTIFIED BY '<your-mysql-root-password>';
			mysql> FLUSH PRIVILEGES;
			You can also make this setting with phpMyAdmin or with the Workbench.

	== Download MySQL ==		== Download MySQL ==

Harald Friedrich: /* MySQL / MariaDB: The fast database for multiple workstations */

2025-01-21T10:08:07Z

MySQL / MariaDB: The fast database for multiple workstations

← Older revision		Revision as of 12:08, 21 January 2025
Line 4:		Line 4:

	The SQLite database pre-installed with TARGET becomes slow with normal network transfer rates in multi-user operation. If you want to access a shared TARGET 3001! component database in a network with several workstations, you need the components in a ‘’‘MySQL database’‘’ or in a ‘’‘MariaDB’‘’. In our experience, however, the SQLite database has the edge in single-user operation.<br><br>		The SQLite database pre-installed with TARGET becomes slow with normal network transfer rates in multi-user operation. If you want to access a shared TARGET 3001! component database in a network with several workstations, you need the components in a ‘’‘MySQL database’‘’ or in a ‘’‘MariaDB’‘’. In our experience, however, the SQLite database has the edge in single-user operation.<br><br>

			== Install MySQL / MariaDB ==

			You can download the installers here: [https://dev.mysql.com/downloads/mysql MySQL] and [https://mariadb.org/download MariaDB]<br><br>You can install the database on a PC or on a server.

	== Download MySQL ==		== Download MySQL ==

Harald Friedrich: /* MySQL: The powerful database for TARGET 3001! multiuser */

2025-01-21T10:03:38Z

MySQL: The powerful database for TARGET 3001! multiuser

← Older revision		Revision as of 12:03, 21 January 2025
Line 1:		Line 1:
	[[image: mysqlight.png\|SQLiteMySQL\|right]]<br><br>		[[image: mysqlight.png\|SQLiteMySQL\|right]]<br><br>
	Have a look at the article [[Component database]] as well.		Have a look at the article [[Component database]] as well.
	== MySQL: The ~~powerful~~ database for ~~TARGET 3001! multiuser~~ ==		== MySQL / MariaDB: The fast database for multiple workstations ==

	If you are in a network with multiple workstations and want to use one common TARGET 3001! component database you will need to have the components stored in a '''MySQL database.''' The SQLite database being pre installed with TARGET 3001! performs in multi user situations with normal transfer rates very slowly though in standalone mode in our experience the SQLite database is in the lead.<br><br><big>''Note: Please use MySQL version 5.1.12 to 5.7. The use of tools like "MySQL Workbench" may cause problems.''</big><br><br>

			The SQLite database pre-installed with TARGET becomes slow with normal network transfer rates in multi-user operation. If you want to access a shared TARGET 3001! component database in a network with several workstations, you need the components in a ‘’‘MySQL database’‘’ or in a ‘’‘MariaDB’‘’. In our experience, however, the SQLite database has the edge in single-user operation.<br><br>

	== Download MySQL ==		== Download MySQL ==

Harald Friedrich: /* Does MariaDB also work instead of MySQL? */

2024-01-31T09:28:36Z

Does MariaDB also work instead of MySQL?

← Older revision		Revision as of 11:28, 31 January 2024
Line 153:		Line 153:
	[https://office.ibfriedrich.com/EineFrageEN/t31/q6/question.html Here] there is a tip from a customer.<br><br>		[https://office.ibfriedrich.com/EineFrageEN/t31/q6/question.html Here] there is a tip from a customer.<br><br>

			== Help, MySQL throws error messages! ==

			If TARGET can no longer connect to the database or throws other error messages, this may be due to deleted users. If necessary, recreate these users in the MySQL database.<br><br>



	[[de:MySQL]][[fr:MySQL]]		[[de:MySQL]][[fr:MySQL]]