Mysql - Revision history

Nyxar77: /* Tips */ i included a link for the mycli github page

2025-10-22T23:28:03Z

Tips: i included a link for the mycli github page

← Older revision		Revision as of 23:28, 22 October 2025
Line 24:		Line 24:
	= Tips =		= Tips =

	install `mycli` to get autocompletion when working with mysql/mariadb		install [https://github.com/dbcli/mycli mycli] to get autocompletion when working with mysql/mariadb

	<syntaxhighlight lang="nix">environment.systemPackages = [ pkgs.mycli ];</syntaxhighlight>		<syntaxhighlight lang="nix">environment.systemPackages = [ pkgs.mycli ];</syntaxhighlight>

Nyxar77: just added a tips section for those who might need it, it includes `mycli`

2025-10-22T23:24:29Z

just added a tips section for those who might need it, it includes `mycli`

← Older revision		Revision as of 23:24, 22 October 2025
Line 18:		Line 18:
	Setup and enable MariaDB database daemon (in this example: version 11.0)		Setup and enable MariaDB database daemon (in this example: version 11.0)

	<syntaxhighlight lang="nix">		<syntaxhighlight lang="nix">services.mysql = {
	services.mysql = {
	enable = true;		enable = true;
	package = pkgs.mariadb_110;		package = pkgs.mariadb_110;
	};		};</syntaxhighlight>
	</syntaxhighlight>		= Tips =

			install `mycli` to get autocompletion when working with mysql/mariadb

			<syntaxhighlight lang="nix">environment.systemPackages = [ pkgs.mycli ];</syntaxhighlight>

	= Maintenance =		= Maintenance =

Klinger: links to mysql and mariadb and second example to differentiate between both engines

2024-09-29T17:47:30Z

links to mysql and mariadb and second example to differentiate between both engines

← Older revision		Revision as of 17:47, 29 September 2024
Line 1:		Line 1:
	MySQL ~~is a widely used open source relational database management system (RDBMS) that offers various features, tools,~~ and services ~~for data warehousing, analytics, machine learning, and more~~. ~~MariaDB is a popular and stable fork of MySQL that is compatible with MySQL and has additional enhancements and features~~.		[https://www.mysql.com MySQL] and [https://mariadb.org MariaDB] are installed via the same services.mysql configuration.

	~~= Setup =~~		* MySQL is a widely used open source relational database management system (RDBMS) that offers various features, tools, and services for data warehousing, analytics, machine learning, and more.
			* MariaDB is a popular and stable fork of MySQL that is compatible with MySQL and has additional enhancements and features.

	Setup and enable Mysql (MariaDB) database daemon		= Setup MySQL =

			Setup and enable Mysql database daemon (in this example: latest stable version in nixpkgs)

			<syntaxhighlight lang="nix">
			services.mysql = {
			enable = true;
			package = pkgs.mysql;
			};
			</syntaxhighlight>
			= Setup MariaDB =

			Setup and enable MariaDB database daemon (in this example: version 11.0)

	<syntaxhighlight lang="nix">		<syntaxhighlight lang="nix">
	services.mysql = {		services.mysql = {
	enable = true;		enable = true;
	package = pkgs.~~mariadb~~;		package = pkgs.mariadb_110;
	};		};
	</syntaxhighlight>		</syntaxhighlight>

imported>Onny at 16:42, 19 December 2023

2023-12-19T16:42:58Z

← Older revision		Revision as of 16:42, 19 December 2023
Line 6:		Line 6:

	<syntaxhighlight lang="nix">		<syntaxhighlight lang="nix">
	services.mysql.enable = true;		services.mysql = {
			enable = true;
			package = pkgs.mariadb;
			};
	</syntaxhighlight>		</syntaxhighlight>

imported>Onny: Initial page

2023-12-19T16:26:43Z

Initial page

New page

MySQL is a widely used open source relational database management system (RDBMS) that offers various features, tools, and services for data warehousing, analytics, machine learning, and more. MariaDB is a popular and stable fork of MySQL that is compatible with MySQL and has additional enhancements and features.

= Setup =

Setup and enable Mysql (MariaDB) database daemon

<syntaxhighlight lang="nix">
services.mysql.enable = true;
</syntaxhighlight>

= Maintenance =

== Upgrade ==

NixOS will not run <code>mysql_upgrade</code> automatically for you after upgrading to a new major version, because it is a "dangerous" operation (can lead to data corruption) and users are strongly advised (by MariaDB upstream) to backup their database before running <code>mysql_upgrade</code>.

<syntaxhighlight lang="nix">
mysqldump -u root -p --all-databases > alldb.sql
</syntaxhighlight>

After backup is completed, you can proceed with the upgrade process

<syntaxhighlight lang="nix">
mysql_upgrade
</syntaxhighlight>

[[Category:Database]]