DATABASE/MYSQL 2014. 1. 25. 15:38




#mysql -u root -p mysql // mysql 접속 

select host, user, password from user;

모든 IP
INSERT INTO mysql.user (host,user,password) VALUES ('%','계정',password('계정비밀번호'));
GRANT ALL PRIVILEGES ON 계정.* TO '계정'@'%';
FLUSH PRIVILEGES;

원복
DELETE FROM mysql.user WHERE Host='%' AND User='계정';
FLUSH PRIVILEGES;



http://jmnote.com/wiki/MySQL%EC%97%90_%EC%9B%90%EA%B2%A9_%EC%A0%91%EC%86%8D_%ED%97%88%EC%9A%A9


posted by 나는너의힘
: