Database

MySQL 8.0 사용자 계정 생성 및 권한 설정

kogun82 2023. 3. 2. 13:17
show variables like 'validate_password%';
set global validate_password.policy=LOW;
create user 'sample'@'%' identified by 'sample123';
grant all privileges on *.* to sample@'%' with grant option;
drop user 'sample'@'%';
flush privileges;