Mysql: Difference between revisions

Klinger (talk | contribs)
m links to mysql and mariadb and second example to differentiate between both engines
Nyxar77 (talk | contribs)
m Tips: i included a link for the mycli github page
 
(One intermediate revision by the same user not shown)
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 [https://github.com/dbcli/mycli mycli] to get autocompletion when working with mysql/mariadb
 
<syntaxhighlight lang="nix">environment.systemPackages = [ pkgs.mycli ];</syntaxhighlight>


= Maintenance =
= Maintenance =