<로그인 할 사용자 생성>

mysql>insert into user(host,user,password) values(‘접속허용할 호스트네임 or IP’,’root’,password(‘패스워드’));

 

<권한주기>

mysql> grant all privileges on *.* to ‘root’@’%’ identified by ‘암호’ with grant option;
mysql> flush privileges

Leave a Reply

Your email address will not be published. Required fields are marked *