質問編集履歴
2
追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -228,6 +228,210 @@
|
|
228
228
|
|
229
229
|
|
230
230
|
|
231
|
+
# 追記
|
232
|
+
|
233
|
+
|
234
|
+
|
235
|
+
どうも、MySQLのプロセスが立ち上がってない…?
|
236
|
+
|
237
|
+
|
238
|
+
|
239
|
+
```
|
240
|
+
|
241
|
+
$ ps ax | grep mysql
|
242
|
+
|
243
|
+
```
|
244
|
+
|
245
|
+
|
246
|
+
|
247
|
+
↑自分しか出ない
|
248
|
+
|
249
|
+
|
250
|
+
|
251
|
+
エラーログを一度全クリア後、
|
252
|
+
|
253
|
+
|
254
|
+
|
255
|
+
```
|
256
|
+
|
257
|
+
/usr/sbin/mysqld --user=root
|
258
|
+
|
259
|
+
```
|
260
|
+
|
261
|
+
|
262
|
+
|
263
|
+
↓ エラーログ
|
264
|
+
|
265
|
+
|
266
|
+
|
267
|
+
```
|
268
|
+
|
269
|
+
2018-10-22T05:47:42.185394Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.24) starting as process 427 ...
|
270
|
+
|
271
|
+
2018-10-22T05:47:42.188000Z 0 [Note] InnoDB: PUNCH HOLE support available
|
272
|
+
|
273
|
+
2018-10-22T05:47:42.188038Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
274
|
+
|
275
|
+
2018-10-22T05:47:42.188047Z 0 [Note] InnoDB: Uses event mutexes
|
276
|
+
|
277
|
+
2018-10-22T05:47:42.188054Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
278
|
+
|
279
|
+
2018-10-22T05:47:42.188061Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
280
|
+
|
281
|
+
2018-10-22T05:47:42.188068Z 0 [Note] InnoDB: Using Linux native AIO
|
282
|
+
|
283
|
+
2018-10-22T05:47:42.188238Z 0 [Note] InnoDB: Number of pools: 1
|
284
|
+
|
285
|
+
2018-10-22T05:47:42.188320Z 0 [Note] InnoDB: Using CPU crc32 instructions
|
286
|
+
|
287
|
+
2018-10-22T05:47:42.189333Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
|
288
|
+
|
289
|
+
2018-10-22T05:47:42.196081Z 0 [Note] InnoDB: Completed initialization of buffer pool
|
290
|
+
|
291
|
+
2018-10-22T05:47:42.198297Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
292
|
+
|
293
|
+
2018-10-22T05:47:42.209708Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
|
294
|
+
|
295
|
+
2018-10-22T05:47:42.221513Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
296
|
+
|
297
|
+
2018-10-22T05:47:42.221578Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
298
|
+
|
299
|
+
2018-10-22T05:47:42.263084Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
300
|
+
|
301
|
+
2018-10-22T05:47:42.264346Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
|
302
|
+
|
303
|
+
2018-10-22T05:47:42.264381Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
|
304
|
+
|
305
|
+
2018-10-22T05:47:42.265052Z 0 [Note] InnoDB: Waiting for purge to start
|
306
|
+
|
307
|
+
2018-10-22T05:47:42.315545Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 1210075
|
308
|
+
|
309
|
+
2018-10-22T05:47:42.316198Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
|
310
|
+
|
311
|
+
2018-10-22T05:47:42.316278Z 0 [Note] Plugin 'FEDERATED' is disabled.
|
312
|
+
|
313
|
+
mysqld: Table 'mysql.plugin' doesn't exist
|
314
|
+
|
315
|
+
2018-10-22T05:47:42.316411Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
|
316
|
+
|
317
|
+
2018-10-22T05:47:42.316411Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181022 5:47:42
|
318
|
+
|
319
|
+
2018-10-22T05:47:42.316588Z 0 [ERROR] Too many arguments (first extra is 'start').
|
320
|
+
|
321
|
+
2018-10-22T05:47:42.316607Z 0 [Note] Use --verbose --help to get a list of available options!
|
322
|
+
|
323
|
+
2018-10-22T05:47:42.316616Z 0 [ERROR] Aborting
|
324
|
+
|
325
|
+
|
326
|
+
|
327
|
+
2018-10-22T05:47:42.316627Z 0 [Note] Binlog end
|
328
|
+
|
329
|
+
2018-10-22T05:47:42.316750Z 0 [Note] Shutting down plugin 'ngram'
|
330
|
+
|
331
|
+
2018-10-22T05:47:42.316762Z 0 [Note] Shutting down plugin 'partition'
|
332
|
+
|
333
|
+
2018-10-22T05:47:42.316778Z 0 [Note] Shutting down plugin 'BLACKHOLE'
|
334
|
+
|
335
|
+
2018-10-22T05:47:42.316786Z 0 [Note] Shutting down plugin 'ARCHIVE'
|
336
|
+
|
337
|
+
2018-10-22T05:47:42.316806Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
|
338
|
+
|
339
|
+
2018-10-22T05:47:42.316840Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
|
340
|
+
|
341
|
+
2018-10-22T05:47:42.316847Z 0 [Note] Shutting down plugin 'MyISAM'
|
342
|
+
|
343
|
+
2018-10-22T05:47:42.316861Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
|
344
|
+
|
345
|
+
2018-10-22T05:47:42.316868Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
|
346
|
+
|
347
|
+
2018-10-22T05:47:42.316874Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
|
348
|
+
|
349
|
+
2018-10-22T05:47:42.316880Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
|
350
|
+
|
351
|
+
2018-10-22T05:47:42.316886Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
|
352
|
+
|
353
|
+
2018-10-22T05:47:42.316892Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
|
354
|
+
|
355
|
+
2018-10-22T05:47:42.316898Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
|
356
|
+
|
357
|
+
2018-10-22T05:47:42.316904Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
|
358
|
+
|
359
|
+
2018-10-22T05:47:42.316910Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
|
360
|
+
|
361
|
+
2018-10-22T05:47:42.316916Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
|
362
|
+
|
363
|
+
2018-10-22T05:47:42.316922Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
|
364
|
+
|
365
|
+
2018-10-22T05:47:42.316928Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
|
366
|
+
|
367
|
+
2018-10-22T05:47:42.316934Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
|
368
|
+
|
369
|
+
2018-10-22T05:47:42.316940Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
|
370
|
+
|
371
|
+
2018-10-22T05:47:42.316955Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
|
372
|
+
|
373
|
+
2018-10-22T05:47:42.316962Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
|
374
|
+
|
375
|
+
2018-10-22T05:47:42.316968Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
|
376
|
+
|
377
|
+
2018-10-22T05:47:42.316974Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
|
378
|
+
|
379
|
+
2018-10-22T05:47:42.316980Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
|
380
|
+
|
381
|
+
2018-10-22T05:47:42.316986Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
|
382
|
+
|
383
|
+
2018-10-22T05:47:42.316992Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
|
384
|
+
|
385
|
+
2018-10-22T05:47:42.316998Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
|
386
|
+
|
387
|
+
2018-10-22T05:47:42.317004Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
|
388
|
+
|
389
|
+
2018-10-22T05:47:42.317010Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
|
390
|
+
|
391
|
+
2018-10-22T05:47:42.317016Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
|
392
|
+
|
393
|
+
2018-10-22T05:47:42.317022Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
|
394
|
+
|
395
|
+
2018-10-22T05:47:42.317028Z 0 [Note] Shutting down plugin 'INNODB_CMP'
|
396
|
+
|
397
|
+
2018-10-22T05:47:42.317034Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
|
398
|
+
|
399
|
+
2018-10-22T05:47:42.317040Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
|
400
|
+
|
401
|
+
2018-10-22T05:47:42.317046Z 0 [Note] Shutting down plugin 'INNODB_TRX'
|
402
|
+
|
403
|
+
2018-10-22T05:47:42.317052Z 0 [Note] Shutting down plugin 'InnoDB'
|
404
|
+
|
405
|
+
2018-10-22T05:47:42.317157Z 0 [Note] InnoDB: FTS optimize thread exiting.
|
406
|
+
|
407
|
+
2018-10-22T05:47:42.317275Z 0 [Note] InnoDB: Starting shutdown...
|
408
|
+
|
409
|
+
2018-10-22T05:47:42.419178Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
|
410
|
+
|
411
|
+
2018-10-22T05:47:42.419688Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181022 5:47:42
|
412
|
+
|
413
|
+
2018-10-22T05:47:43.958962Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1210094
|
414
|
+
|
415
|
+
2018-10-22T05:47:43.962226Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
416
|
+
|
417
|
+
2018-10-22T05:47:43.962259Z 0 [Note] Shutting down plugin 'MEMORY'
|
418
|
+
|
419
|
+
2018-10-22T05:47:43.962269Z 0 [Note] Shutting down plugin 'CSV'
|
420
|
+
|
421
|
+
2018-10-22T05:47:43.962279Z 0 [Note] Shutting down plugin 'sha256_password'
|
422
|
+
|
423
|
+
2018-10-22T05:47:43.962294Z 0 [Note] Shutting down plugin 'mysql_native_password'
|
424
|
+
|
425
|
+
2018-10-22T05:47:43.962420Z 0 [Note] Shutting down plugin 'binlog'
|
426
|
+
|
427
|
+
2018-10-22T05:47:43.964954Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
|
428
|
+
|
429
|
+
```
|
430
|
+
|
431
|
+
|
432
|
+
|
433
|
+
|
434
|
+
|
231
435
|
# 参考にしたサイト様
|
232
436
|
|
233
437
|
- [travis上でdockerのmysqlを使ったらCan't connect to MySQL serverと言われてハマった](https://arata.hatenadiary.com/entry/2018/03/08/211114)
|
1
最後の部分書いてなかった
test
CHANGED
File without changes
|
test
CHANGED
@@ -192,6 +192,34 @@
|
|
192
192
|
|
193
193
|
|
194
194
|
|
195
|
+
もしかして、接続ホストをきめないといけないのかと思い、
|
196
|
+
|
197
|
+
|
198
|
+
|
199
|
+
```
|
200
|
+
|
201
|
+
$ mysql -h 127.0.0.1 -u root -P 3306
|
202
|
+
|
203
|
+
```
|
204
|
+
|
205
|
+
|
206
|
+
|
207
|
+
としましたが、
|
208
|
+
|
209
|
+
|
210
|
+
|
211
|
+
```
|
212
|
+
|
213
|
+
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
|
214
|
+
|
215
|
+
```
|
216
|
+
|
217
|
+
|
218
|
+
|
219
|
+
となります。
|
220
|
+
|
221
|
+
|
222
|
+
|
195
223
|
これはどの様に回避するのでしょうか?
|
196
224
|
|
197
225
|
ご存知の方がいらっしゃいましたら、ご教示いただけますと幸いです。
|