Skip to content
Snippets Groups Projects
Select Git revision
  • f95f14195b732530c17c21e7665417ca44d93f3a
  • master default
  • snabel-a-hantering
  • pass
  • key-db-save
  • configuration-generation
  • obtain_ip
  • schema
8 results

mysql_setup.sql

Blame
  • mysql_setup.sql 547 B
    -- This file is for doing the initial setup of the database
    -- It's supposed to be run on mysql.lysator.liu.se
    --
    -- Replace "'password'" with an actuall password before running.
    --
    -- DO NOT RUN THIS UNLESS YOU KNOW WHAT YOU ARE DOING
    CREATE DATABASE lysns;
    
    CREATE USER 'lysns'@'localhost'
    IDENTIFIED BY 'password';
    CREATE USER 'lysns'@'%.lysator.liu.se'
    IDENTIFIED BY 'password';
    
    GRANT ALL PRIVILEGES ON lysns.* TO 'lysns'@'localhost'
        WITH GRANT OPTION;
    GRANT ALL PRIVILEGES ON lysns.* TO 'lysns'@'%.lysator.liu.se'
        WITH GRANT OPTION;