[DB] MySQL 외부접속/원격접속 설정하기
1. mysql 접속 > mysql -uroot 2. 외부접속용 계정 생성 (ID:admin, PWD:1234) > INSERT INTO mysql.user (host,user,authentication_string,ssl_cipher, x509_issuer, x509_subject) VALUES ('%','admin',password('1234'),'','',''); 3. 외부접속 권한 부여 > GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%'; > FLUSH PRIVILEGES;
2020. 12. 24.