반응형
- 2024-08-14 : Ubuntu server settings 추가.
Win+R 로 rdpclip.exe 실행해야 복붙이 됨.
mysqld --console 하면 에러가 뜨기 때문에
```[.lang-sql]
mysqld --initialize --user=mysql --console
// 중간에 temp pwd 있으니 잘 봐두고 접속
mysql -u root -p
CREATE USER 'eve'@'localhost' IDENTIFIED BY '{--pwd--}';
ALTER USER 'eve'@'localhost' IDENTIFIED BY '{--pwd--}';
GRANT ALL PRIVILEGES ON `recoeve01`.* TO 'eve'@'localhost';
// 이걸로 하면 안되는듯? GRANT ALL ON `Recoeve01`.* TO 'eve'@'localhost';
FLUSH PRIVILEGES;
mysql_config_editor set --login-path=backup --host=localhost --user=root --password
mysql_config_editor print --all
mysqldump --extended-insert=true -u root -p recoeve01 > mydump.sql
mysql -u root -p recoeve01 < mydump.sql
```/
Time error 나는거 해결해야 함.
```[.lang-sql]
SET GLOBAL sql_mode = "ALLOW_INVALID_DATES";
SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;
```/
### Timezone
```[.lang-sql]
mysql> status;
--------------
mysql Ver 8.0.30 for Win64 on x86_64 (MySQL Community Server - GPL)
Connection id: 41
Current database: recoeve01
Current user: root@localhost
SSL: Cipher in use is TLS_AES_256_GCM_SHA384
Using delimiter: ;
Server version: 8.0.30 MySQL Community Server - GPL
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
TCP port: 3306
Binary data as: Hexadecimal
Uptime: 4 days 2 hours 42 min 13 sec
Threads: 3 Questions: 122383 Slow queries: 0 Opens: 537 Flush tables: 3 Open tables: 437 Queries per second avg: 0.344
--------------
```/
```[.lang-sql]
mysql> SHOW variables like 'c%';
+----------------------------------------------+---------------------------------------------------------+
| Variable_name | Value |
+----------------------------------------------+---------------------------------------------------------+
| caching_sha2_password_auto_generate_rsa_keys | ON |
| caching_sha2_password_digest_rounds | 5000 |
| caching_sha2_password_private_key_path | private_key.pem |
| caching_sha2_password_public_key_path | public_key.pem |
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 8.0\share\charsets\ |
| check_proxy_users | OFF |
| collation_connection | utf8mb4_0900_ai_ci |
| collation_database | utf8mb4_0900_ai_ci |
| collation_server | utf8mb4_0900_ai_ci |
| completion_type | NO_CHAIN |
| concurrent_insert | AUTO |
| connect_timeout | 10 |
| connection_memory_chunk_size | 8912 |
| connection_memory_limit | 18446744073709551615 |
| core_file | OFF |
| create_admin_listener_thread | OFF |
| cte_max_recursion_depth | 1000 |
+----------------------------------------------+---------------------------------------------------------+
24 rows in set (0.14 sec)
```/
```[.lang-sql]
SELECT @@global.time_zone, @@session.time_zone;
SET GLOBAL time_zone='+00:00';
SET time_zone='+00:00';
```/
## Windows firewall
Windows firewall 에서 port 80, 443 access 를 풀어줘야 함. Inbound, Outbound 둘 다 풀어줌.
AWS security group 에서도 Inbound Custom TCP port 80, 443 풀어줘야 함.
Outbound 는 all traffic 을 풀어줘야 할듯?
## Console (cmd) 한글깨짐 문제
참고 . chcp 65001 (Changes the active console code page. UTF-8) 로 바꿔주는거고, regedit 눌러서 registry 도 변경해줘야 다시 실행했을때도 자동으로 잘 보이는듯.
Font 도 한글 보이는 걸로 바꿔줘야 함.
## HTTPS 로 접속되게
```[.lang-sh]
# Certbot 설치
sudo apt install certbot python3-certbot-nginx
# Certbot 실행하여 SSL 인증서 발급 및 Nginx 설정 자동 변경
sudo certbot --nginx -d example.com -d www.example.com
```/
## RRA
반응형
'[Recoeve.net]' 카테고리의 다른 글
| Recoeve.net IR (Investor Relations) 투자 발표 (5) | 2025.07.09 |
|---|---|
| Statistics of Recoeve.net (0) | 2025.07.09 |
| Recoeve progress (14) | 2025.07.05 |
| Career Portfolio - 이강수 (0) | 2025.07.03 |
| URI rendering test (2) | 2025.04.13 |
| Career Portfolio - Kang-soo Lee (0) | 2025.04.09 |
| Recoeve.net (3S|Slow/Sexy/Sincere SNS) 사용설명서/Manual (1) | 2025.03.17 |
