1. 개요 mysql 서버 접속 명령어 2. Local 접속 mysql -u [username] -p [DB명] 3. 원격 접속 mysql -h [IP] -P [포트] -u [username] -p
Category: DB
비밀번호 변경
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): […]
메모리 할당량 확인
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;