MySQLのインストールとデーター移行

[client]
# pipe=
# socket=MYSQL
port=3306

[mysql]
no-beep
# default-character-set= cp932

[mysqld]
# character-set-server= utf8mb4
# collation-server= utf8mb4_0900_ai_ci
port=3306
basedir = "D:\\Program Files\\mysql"
datadir = "D:\\ProgramData\\mysql\\data"
tmpdir = "D:\\ProgramData\\mysql\\temp"

default_authentication_plugin=caching_sha2_password
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"

## logging
log-output=FILE
general_log = 0
general_log_file = "D:\\ProgramData\\mysql\\logs\\general.log"
slow_query_log = 1
slow_query_log_file = "D:\\ProgramData\\mysql\\logs\\slow_query.log"
long_query_time=10
log_error = "D:\\ProgramData\\mysql\\logs\\error.log"
log-bin="binlog"
# error messages
lc_messages_dir ="D:\\Program Files\\mysql\\share"
log_timestamps = SYSTEM

server-id=1
lower_case_table_names=1
secure-file-priv="D:\\ProgramData\\mysql\\Uploads"
max_connections=151
table_open_cache=2000
tmp_table_size=241M
thread_cache_size=10
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=469M
key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=256K
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=8M
innodb_redo_log_capacity=48M
innodb_thread_concurrency=17
innodb_autoextend_increment=64
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=4M
max_connect_errors=100
open_files_limit=4161
sort_buffer_size=256K
table_definition_cache=1400
binlog_row_event_max_size=8K
sync_source_info=10000
sync_relay_log=10000
loose_mysqlx_port=33060

# タイムゾーン名、オフセットどちらでも反映可能
#default-time-zone = 'Asia/Tokyo'
default-time-zone='+9:00'

[Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
# sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"　　　変更前
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"　　　変更後

[Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=100663296. Please use innodb_redo_log_capacity instead.
# innodb_log_file_size=48M　　　変更前
innodb_redo_log_capacity=48M　　変更後

[Warning] [MY-011068] [Server] The syntax 'sync_master_info' is deprecated and will be removed in a future release. Please use sync_source_info instead.
# sync_master_info=10000　　　変更前
sync_source_info=10000　　　　変更後

[Warning] [MY-011070] [Server] '--sync-relay-log-info' is deprecated and will be removed in a future release.
# sync_relay_log_info=10000   廃止のため削除

[Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
未対策

libcrypto-1_1-x64.dll
libssh2.dll
libssl-1_1-x64.dll
nghttp2.dll　　　<<<< Apacheの bin にあり

bin\mysqld --defaults-file="D:\ProgramData\mysql\my.ini" --initialize-insecure  --console

<code>--</code>defaults-file

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

D:\Program Files\mysql>bin\mysqld --defaults-file="D:\ProgramData\mysql\my.ini" --initialize-insecure  --console
2023-09-04T11:16:55.229132+09:00 0 [System] [MY-013169] [Server] D:\Program Files\mysql\bin\mysqld.exe (mysqld 8.0.34) initializing of server in progress as process 2720
2023-09-04T11:16:55.308958+09:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-04T11:17:03.726427+09:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-09-04T11:17:08.420264+09:00 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

D:\Program Files\mysql>

bin\mysqld --defaults-file="D:\ProgramData\mysql\my.ini" --console

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

D:\Program Files\mysql>bin\mysqld --defaults-file="D:\ProgramData\mysql\my.ini" --console
2023-09-04T11:21:30.475606+09:00 0 [System] [MY-010116] [Server] D:\Program Files\mysql\bin\mysqld.exe (mysqld 8.0.34) starting as process 944
2023-09-04T11:21:30.563415+09:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-09-04T11:21:35.150859+09:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-09-04T11:21:36.000454+09:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-09-04T11:21:36.008179+09:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for thischannel.
2023-09-04T11:21:36.091560+09:00 0 [System] [MY-011323] [Server] X Plugin readyfor connections. Bind-address: '::' port: 33060
2023-09-04T11:21:36.091742+09:00 0 [System] [MY-010931] [Server] D:\Program Files\mysql\bin\mysqld.exe: ready for connections. Version: '8.0.34'  socket: ''  port: 3306  MySQL Community Server - GPL.

mysqld --install MYSQL --defaults-file="D:\ProgramData\mysql\my.ini"

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

D:\Program Files\mysql\bin>mysqld --install MYSQL --defaults-file="D:\ProgramData\mysql\my.ini"
Service successfully installed.

D:\Program Files\mysql\bin>


MySQL 起動
D:\Program Files\mysql\bin>NET START MYSQL

MySQL のサービスを削除
D:\Program Files\mysql\bin>mysqld --remove MYSQL

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\Windows\system32>NET START MYSQL
システム エラー 193 が発生しました。

*** は有効な Win32 アプリケーションではありません。

####### 競合ファイル「mysqld」を削除

C:\Windows\system32>NET START MYSQL
MYSQL サービスを開始します...
MYSQL サービスは正常に開始されました。


C:\Windows\system32>

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

D:\Program Files\mysql>mysql -u root --skip-password
mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.34 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootのパスワード';
Query OK, 0 rows affected (0.07 sec)

mysql> quit
Bye

########## 設定したパスワードでログイン確認

D:\Program Files\mysql>mysql -u root -p
Enter password: **************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.34 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>