/usr/share/freemedforms/sql/server_config/config.sql is in freemedforms-freedata 0.9.4-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 | -- /***************************************************************************
-- * The FreeMedForms project is a set of free, open source medical *
-- * applications. *
-- * (C) 2008-2014 by Eric MAEKER, MD (France) <eric.maeker@gmail.com> *
-- * All rights reserved. *
-- * *
-- * This program is free software: you can redistribute it and/or modify *
-- * it under the terms of the GNU General Public License as published by *
-- * the Free Software Foundation, either version 3 of the License, or *
-- * (at your option) any later version. *
-- * *
-- * This program is distributed in the hope that it will be useful, *
-- * but WITHOUT ANY WARRANTY; without even the implied warranty of *
-- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
-- * GNU General Public License for more details. *
-- * *
-- * You should have received a copy of the GNU General Public License *
-- * along with this program (COPYING.FREEMEDFORMS file). *
-- * If not, see <http://www.gnu.org/licenses/>. *
-- ***************************************************************************/
-- /**************************************************************************
-- * Main Developer: Eric MAEKER, MD <eric.maeker@free.fr> *
-- * Contributors: *
-- ***************************************************************************/
-- /**
-- * \file global_resources/sql/server_config/config.sql
-- * \author Eric MAEKER, MD <eric.maeker@free.fr>
-- * \version 0.10.0
-- * \date 22 Jul 2014
-- */
-- /**
-- * \brief Use this script to configure you MySQL server.
-- *
-- * You must be connected with a MySQL server administrator user.
-- *
-- * \warning SQL commands MUST end with \e ;
-- *
-- */
-- Create the main FreeMedForms adminstrator on MySQL user
-- An error will occur if the user does not exist and the script will fail
-- DROP USER 'fmf_admin';
-- An error will occur if the user already exists and the script will fail
CREATE USER 'fmf_admin' IDENTIFIED BY 'fmf_admin';
GRANT CREATE USER, GRANT OPTION, RELOAD, SHOW DATABASES ON *.* TO 'fmf_admin'@'%' IDENTIFIED BY 'fmf_admin';
GRANT SELECT, UPDATE, INSERT, DELETE, CREATE, DROP, ALTER, INDEX, GRANT OPTION ON `%fmf\_%`.* TO 'fmf_admin'@'%' IDENTIFIED BY 'fmf_admin';
GRANT CREATE USER, GRANT OPTION, RELOAD, SHOW DATABASES ON *.* TO 'fmf_admin'@'localhost' IDENTIFIED BY 'fmf_admin';
GRANT SELECT, UPDATE, INSERT, DELETE, CREATE, DROP, ALTER, INDEX, GRANT OPTION ON `%fmf\_%`.* TO 'fmf_admin'@'localhost' IDENTIFIED BY 'fmf_admin';
GRANT SELECT, UPDATE, INSERT, DELETE, CREATE ON `mysql`.`user` TO 'fmf_admin'@'localhost' IDENTIFIED BY 'fmf_admin';
GRANT SELECT, UPDATE, INSERT, DELETE, CREATE ON `mysql`.`user` TO 'fmf_admin'@'%' IDENTIFIED BY 'fmf_admin';
FLUSH PRIVILEGES;
-- Create the main FreeMedForms administrator on FreeMedForms user table
|