blog.helperchoi.com

GRANT ALL PRIVILEGES ON helperchoi_wiki.* TO helperchoi@localhost IDENTIFIED BY '패스워드';FLUSH PRIVILEGES;

CREATE DATABASE DB명;GRANT ALL ON DB명.* TO 계정명@localhost IDENTIFIED BY '패스워드';GRANT ALL ON DB명.* TO 계정명@'%' IDENTIFIED BY '패스워드';FLUSH PRIVILEGES;

use mysql;grant all privileges on *.* to 'root'@'%';flush privileges; update user set host = '%' where user = 'mysql'; grant all on test.* to 'mysql';select host, user, select_priv, update_priv, delete_priv from user;

※ MySQL 접속후 다음 쿼리 수행 use mysql;update user set password=password('패스워드') where user='root';flush privileges;select host, user, password from user;

select @@servername + '\' + @@servicename;

※ MSSQL DB의 트랜젝션 로그인 LDF 볼륨영역의 실제 사용량 조회dbcc sqlperf(logspace);