[MySQL] 기본 설정 팁 1

사용자 추가

  - CREATE USER 'userId'@'allow address' IDENTIFIED BY 'password';

   ex ) CREATE USER 'bluewhale'@'localhost' IDENTIFIED BY '1234';

        CREATE USER 'bluewhale'@'%' IDENTIFIED BY '12345';

        CREATE USER 'bluewhale'@'123.123.123.123' IDENTIFIED BY '2345';

 

사용자 삭제

  - DROP USER 'userid'@'allow address';

  ex ) DROP USER 'bluewhale'@'localhost';

        DROP USER 'bluewhale'@'%';

 

DB 생성

  - CREATE DATABASE dbname;

  ex ) CREATE DATABASE whaledb;

 

DB 권한 부여

  - GRANT ALL PRIVILEGES ON dbname.tablename TO 'userid'@'allow address';

    FLUSH PRIVILEGES;

  ex ) GRANT ALL PRIVILEGES ON whaledb.* TO 'bluewhale'@'localhost';

        FLUSH PRIVILEGES;