#CREATE DATABASE <database-name> CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; create database confluence character set utf8mb4 collate utf8mb4_bin; #CREATE user '<confluenceuser>'@'localhost' IDENTIFIED BY '<password>'; create user confluence_user@localhost identified by '3e4r5t6y'; create user confluence_user@192.168.248.128 identified by '3e4r5t6y'; #GRANT ALL PRIVILEGES ON <database-name>.* TO '<confluenceuser>'@'localhost' WITH GRANT OPTION; grant all privileges on confluence.* to confluence_user@localhost with grant option; grant all privileges on confluence.* to confluence_user@192.168.248.128 with grant option; grant all privileges on confluence.* to confluence_user@172.21.0.2 with grant option;