[MariaDB] User 생성 및 권한 부여

User 생성

전체 DB 조회 유저

-- create user '[User Name]'@'%' identified by '[User Password]';
create user 'TestUser'@'%' identified by 'TestPassword';

특정 DB 조회 유저

-- create user '[User Name]'@'[DB Name]' identified by '[User Password]';
create user 'TestUser'@'TestDB' identified by 'TestPassword';

User 권한 부여

전체 IP 접속 가능

-- grant all privileges on [DB Name].* to '[User Name]'@'%' identified by '[User Password]';
grant all privileges on TestDB.* to 'TestUser'@'%' identified by 'TestPassword';

flush privileges;

특정 IP 접속 가능

-- Ex) Access IP : 192.168.1.2

-- grant all privileges on [DB Name].* to '[User Name]'@'192.168.1.2' identified by '[User Password]';
grant all privileges on TestDB.* to 'TestUser'@'192.168.1.2' identified by 'TestPassword';

flush privileges;