MySQL Installation - Revision history

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-25T19:22:53Z

Installation of the older MariaDB on RHEL9 from source

@@ Line 192: / Line 192: @@
   scripts/mysql_install_db --user=mysql --basedir=/root/mysql --datadir=/database
-It will print following instructions:
+Start the MariaDB server manually to make sure it is running:
   ./bin/mysqld_safe
-and then send it to background.
+Import everything from the old clondb3's sql file:
   ./bin/mysql -u root
   MariaDB [mysql]> SET GLOBAL log_bin_trust_function_creators = 1;
@@ Line 245: / Line 203: @@
   MariaDB [mysql]> SOURCE /root/clondb3_full_backup.sql;
-In case of ''root'' access problems, run it with following flags:
+'''NOTE:''' in case of ''root'' access problems, run it with following flags:
   ./bin/mysqld_safe --skip-grant-tables --skip-networking
 To run it as systemd service, create file ''/usr/lib/systemd/system/mariadb.service'' with following content:
@@ Line 266: / Line 226: @@
   [Install]
   WantedBy=multi-user.target
 == RHEL7 ==

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-25T19:14:13Z

Installation of the older MariaDB on RHEL9 from source

@@ Line 163: / Line 163: @@
   make
   make install
 Make sure 'mysql:27' user and 'mysql:27' group exists.

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-25T19:07:28Z

Installation of the older MariaDB on RHEL9 from source

← Older revision		Revision as of 15:07, 25 January 2026
Line 160:		Line 160:
	mkdir build		mkdir build
	cd build		cd build
	~~###cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/root/mysql/data -DSYSCONFDIR=/root/mysql/etc -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE~~
	cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/database -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE		cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/database -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE
	make		make

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-24T15:48:17Z

Installation of the older MariaDB on RHEL9 from source

← Older revision		Revision as of 11:48, 24 January 2026
Line 229:		Line 229:

	./bin/mysqld_safe --skip-grant-tables --skip-networking		./bin/mysqld_safe --skip-grant-tables --skip-networking

			To run it as systemd service, create file ''/usr/lib/systemd/system/mariadb.service'' with following content:

			[Unit]
			Description=Mariadb 5.5
			After=network.target

			[Service]
			Type=forking
			PrivateTmp=true
			User=mysql
			Group=mysql
			ExecStart=/root/mysql/support-files/mysql.server start
			ExecStop=/root/mysql/support-files/mysql.server stop
			Restart=on-abort

			[Install]
			WantedBy=multi-user.target

	== RHEL7 ==		== RHEL7 ==

Boiarino: /* RHEL9 */

2026-01-24T13:39:57Z

RHEL9

← Older revision		Revision as of 09:39, 24 January 2026
Line 37:		Line 37:

	# Tuning parameters		# Tuning parameters
	~~open-files-limit~~ = 1040400		open_files_limit = 1040400
	max_connections = 1024		max_connections = 1024

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-23T22:51:02Z

Installation of the older MariaDB on RHEL9 from source

@@ Line 172: / Line 172: @@
   cd /root/mysql
   scripts/mysql_install_db --user=mysql --basedir=/root/mysql --datadir=/database
 Start the MariaDB server manually or configure it as a service:

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-23T22:29:49Z

Installation of the older MariaDB on RHEL9 from source

← Older revision		Revision as of 18:29, 23 January 2026
Line 187:		Line 187:
	MariaDB [mysql]> SET GLOBAL log_bin_trust_function_creators = 1;		MariaDB [mysql]> SET GLOBAL log_bin_trust_function_creators = 1;
	MariaDB [mysql]> SET FOREIGN_KEY_CHECKS = 0;		MariaDB [mysql]> SET FOREIGN_KEY_CHECKS = 0;
	MariaDB [mysql]> SOURCE /root/clondb3_full_backup.sql		MariaDB [mysql]> SOURCE /root/clondb3_full_backup.sql;

	In case of ''root'' access problems, run it with following flags:		In case of ''root'' access problems, run it with following flags:

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-23T22:27:11Z

Installation of the older MariaDB on RHEL9 from source

← Older revision		Revision as of 18:27, 23 January 2026
Line 161:		Line 161:
	cd build		cd build
	###cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/root/mysql/data -DSYSCONFDIR=/root/mysql/etc -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE		###cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/root/mysql/data -DSYSCONFDIR=/root/mysql/etc -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE
	cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/database		cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/database -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE
	make		make
	make install		make install

Boiarino: /* Installation of the older MariaDB on RHEL9 from source */

2026-01-23T22:26:40Z

Installation of the older MariaDB on RHEL9 from source

← Older revision		Revision as of 18:26, 23 January 2026
Line 153:		Line 153:
	== Installation of the older MariaDB on RHEL9 from source ==		== Installation of the older MariaDB on RHEL9 from source ==

	cp /root		cd /root
	cp /usr/downloads/mariadb-5.5.68.tar.gz .		cp /usr/downloads/mariadb-5.5.68.tar.gz .
	tar -xzvf mariadb-5.5.68.tar.gz		tar -xzvf mariadb-5.5.68.tar.gz
Line 161:		Line 161:
	cd build		cd build
	###cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/root/mysql/data -DSYSCONFDIR=/root/mysql/etc -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE		###cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/root/mysql/data -DSYSCONFDIR=/root/mysql/etc -DDISABLE_LIBMYSQLCLIENT_SYMBOL_VERSIONING=TRUE
	cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/~~root/mysql/data~~		cmake .. -DCMAKE_INSTALL_PREFIX=/root/mysql -DMYSQL_DATADIR=/database
	make		make
	make install		make install
Line 167:		Line 167:
	Make sure 'mysql:27' user and 'mysql:27' group exists.		Make sure 'mysql:27' user and 'mysql:27' group exists.

	Make sure ''/root'' is ''drwxr-xr-x. root root'', ''/root/mysql'' is ''drwxr-xr-x. root root'', and ''/~~root/mysql/data~~'' is ''drwxr-xr-x. mysql ~~root~~''.		Make sure ''/root'' is ''drwxr-xr-x. root root'', ''/root/mysql'' is ''drwxr-xr-x. root root'', and ''/database'' is ''drwxr-xr-x. mysql mysql''.

	Initialize the Data Directory: The initial system tables and data directory need to be created before MariaDB can run:		Initialize the Data Directory: The initial system tables and data directory need to be created before MariaDB can run:
	cd /root/mysql		cd /root/mysql
	scripts/mysql_install_db --user=mysql --basedir=/root/mysql --datadir=/~~root/mysql/data~~		scripts/mysql_install_db --user=mysql --basedir=/root/mysql --datadir=/database

	Start the MariaDB server manually or configure it as a service:		Start the MariaDB server manually or configure it as a service:

Boiarino at 22:07, 23 January 2026

2026-01-23T22:07:25Z

← Older revision		Revision as of 18:07, 23 January 2026
Line 18:		Line 18:

	chown mysql:mysql /database		chown mysql:mysql /database

			Sometimes mysql log files can be very large, so they can be placed to separate partition if available, for example ''/data/logs'', in that case adjust corresponding line ''/etc/my.cnf.d/mysql-server.cnf'' below.

	'''NONONO!!!''' Create subdirectories if using ''/database'' area:		'''NONONO!!!''' Create subdirectories if using ''/database'' area: