[SQL] 권한 설정

개요

• 설정만 하고 적용을 하지 않으면 적용되지 않음

설정

• GRANT ALL PRIVILEGES ON DB_NAME.TABLE_NAME TO 'user_name'@'%' IDENTIFIED BY 'password';
• GRANT ALL PRIVILEGES ON DB_NAME.* TO 'user_name'@'localhost' IDENTIFIED BY 'password';
• GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'localhost' IDENTIFIED BY 'password';

적용

• flush privileges;