MySQL, MariaDB

비밀번호 변경

1. 개요 MySQL 계정의 비밀번호를 변경해보자   2. update 문 Update user set password=password(‘[비밀번호]’) where user=’root’; flush privileges; 3. Set password Set password for root=password(‘[비밀번호]’);   4. 비밀번호 강제 변경 service mysqld stop mysqld_safe –skip-grant-tables mysql -u root -p update user set authentication_string=password(‘2261bbs’) where user=’root’; flush privileges; service mysqld restart 오류 발생시> ERROR 1820 (HY000): […]

Continue Reading
MSSQL

메모리 할당량 확인

1. MSSQL 메모리 할당량 확인 SELECT (physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB, (locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB, (total_virtual_address_space_kb/1024) AS Total_VAS_in_MB, process_physical_memory_low, process_virtual_memory_low FROM sys.dm_os_process_memory;  

Continue Reading
Back To Top