MESS Developer

MySQL 접속

mysql -uroot -p mysql

접속 계정 생성

insert into user (host, user, password) values('%', 'User ID', password('User Password'));
flush privileges;

접근권한 설정(localhost)

DataBase Name.* to User ID@localhost identified by 'User Password' with grant option;

접근권한 설정(remote)

grant all privileges on DataBase Name.* to User ID@'%' identified by 'User Password' with grant option;
flush privileges;

사용자 등록 확인

select host, user, password from user;

my.cnf 파일 수정(bind-address 주석 처리)

#bind-address           = 127.0.0.1

MySQL 재시작

service mysql restart