===== Datenbanken =====
===== ilias dev =====
CREATE DATABASE iliasdev CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'iliasdev'@'localhost' IDENTIFIED BY 'SuperSommer2019';
GRANT LOCK TABLES on *.* TO 'iliasdev@localhost';
GRANT ALL PRIVILEGES ON iliasdev.* TO 'iliasdev'@'localhost';
FLUSH PRIVILEGES;

===== db_webinar_fczs =====
CREATE DATABASE db_webinar_fczs CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'db_webinar_fczs'@'localhost' IDENTIFIED BY 'Sommer2019';
GRANT LOCK TABLES on *.* TO 'db_webinar_fczs@localhost';
GRANT ALL PRIVILEGES ON db_webinar_fczs.* TO 'db_webinar_fczs'@'localhost';
FLUSH PRIVILEGES;

===== db_webinar_fcc =====
CREATE DATABASE db_webinar_fcc CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'db_webinar_fcc'@'localhost' IDENTIFIED BY 'Sommer2019';
GRANT LOCK TABLES on *.* TO 'db_webinar_fcc@localhost';
GRANT ALL PRIVILEGES ON db_webinar_fcc.* TO 'db_webinar_fcc'@'localhost';
FLUSH PRIVILEGES;

zurück