MySQL 읽기전용 계정 만들기

Creating a read-only user account for MySQL

MySQL 읽기전용 계정 생성

읽기전용 계정 만들기

1 방법 1

CREATE USER readonlyuser;
SET PASSWORD FOR readonlyuser = PASSWORD('P@ssw0rd');
GRANT SELECT ON *.* TO readonlyuser;

2 방법 2

INSERT INTO mysql.user (Host,User,Password,Select_priv) VALUES ('%','readonlyuser',PASSWORD('P@ssw0rd'),'Y');
FLUSH privileges;

3 참고 자료

• http://www.symantec.com/business/support/index?page=content&id=HOWTO30408