MySQL DB Local 사용자 권한 추가

GRANT ALL PRIVILEGES ON helperchoi_wiki.* TO helperchoi@localhost IDENTIFIED BY '패스워드';FLUSH PRIVILEGES;
System Story/Database 2013. 11. 10. 23:44
MySQL DB 생성 및 사용자 권한 추가

CREATE DATABASE DB명;GRANT ALL ON DB명.* TO 계정명@localhost IDENTIFIED BY '패스워드';GRANT ALL ON DB명.* TO 계정명@'%' IDENTIFIED BY '패스워드';FLUSH PRIVILEGES;
System Story/Database 2013. 11. 10. 23:43
MySQL 원격 접속을 위한 GRANT 설정

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;
System Story/Database 2013. 11. 10. 23:42
MySQL Root 패스워드 변경

※ MySQL 접속후 다음 쿼리 수행 use mysql;update user set password=password('패스워드') where user='root';flush privileges;select host, user, password from user;
System Story/Database 2013. 11. 10. 23:41
MSSQL MSCS Cluster node Domain 조회

select @@servername + '\' + @@servicename;
System Story/Database 2013. 11. 10. 23:35
[MSSQL LDF 볼륨 사용량 측정 ]

※ MSSQL DB의 트랜젝션 로그인 LDF 볼륨영역의 실제 사용량 조회dbcc sqlperf(logspace);
System Story/Database 2013. 11. 10. 23:35
1 2