blog.helperchoi.com

※ 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);

SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

※ Centos 공식 Repository 외 RPMforge 를 추가 wget i386 http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm or wget x86_64 http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm ※ Redhat 5의 경우는 - http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt or wget http://apt..

※ 패키지의 path는 절대 경로 또는 *를 포함한 경로 가능 [root@TEST01 ~]# [root@TEST01 ~]# yum provides */crtfastmath.o Loaded plugins: fastestmirror, priorities, security Loading mirror speeds from cached hostfile * base: data.nicehosting.co.kr * extras: data.nicehosting.co.kr * rpmforge: ftp.riken.jp * updates: data.nicehosting.co.kr gcc44-4.4.7-1.el5.x86_64 : GNU Compiler Collection version 4.4 Repo : base Matched..