Manage users in MariaDB >= 10.1.1

HTTP server for managing MariaDB users. Designed to work behind Sproxy and assuming users' logins are their email addresses (MariaDB allows up to 80 characters).

Juan de la Cosa

HTTP server for managing MariaDB users. Designed to work behind Sproxy. and assuming users' logins are their email addresses (MariaDB allows up to 80 characters).

Currently it only let users get new passwords.

Requirements

Juan de la Cosa is written in Haskell with GHC. All required Haskell libraries are listed in juandelacosa.cabal. Use cabal-install to fetch and build all pre-requisites automatically.

Installation

$ git clone https://github.com/ip1981/juandelacosa.git
$ cd juandelacosa
$ cabal install

Usage

Type juandelacosa --help to see usage summary:

Usage: juandelacosa [-f|--file FILE] [-g|--group STRING] [-d|--datadir DIR]
                    [(-p|--port INT) | (-s|--socket PATH)]

Available options:
  -f,--file FILE           Read this MySQL client config file
  -g,--group STRING        Read this options group in the above file
                           (default: "client")
  -d,--datadir DIR         Data directory including static files
                           (default: "/home/pashev/.cabal/share/x86_64-linux-ghc-8.8.4/juandelacosa-0.1.2")
  -p,--port INT            listen on this TCP port (localhost only)
  -s,--socket PATH         Listen on this UNIX-socket
                           (default: "/tmp/juandelacosa.sock")
  -h,--help                Show this help text

Database Privileges

CREATE USER IF NOT EXISTS 'juandelacosa'@'localhost' IDENTIFIED VIA unix_socket;
REVOKE ALL, GRANT OPTION FROM 'juandelacosa'@'localhost';
GRANT UPDATE ON `mysql`.* TO 'juandelacosa'@'localhost';
GRANT SELECT ON `mysql`.`user` TO 'juandelacosa'@'localhost';

Screenshots.