MySQL DB·유저·권한 생성

DB·유저·권한

-- utf8mb4
CREATE DATABASE appdb
  CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- MySQL 5.7+
CREATE USER 'appuser'@'localhost' IDENTIFIED BY 'password'
  PASSWORD EXPIRE NEVER;
GRANT ALL ON appdb.* TO 'appuser'@'localhost';
FLUSH PRIVILEGES;

-- 5.7 미만 (구문)
GRANT ALL ON appdb.* TO 'appuser'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

password policy (ERROR 1819)

SHOW VARIABLES LIKE 'validate_password%';
SET GLOBAL validate_password_policy = LOW;

또는 my.cnf [mysqld]에 validate_password_policy=LOW 후 재시작.

암호 변경

ALTER USER 'appuser'@'localhost' IDENTIFIED BY 'newpassword';
SET PASSWORD FOR 'appuser'@'localhost' = 'newpassword';

ERROR 1044 Grant

원격에서 GRANT 불가 시 → SELECT host,user,Grant_priv FROM mysql.user; 후 허용된 host에서 실행.