설치 후 원격에서 접속 안될 때 bind-address 주석 처리.
MySQL 사용자 추가
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
MySQL 사용자 추가
grant all privileges on [DB_NAME].* to [USER_ID]@localhost identified by '[PASSWORD]';
grant all privileges on [DB_NAME].* to [USER_ID]@"%" identified by '[PASSWORD]';
flush privileges;
grant all privileges on [DB_NAME].* to [USER_ID]@"%" identified by '[PASSWORD]';
flush privileges;