[MySQL] 유저 권한 부여 오류 : ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'password'' at line 1

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'password'' at line 1

 

mysql 8 버전 미만에서는 유저 생성, 권한 설정이 한번에 되지만

8 버전 이상에서는 불가능하다.

 

8 버전 미만

GRANT ALL PRIVILEGES ON team_dev.* TO user_dev@localhost IDENTIFIED BY 'password';
flush privileges;

 

8 버전 이상

create user user_dev@'%' identified by 'password';
grant all privileges on team_dev.* to user_dev@'%';
flush privileges;