Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
create user 'user명'@'%' identified by '패스워드';
create user 'user명'@'localhost' identified by '패스워드';
flush privileges;


create database DB명;
grant all privileges on DB명.* to 'user명'@'%';
grant all privileges on DB명.* to 'user명'@'localhost';

그외 원격접속허용 : httpshttp://zetawikiall-record.tistory.com/wiki/MySQL_%EC%9B%90%EA%B2%A9_%EC%A0%91%EC%86%8D_%ED%97%88%EC%9A%A995