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
| -- ========= --
-- Nettoyage --
-- ========= --
DROP USER IF EXISTS 'root'@'::1';
-- ===================== --
-- Privilège pour 'ROOT' --
-- ===================== --
DROP USER IF EXISTS 'root'@'127.0.0.1';
CREATE USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION;
DROP USER IF EXISTS 'root'@'localhost';
CREATE USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
DROP USER IF EXISTS 'root'@'phpmyadmin';
CREATE USER 'root'@'phpmyadmin' IDENTIFIED WITH mysql_native_password BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'phpmyadmin' WITH GRANT OPTION;
-- ====================== --
-- Privilège pour 'FORUM' --
-- ====================== --
DROP USER IF EXISTS 'forum'@'%';
CREATE USER 'forum'@'%' IDENTIFIED WITH mysql_native_password BY 'forum';
GRANT USAGE ON *.* TO 'forum'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON `forum`.* TO 'forum'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON `phpmyadmin`.* TO 'forum'@'%';
-- ===================== --
-- Privilège pour 'TEST' --
-- ===================== --
DROP USER IF EXISTS 'test'@'%';
CREATE USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'test';
GRANT USAGE ON *.* TO 'test'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON `test`.* TO 'test'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON `phpmyadmin`.* TO 'test'@'%';
-- ===================== --
-- Privilège pour 'BASE' --
-- ===================== --
DROP USER IF EXISTS 'base'@'%';
CREATE USER 'base'@'%' IDENTIFIED WITH mysql_native_password BY 'base';
GRANT USAGE ON *.* TO 'base'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON `base`.* TO 'base'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON `phpmyadmin`.* TO 'base'@'%';
flush privileges;
exit |
Partager