voltatek / alliance_auth_docker

Docker stack with Traefik for Alliance Auth
https://gitlab.com/allianceauth/allianceauth
GNU General Public License v3.0
5 stars 5 forks source link

sql setup correction. #9

Open mercyground opened 3 years ago

mercyground commented 3 years ago

Given Allaince Auth docs state user setup should be as per this:

CREATE USER 'allianceserver'@'localhost' IDENTIFIED BY 'PASSWORD';
CREATE DATABASE alliance_auth CHARACTER SET utf8mb4;
GRANT ALL PRIVILEGES ON alliance_auth . * TO 'allianceserver'@'localhost';

Your sql file is this :

CREATE USER 'aauth'@'localhost' IDENTIFIED BY 'PASSWORD';
CREATE DATABASE aauth CHARACTER SET utf8mb4;
GRANT ALL PRIVILEGES ON alliance_auth . * TO 'aauth'@'localhost';

that last line should read

GRANT ALL PRIVILEGES ON aauth . * TO 'aauth'@'localhost';