質問するログイン新規登録

質問編集履歴

2

書式の改善

2020/06/26 10:54

投稿

suirunakamura
suirunakamura

スコア16

title CHANGED
File without changes
body CHANGED
@@ -66,9 +66,6 @@
66
66
  Enter password:
67
67
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
68
68
  ```
69
- 問題の確認と解決案をどうかお願いします。
70
-
71
-
72
69
  6/26日(金)追記します!
73
70
  とても親切に助言をいただきました!ありがとうございます。
74
71
  masibwさんに、エラーログの表示のアドバイスをいただいたので、表示します。6/21日からのエラーログになります。
@@ -130,4 +127,5 @@
130
127
  2020-06-21 22:33:43 930 [Note] Shutting down plugin 'mysql_native_password'
131
128
  2020-06-21 22:33:43 930 [Note] Shutting down plugin 'binlog'
132
129
  2020-06-21 22:33:43 930 [Note] /usr/local/opt/mysql@5.6/bin/mysqld: Shutdown complete
133
- ```
130
+ ```
131
+ よろしくお願いします、、

1

エラーログの追記

2020/06/26 10:54

投稿

suirunakamura
suirunakamura

スコア16

title CHANGED
File without changes
body CHANGED
@@ -66,4 +66,68 @@
66
66
  Enter password:
67
67
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
68
68
  ```
69
- 問題の確認と解決案をどうかお願いします。
69
+ 問題の確認と解決案をどうかお願いします。
70
+
71
+
72
+ 6/26日(金)追記します!
73
+ とても親切に助言をいただきました!ありがとうございます。
74
+ masibwさんに、エラーログの表示のアドバイスをいただいたので、表示します。6/21日からのエラーログになります。
75
+ ```ここに言語を入力
76
+ Version: '5.6.47' socket: '/tmp/mysql.sock' port: 3306 Homebrew
77
+ 2020-06-21 22:33:39 930 [Note] /usr/local/opt/mysql@5.6/bin/mysqld: Normal shutdown
78
+
79
+ 2020-06-21 22:33:39 930 [Note] Giving 2 client threads a chance to die gracefully
80
+ 2020-06-21 22:33:39 930 [Note] Event Scheduler: Purging the queue. 0 events
81
+ 2020-06-21 22:33:39 930 [Note] Shutting down slave threads
82
+ 2020-06-21 22:33:41 930 [Note] Forcefully disconnecting 2 remaining clients
83
+ 2020-06-21 22:33:41 930 [Warning] /usr/local/opt/mysql@5.6/bin/mysqld: Forcing close of thread 101 user: 'suirunakamura'
84
+
85
+ 2020-06-21 22:33:41 930 [Warning] /usr/local/opt/mysql@5.6/bin/mysqld: Forcing close of thread 100 user: 'suirunakamura'
86
+
87
+ 2020-06-21 22:33:41 930 [Note] Binlog end
88
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'partition'
89
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
90
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
91
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
92
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
93
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
94
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
95
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
96
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
97
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
98
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
99
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
100
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
101
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
102
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
103
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_FT_DELETED'
104
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
105
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_METRICS'
106
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
107
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
108
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
109
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
110
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
111
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
112
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_CMPMEM'
113
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_CMP_RESET'
114
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_CMP'
115
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
116
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_LOCKS'
117
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'INNODB_TRX'
118
+ 2020-06-21 22:33:41 930 [Note] Shutting down plugin 'InnoDB'
119
+ 2020-06-21 22:33:41 930 [Note] InnoDB: FTS optimize thread exiting.
120
+ 2020-06-21 22:33:41 930 [Note] InnoDB: Starting shutdown...
121
+ 2020-06-21 22:33:43 930 [Note] InnoDB: Shutdown completed; log sequence number 7505335
122
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'BLACKHOLE'
123
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'ARCHIVE'
124
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'MRG_MYISAM'
125
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'MyISAM'
126
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'MEMORY'
127
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'CSV'
128
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'sha256_password'
129
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'mysql_old_password'
130
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'mysql_native_password'
131
+ 2020-06-21 22:33:43 930 [Note] Shutting down plugin 'binlog'
132
+ 2020-06-21 22:33:43 930 [Note] /usr/local/opt/mysql@5.6/bin/mysqld: Shutdown complete
133
+ ```