Bonjour à tous,

Etant un nouvel utilisateur de mysql, j'ai installé la version 5.6.24 de ce SGBD par le logiciel Apper (Fonctionnant sous Fedora 21). La vesion du noyau est 4.0.4-202.
J'ai décidé de me servir des paramétres par défaut.

Je n'ai eu auncun acces sur aucun compte par la commande mysql -u mysql, meme sous root (Error 2002, Access denied...).

mysqld est activé par 'systemctl enable mysqld.service' et 'systemctl start mysqld.service'

Apres avoir consulté le manuel d'installation, j'ai récupéré sur le site http://dev.mysql.com/downloads/repo/yum le fichier 'mysql-community-release-fc21-6.noarch.rpm'
Je l'ai installé sous root avec la commande 'sudo yum localinstall mysql-community-release-fc21-6.noarch.rpm'
Avec cette configuration, la BDD 'mysql' n'est pas dans la liste des bases accessibles.


Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 
[root@localhost testappli]# 
[root@localhost testappli]# 
[root@localhost testappli]# mysql -u mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.24 MySQL Community Server (GPL)
 
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
 
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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0,00 sec)
 
mysql> 
mysql>
Quelqu'un a-t-il une idée pour que je puisse sortir de ce blocage ?

Merci d'avance pour votre aide.

Gérard SAUVAGE.

P.S Voici les résultats des commandes que j'ai pu lancer sous root :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
 
[root@localhost testappli]# mysql_install_db -> pas de messages d'erreur, qq conseils de configuration de compte. 
[root@localhost testappli]# 
[root@localhost testappli]# 
[root@localhost testappli]# systemctl status mysqld.service
● mysqld.service - MySQL 5.6 database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
   Active: active (running) since ven. 2015-06-12 15:45:30 CEST; 12min ago
  Process: 1807 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
  Process: 1342 ExecStartPost=/usr/libexec/mysql-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 1271 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0/SUCCESS)
  Process: 1171 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
 Main PID: 1339 (mysqld_safe)
   CGroup: /system.slice/mysqld.service
           ├─1339 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─1604 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld.log --pid-f...
 
juin 12 15:45:27 localhost.localdomain mysqld_safe[1339]: 150612 15:45:27 mysqld_safe Logging to '/var/log/mysqld.log'.
juin 12 15:45:27 localhost.localdomain mysqld_safe[1339]: 150612 15:45:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
juin 12 15:45:30 localhost.localdomain mysql-check-upgrade[1807]: The datadir located at /var/lib/mysql needs to be upgraded using 'mysql_upgrade' ... steps:
juin 12 15:45:30 localhost.localdomain mysql-check-upgrade[1807]: 1. Back-up your data before running 'mysql_upgrade'
juin 12 15:45:30 localhost.localdomain mysql-check-upgrade[1807]: 2. Start the database daemon using 'systemctl start mysqld.service'
juin 12 15:45:30 localhost.localdomain mysql-check-upgrade[1807]: 3. Run 'mysql_upgrade' with a database user that has sufficent privileges
juin 12 15:45:30 localhost.localdomain mysql-check-upgrade[1807]: Read more about 'mysql_upgrade' usage at:
juin 12 15:45:30 localhost.localdomain mysql-check-upgrade[1807]: http://dev.mysql.com/doc/refman/5.6/en/mysql-upgrade.html
Hint: Some lines were ellipsized, use -l to show in full.
[root@localhost testappli]# 
[root@localhost testappli]# 
[root@localhost testappli]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed
[root@localhost testappli]# 
[root@localhost testappli]# 
[root@localhost testappli]# cd /usr/share/mysql-test
[root@localhost mysql-test]# perl mysql-test-run
Logging: mysql-test-run  
2015-06-12 16:04:59 0 [Note] /usr/libexec/mysqld (mysqld 5.6.24) starting as process 2911 ...
2015-06-12 16:04:59 2911 [Note] Plugin 'FEDERATED' is disabled.
2015-06-12 16:04:59 2911 [Note] Binlog end
2015-06-12 16:04:59 2911 [Note] Shutting down plugin 'MyISAM'
2015-06-12 16:04:59 2911 [Note] Shutting down plugin 'CSV'
MySQL Version 5.6.24
Checking supported features...
 - SSL connections supported
Using suites: main,sys_vars,binlog,federated,rpl,innodb,innodb_fts,innodb_zip,perfschema,funcs_1,opt_trace,parts,auth_sec
Collecting tests...
 - adding combinations for binlog
^[ - adding combinations for rpl
Checking leftover processes...
Removing old var directory...
Creating var directory '/usr/share/mysql-test/var'...
Installing system database...
 
==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
binlog.binlog_multi_engine               [ skipped ]  ndbcluster disabled
funcs_1.myisam_views-big                 [ skipped ]  Test needs 'big-test' option
main.alter_table-big                     [ skipped ]  Test needs 'big-test' option
main.archive_debug                       [ skipped ]  Test needs debug binaries
main.bug46080                            [ skipped ]  Test needs debug binaries
main.count_distinct3                     [ skipped ]  Test needs 'big-test' option
main.create-big                          [ skipped ]  Test needs 'big-test' option
main.ctype_like_range                    [ skipped ]  Test needs debug binaries
main.drop_debug                          [ skipped ]  Test needs debug binaries
main.ds_mrr-big                          [ skipped ]  Test needs 'big-test' option
main.eq_range_idx_stat                   [ skipped ]  Test needs debug binaries
main.error_simulation                    [ skipped ]  Test needs debug binaries
main.events_stress                       [ skipped ]  Test needs 'big-test' option
main.events_time_zone                    [ skipped ]  Test needs 'big-test' option
main.filesort_debug                      [ skipped ]  Test needs debug binaries
main.flush_read_lock_kill                [ skipped ]  Test needs debug binaries
main.gis-debug                           [ skipped ]  Test needs debug binaries
main.index_merge_innodb                  [ skipped ]  Test needs 'big-test' option
main.information_schema-big              [ skipped ]  Test needs 'big-test' option
main.innodb_mysql_sync                   [ skipped ]  Test needs debug binaries
main.join_cache_bkaunique                [ skipped ]  Test needs debug binaries
main.kill_debug                          [ skipped ]  Test needs debug binaries
main.log_tables_debug                    [ skipped ]  Test needs debug binaries
main.merge-big                           [ skipped ]  Test needs 'big-test' option
main.multi_update2                       [ skipped ]  Test needs 'big-test' option
main.myisam_crash_before_flush_keys      [ skipped ]  Test needs debug binaries
main.myisam_debug                        [ skipped ]  Test needs debug binaries
main.mysqlbinlog_row_big                 [ skipped ]  Test needs 'big-test' option
main.partition_debug_sync                [ skipped ]  Test needs debug binaries
main.partition_sync                      [ skipped ]  Test needs debug binaries
main.signal_code                         [ skipped ]  Test needs debug binaries
main.sp-code                             [ skipped ]  Test needs debug binaries
main.ssl-big                             [ skipped ]  Test needs 'big-test' option
main.subquery_sj_all_bkaunique           [ skipped ]  Test needs debug binaries
main.subquery_sj_dupsweed_bkaunique      [ skipped ]  Test needs debug binaries
main.subquery_sj_firstmatch_bkaunique    [ skipped ]  Test needs debug binaries
main.subquery_sj_innodb_all_bkaunique    [ skipped ]  Test needs debug binaries
main.subquery_sj_innodb_none_bkaunique   [ skipped ]  Test needs debug binaries
main.subquery_sj_loosescan_bkaunique     [ skipped ]  Test needs debug binaries
main.subquery_sj_mat_bkaunique           [ skipped ]  Test needs debug binaries
main.subquery_sj_none_bkaunique          [ skipped ]  Test needs debug binaries
main.subselect_debug                     [ skipped ]  Test needs debug binaries
main.type_newdecimal-big                 [ skipped ]  Test needs 'big-test' option
main.variables-big                       [ skipped ]  Test needs 'big-test' option
main.variables_debug                     [ skipped ]  Test needs debug binaries
sys_vars.debug_basic                     [ skipped ]  Test needs debug binaries
sys_vars.innodb_buf_flush_list_now_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_buffer_pool_evict_basic  [ skipped ]  Test needs debug binaries
sys_vars.innodb_change_buffering_debug_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_disable_background_merge_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_doublewrite_batch_size_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_fil_make_page_dirty_debug_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_force_recovery_crash_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_limit_optimistic_insert_debug_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_log_checkpoint_now_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_page_hash_locks_basic    [ skipped ]  Test needs debug binaries
sys_vars.innodb_purge_run_now_basic      [ skipped ]  Test needs debug binaries
sys_vars.innodb_purge_stop_now_basic     [ skipped ]  Test needs debug binaries
sys_vars.innodb_saved_page_number_debug_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_trx_purge_view_update_only_debug_basic [ skipped ]  Test needs debug binaries
sys_vars.innodb_trx_rseg_n_slots_debug_basic [ skipped ]  Test needs debug binaries
binlog.binlog_crash_safe_master_checksum [ skipped ]  Test needs debug binaries
binlog.binlog_error_action               [ skipped ]  Test needs debug binaries
binlog.binlog_gtid_cache                 [ skipped ]  Test needs debug binaries
binlog.binlog_gtid_errors                [ skipped ]  Test needs debug binaries
binlog.binlog_incident                   [ skipped ]  Test needs debug binaries
binlog.binlog_incident_ignore            [ skipped ]  Test needs debug binaries
binlog.binlog_index                      [ skipped ]  Test needs debug binaries
binlog.binlog_killed_simulate            [ skipped ]  Test needs debug binaries
binlog.binlog_reset_master               [ skipped ]  Test needs debug binaries
binlog.binlog_row_binlog                 [ skipped ]  Test needs debug binaries
binlog.binlog_stm_binlog                 [ skipped ]  Test needs debug binaries
binlog.binlog_write_error                [ skipped ]  Test needs debug binaries
federated.federated_debug                [ skipped ]  Test needs debug binaries
rpl.rpl_binlog_corruption                [ skipped ]  Test needs debug binaries
rpl.rpl_binlog_errors                    [ skipped ]  Test needs debug binaries
rpl.rpl_bug26395                         [ skipped ]  Test needs debug binaries
rpl.rpl_bug33931                         [ skipped ]  Test needs debug binaries
rpl.rpl_bug38694                         [ skipped ]  Test needs debug binaries
rpl.rpl_bug41902                         [ skipped ]  Test needs debug binaries
rpl.rpl_change_master_dbug               [ skipped ]  Test needs debug binaries
rpl.rpl_check_gtid                       [ skipped ]  Test needs 'big-test' option
rpl.rpl_checksum                         [ skipped ]  Test needs debug binaries
rpl.rpl_checksum_undef                   [ skipped ]  Test needs debug binaries
rpl.rpl_corruption                       [ skipped ]  Test needs debug binaries
rpl.rpl_crash_safe_master                [ skipped ]  Test needs debug binaries
rpl.rpl_extra_row_data                   [ skipped ]  Test needs debug binaries
rpl.rpl_filter_warnings                  [ skipped ]  Test needs debug binaries
rpl.rpl_get_master_version_and_clock     [ skipped ]  Test needs debug binaries
rpl.rpl_group_commit_deadlock            [ skipped ]  Test needs 'big-test' option
rpl.rpl_gtid_binlog_errors               [ skipped ]  Test needs debug binaries
rpl.rpl_gtid_execution                   [ skipped ]  Test needs debug binaries
rpl.rpl_gtid_parallel                    [ skipped ]  Test needs 'big-test' option
rpl.rpl_gtid_purged_fail_to_connect      [ skipped ]  Test needs debug binaries
rpl.rpl_gtid_purged_maintained           [ skipped ]  Test needs 'big-test' option
rpl.rpl_gtids_restart_slave_io_lost_trx  [ skipped ]  Test needs debug binaries
rpl.rpl_incident                         [ skipped ]  Test needs debug binaries
rpl.rpl_init_slave_errors                [ skipped ]  Test needs debug binaries
rpl.rpl_killed_ddl                       [ skipped ]  Test needs debug binaries
rpl.rpl_known_bugs_detection             [ skipped ]  Test needs debug binaries
rpl.rpl_loaddata_fatal                   [ skipped ]  Test needs debug binaries
rpl.rpl_lost_events_on_rotate            [ skipped ]  Test needs debug binaries
rpl.rpl_mixed_mixing_engines             [ skipped ]  Test needs 'big-test' option
rpl.rpl_mts_debug                        [ skipped ]  Test needs debug binaries
rpl.rpl_mts_execute_partial_trx_with_auto_pos_off [ skipped ]  Test needs debug binaries
rpl.rpl_mts_execute_partial_trx_with_auto_pos_on [ skipped ]  Test needs debug binaries
rpl.rpl_mts_gtids_restart_slave_io_lost_trx [ skipped ]  Test needs debug binaries
rpl.rpl_mts_slave_hang_with_partial_trx  [ skipped ]  Test needs debug binaries
rpl.rpl_non_direct_mixed_mixing_engines  [ skipped ]  Test needs 'big-test' option
rpl.rpl_non_direct_row_mixing_engines    [ skipped ]  Test needs 'big-test' option
rpl.rpl_non_direct_stm_mixing_engines    [ skipped ]  Test needs 'big-test' option
rpl.rpl_parallel_seconds_behind_master   [ skipped ]  Test needs debug binaries
rpl.rpl_parallel_switch_sequential       [ skipped ]  Test needs 'big-test' option
rpl.rpl_rotate_gtid                      [ skipped ]  Test needs debug binaries
rpl.rpl_rotate_row_trans                 [ skipped ]  Test needs debug binaries
rpl.rpl_row_4_bytes                      [ skipped ]  Test needs debug binaries
rpl.rpl_row_corruption                   [ skipped ]  Test needs debug binaries
rpl.rpl_row_crash_safe                   [ skipped ]  Test needs debug binaries
rpl.rpl_row_hash_scan_sanity             [ skipped ]  Test needs debug binaries
rpl.rpl_row_ignorable_event              [ skipped ]  Test needs debug binaries
rpl.rpl_row_mixing_engines               [ skipped ]  Test needs 'big-test' option
rpl.rpl_row_mts_crash_safe               [ skipped ]  Test needs 'big-test' option
rpl.rpl_row_mts_rec_crash_safe           [ skipped ]  Test needs 'big-test' option
rpl.rpl_row_mysqlbinlog                  [ skipped ]  Test needs 'big-test' option
rpl.rpl_seconds_behind_master            [ skipped ]  Test needs debug binaries
rpl.rpl_semi_sync                        [ skipped ]  Test needs 'big-test' option
rpl.rpl_semi_sync_group_commit_deadlock  [ skipped ]  Test needs 'big-test' option
rpl.rpl_semi_sync_non_group_commit_deadlock [ skipped ]  Test needs 'big-test' option
rpl.rpl_show_slave_running               [ skipped ]  Test needs debug binaries
rpl.rpl_show_slave_status_deadlock       [ skipped ]  Test needs debug binaries
rpl.rpl_skip_incident                    [ skipped ]  Test needs debug binaries
rpl.rpl_slave_load_remove_tmpfile        [ skipped ]  Test needs debug binaries
rpl.rpl_sql_thread_killed_waiting_commit_lock [ skipped ]  Test needs debug binaries
rpl.rpl_stm_mixed_crash_safe             [ skipped ]  Test needs 'big-test' option
rpl.rpl_stm_mixed_mts_crash_safe         [ skipped ]  Test needs 'big-test' option
rpl.rpl_stm_mixed_mts_rec_crash_safe     [ skipped ]  Test needs 'big-test' option
rpl.rpl_stm_mixed_mts_rec_crash_safe_checksum [ skipped ]  Test needs 'big-test' option
rpl.rpl_stm_mixed_mts_rec_crash_safe_small [ skipped ]  Test needs debug binaries
rpl.rpl_stm_mixing_engines               [ skipped ]  Test needs 'big-test' option
rpl.rpl_stm_stop_middle_group            [ skipped ]  Test needs debug binaries
rpl.rpl_stop_slave                       [ skipped ]  Test needs debug binaries
rpl.rpl_sync                             [ skipped ]  Test needs debug binaries
rpl.rpl_temporary_errors                 [ skipped ]  Test needs debug binaries
rpl.rpl_unknown_ignorable_event          [ skipped ]  Test needs debug binaries
innodb.blob-update-debug                 [ skipped ]  Test needs debug binaries
innodb.innodb-2byte-collation            [ skipped ]  Test needs debug binaries
innodb.innodb-alter-debug                [ skipped ]  Test needs debug binaries
innodb.innodb-alter-tempfile             [ skipped ]  Test needs debug binaries
innodb.innodb-change-buffer-recovery     [ skipped ]  Test needs debug binaries
innodb.innodb-double-write               [ skipped ]  Test needs debug binaries
innodb.innodb-index-debug                [ skipped ]  Test needs debug binaries
innodb.innodb-index-online-fk            [ skipped ]  Test needs debug binaries
innodb.innodb-log-file-size              [ skipped ]  Test needs debug binaries
innodb.innodb-multiple-tablespaces       [ skipped ]  Test needs debug binaries
innodb.innodb-status-output              [ skipped ]  Test needs 'big-test' option
innodb.innodb-wl5522-debug               [ skipped ]  Test needs 'big-test' option
innodb.innodb-wl5980-debug               [ skipped ]  Test needs debug binaries
innodb.innodb_bug-13628249               [ skipped ]  Test needs debug binaries
innodb.innodb_bug11754376                [ skipped ]  Test needs debug binaries
innodb.innodb_bug11766634                [ skipped ]  Test needs 'big-test' option
innodb.innodb_bug14007109                [ skipped ]  Test needs debug binaries
innodb.innodb_bug14007649                [ skipped ]  Test needs debug binaries
innodb.innodb_bug14147491                [ skipped ]  Test needs debug binaries
innodb.innodb_bug14676111                [ skipped ]  Test needs debug binaries
innodb.innodb_bug14704286                [ skipped ]  Test needs 'big-test' option
innodb.innodb_bug52663                   [ skipped ]  Test needs 'big-test' option
innodb.innodb_bug53756                   [ skipped ]  Test needs debug binaries
innodb.innodb_bug56947                   [ skipped ]  Test needs debug binaries
innodb.innodb_corrupt_bit                [ skipped ]  Test needs debug binaries
innodb.innodb_mysql                      [ skipped ]  Test needs 'big-test' option
innodb.innodb_upd_stats_if_needed_not_inited [ skipped ]  Test needs debug binaries
innodb.innodb_ut_format_name             [ skipped ]  Test needs debug binaries
innodb.insert_debug                      [ skipped ]  Test needs debug binaries
innodb.monitor_debug                     [ skipped ]  Test needs debug binaries
innodb.sp_temp_table                     [ skipped ]  Test needs 'big-test' option
innodb_fts.fts_compatibility             [ skipped ]  Test needs debug binaries
innodb_fts.fts_compatibility_win         [ skipped ]  Test needs debug binaries
innodb_fts.innobase_drop_fts_index_table [ skipped ]  Test needs debug binaries
innodb_fts.innodb_fts_index_table        [ skipped ]  Test needs debug binaries
innodb_fts.innodb_fts_misc_debug         [ skipped ]  Test needs debug binaries
innodb_fts.innodb_fts_result_cache_limit [ skipped ]  Test needs debug binaries
innodb_zip.innodb-wl5522-debug-zip       [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_addrinfo_again_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_addrinfo_again_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_addrinfo_bad_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_addrinfo_bad_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_addrinfo_good_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_addrinfo_good_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_addrinfo_noname_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_addrinfo_noname_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_auth_plugin    [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_blocked        [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_format         [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_max_con        [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_nameinfo_again_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_nameinfo_again_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_nameinfo_noname_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_nameinfo_noname_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_passwd         [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv4_ssl            [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_addrinfo_again_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_addrinfo_again_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_addrinfo_bad_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_addrinfo_bad_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_addrinfo_good_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_addrinfo_good_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_addrinfo_noname_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_addrinfo_noname_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_auth_plugin    [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_blocked        [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_max_con        [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_nameinfo_again_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_nameinfo_again_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_nameinfo_noname_allow [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_nameinfo_noname_deny [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_passwd         [ skipped ]  Test needs debug binaries
perfschema.hostcache_ipv6_ssl            [ skipped ]  Test needs debug binaries
perfschema.hostcache_peer_addr           [ skipped ]  Test needs debug binaries
perfschema.tampered_perfschema_table1    [ skipped ]  Test needs debug binaries
opt_trace.debug                          [ skipped ]  Test needs debug binaries
opt_trace.eq_range_statistics            [ skipped ]  Test needs debug binaries
parts.part_supported_sql_func_innodb     [ skipped ]  Test needs 'big-test' option
parts.partition_alter1_1_2_innodb        [ skipped ]  Test needs 'big-test' option
parts.partition_alter1_1_innodb          [ skipped ]  Test needs 'big-test' option
parts.partition_alter1_2_innodb          [ skipped ]  Test needs 'big-test' option
parts.partition_alter2_1_1_innodb        [ skipped ]  Test needs 'big-test' option
parts.partition_alter2_1_2_innodb        [ skipped ]  Test needs 'big-test' option
parts.partition_alter2_2_1_innodb        [ skipped ]  Test needs 'big-test' option
parts.partition_alter2_2_2_innodb        [ skipped ]  Test needs 'big-test' option
parts.partition_alter4_innodb            [ skipped ]  Test needs 'big-test' option
parts.partition_alter4_myisam            [ skipped ]  Test needs 'big-test' option
parts.partition_basic_innodb             [ skipped ]  Test needs 'big-test' option
parts.partition_debug                    [ skipped ]  Test needs debug binaries
parts.partition_debug_innodb             [ skipped ]  Test needs 'big-test' option
parts.partition_debug_myisam             [ skipped ]  Test needs 'big-test' option
parts.partition_decimal_myisam           [ skipped ]  Test needs 'big-test' option
parts.partition_int_myisam               [ skipped ]  Test needs 'big-test' option
parts.rpl_partition                      [ skipped ]  Test needs 'big-test' option
main.archive-big                         [ disabled ]  Bug#11817185 2011-03-10 Anitha Disabled since this leads to timeout on Solaris Sparc
main.log_tables-big                      [ disabled ]  Bug#11756699 2010-11-15 mattiasj report already exists
main.lowercase_table3                    [ disabled ]  Bug#11762269 2010-06-30 alik main.lowercase_table3 on Mac OSX
main.mysql_client_test_embedded          [ disabled ]  Bug#16084066 2013-01-08 Disabled since this test is failing
main.mysql_embedded_client_test          [ disabled ]  Bug#13964673 2012-04-16 amitbha since most of the test cases are failing
main.read_many_rows_innodb               [ disabled ]  Bug#11748886 2010-11-15 mattiasj report already exists
main.sum_distinct-big                    [ disabled ]  Bug#11764126 2010-11-15 mattiasj was not tested
sys_vars.query_cache_size_basic_32       [ disabled ]  Bug#13535584
sys_vars.query_cache_size_basic_64       [ disabled ]  Bug#11748572
federated.federated_transactions         [ disabled ]  Bug#11746899 Transactions do not work
rpl.rpl_delayed_slave                    [ disabled ]  Bug#11764654 2010-11-09 andrei rpl_delayed_slave fails sporadically in pb
rpl.rpl_row_binlog_max_cache_size        [ disabled ]  BUG#14126780 May 29 2012 Vasil Dimov timeout if est number of rows is 3 instead of 4
rpl.rpl_row_create_table                 [ disabled ]  Bug#11759274 2010-02-27 andrei failed different way than earlier with bug#45576
parts.partition_max_parts_hash_innodb    [ disabled ]  Bug#17719504 2013-11-01 Horst PARTITION_MAX_PARTS ARE FAILING SPORADICLY.
parts.partition_max_parts_inv_innodb     [ disabled ]  Bug#17719504 2013-11-01 Horst PARTITION_MAX_PARTS ARE FAILING SPORADICLY.
parts.partition_max_parts_key_innodb     [ disabled ]  Bug#17719504 2013-11-01 Horst PARTITION_MAX_PARTS ARE FAILING SPORADICLY.
parts.partition_max_parts_list_innodb    [ disabled ]  Bug#17719504 2013-11-01 Horst PARTITION_MAX_PARTS ARE FAILING SPORADICLY.
parts.partition_max_parts_range_innodb   [ disabled ]  Bug#17719504 2013-11-01 Horst PARTITION_MAX_PARTS ARE FAILING SPORADICLY.
parts.partition_max_sub_parts_key_list_innodb [ disabled ]  Bug#17719504 2013-11-01 Horst PARTITION_MAX_PARTS ARE FAILING SPORADICLY.
parts.partition_max_sub_parts_key_range_innodb [ disabled ]  Bug#17719504 2013-11-01 Horst PARTITION_MAX_PARTS ARE FAILING SPORADICLY.
parts.partition_max_sub_parts_list_innodb [ disabled ]  Bug#17719504 2013-11-01 Horst PARTITION_MAX_PARTS ARE FAILING SPORADICLY.
parts.partition_max_sub_parts_range_innodb [ disabled ]  Bug#17719504 2013-11-01 Horst PARTITION_MAX_PARTS ARE FAILING SPORADICLY.
federated.federated                      [ pass ]   5237
federated.federated_archive              [ pass ]    154
federated.federated_bug_13118            [ pass ]     82
federated.federated_bug_25714            [ skipped ]  Need bug25714 test program
federated.federated_bug_35333            [ pass ]    128
federated.federated_server               [ pass ]   8700
federated.federated_plugin               [ skipped ]  federated plugin not available
federated.federated_innodb               [ pass ]   1044
perfschema.cnf_option                    [ pass ]     13
perfschema.sizing_default                [ pass ]     32
perfschema.sizing_high                   [ pass ]      8
perfschema.sizing_low                    [ pass ]      8
perfschema.sizing_med                    [ pass ]      9
perfschema.sizing_off                    [ pass ]      5
rpl.rpl_plugin_load 'mix'                [ skipped ]  Example plugin requires the environment variable \$EXAMPLE_PLUGIN to be set (normally done by mtr)
rpl.rpl_plugin_load 'row'                [ skipped ]  Example plugin requires the environment variable \$EXAMPLE_PLUGIN to be set (normally done by mtr)
rpl.rpl_plugin_load 'stmt'               [ skipped ]  Example plugin requires the environment variable \$EXAMPLE_PLUGIN to be set (normally done by mtr)
rpl.rpl_grant_plugin 'mix'               [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_master_connection 'mix'          [ pass ]  16453
rpl.rpl_grant_plugin 'row'               [ pass ]   1987
rpl.rpl_master_connection 'row'          [ pass ]  15815
rpl.rpl_grant_plugin 'stmt'              [ skipped ]  Doesn't support --binlog-format='statement'
rpl.rpl_master_connection 'stmt'         [ pass ]  16262
rpl.rpl_semi_sync_deadlock 'mix'         [ skipped ]  Test requires: 'have_debug_sync'
rpl.rpl_semi_sync_future_logpos 'mix'    [ pass ]  13190
rpl.rpl_semi_sync_shutdown_hang 'mix'    [ pass ]  16642
rpl.rpl_semi_sync_uninstall_plugin 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_semi_sync_event 'mix'            [ pass ]  14158
rpl.rpl_semi_sync_deadlock 'row'         [ skipped ]  Test requires: 'have_debug_sync'
rpl.rpl_semi_sync_future_logpos 'row'    [ pass ]  13036
rpl.rpl_semi_sync_shutdown_hang 'row'    [ skipped ]  Doesn't support --binlog-format='row'
rpl.rpl_semi_sync_uninstall_plugin 'row' [ skipped ]  Doesn't support --binlog-format='row'
rpl.rpl_semi_sync_event 'row'            [ pass ]  14309
rpl.rpl_semi_sync_deadlock 'stmt'        [ skipped ]  Test requires: 'have_debug_sync'
rpl.rpl_semi_sync_future_logpos 'stmt'   [ pass ]  13060
rpl.rpl_semi_sync_shutdown_hang 'stmt'   [ skipped ]  Doesn't support --binlog-format='statement'
rpl.rpl_semi_sync_uninstall_plugin 'stmt' [ pass ]   2436
rpl.rpl_semi_sync_event 'stmt'           [ pass ]  24135
rpl.rpl_udf 'mix'                        [ skipped ]  UDF requires the environment variable \$UDF_EXAMPLE_LIB to be set (normally done by mtr)
rpl.rpl_mixed_implicit_commit_binlog 'mix' [ skipped ]  UDF requires the environment variable \$UDF_EXAMPLE_LIB to be set (normally done by mtr)
rpl.rpl_row_implicit_commit_binlog 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_stm_implicit_commit_binlog 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_udf 'row'                        [ skipped ]  UDF requires the environment variable \$UDF_EXAMPLE_LIB to be set (normally done by mtr)
rpl.rpl_mixed_implicit_commit_binlog 'row' [ skipped ]  Doesn't support --binlog-format='row'
rpl.rpl_row_implicit_commit_binlog 'row' [ skipped ]  UDF requires the environment variable \$UDF_EXAMPLE_LIB to be set (normally done by mtr)
rpl.rpl_stm_implicit_commit_binlog 'row' [ skipped ]  Doesn't support --binlog-format='row'
rpl.rpl_udf 'stmt'                       [ skipped ]  UDF requires the environment variable \$UDF_EXAMPLE_LIB to be set (normally done by mtr)
rpl.rpl_mixed_implicit_commit_binlog 'stmt' [ skipped ]  Doesn't support --binlog-format='statement'
rpl.rpl_row_implicit_commit_binlog 'stmt' [ skipped ]  Doesn't support --binlog-format='statement'
rpl.rpl_stm_implicit_commit_binlog 'stmt' [ skipped ]  UDF requires the environment variable \$UDF_EXAMPLE_LIB to be set (normally done by mtr)
rpl.rpl_mix_found_rows 'mix'             [ pass ]   2534
rpl.rpl_row_sp011 'mix'                  [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_switch_stm_row_mixed 'mix'       [ pass ]   3633
rpl.rpl_insert_id 'mix'                  [ pass ]   3882
rpl.rpl_mix_found_rows 'row'             [ skipped ]  Doesn't support --binlog-format='row'
rpl.rpl_row_sp011 'row'                  [ pass ]   2642
rpl.rpl_switch_stm_row_mixed 'row'       [ pass ]   3688
rpl.rpl_insert_id 'row'                  [ pass ]   3953
rpl.rpl_mix_found_rows 'stmt'            [ skipped ]  Doesn't support --binlog-format='statement'
rpl.rpl_row_sp011 'stmt'                 [ skipped ]  Doesn't support --binlog-format='statement'
rpl.rpl_switch_stm_row_mixed 'stmt'      [ skipped ]  Doesn't support --binlog-format='statement'
rpl.rpl_insert_id 'stmt'                 [ pass ]   4023
rpl.rpl_auto_increment 'mix'             [ pass ]  12516
rpl.rpl_auto_increment 'row'             [ pass ]  12693
rpl.rpl_auto_increment 'stmt'            [ pass ]  13063
rpl.rpl_create_database 'mix'            [ pass ]   2158
rpl.rpl_create_database 'row'            [ pass ]   2201
rpl.rpl_create_database 'stmt'           [ pass ]   2263
rpl.rpl_begin_commit_rollback 'mix'      [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_binlog_gcommit_options 'mix'     [ pass ]  13974
rpl.rpl_gtid_row_event_max_size 'mix'    [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_row_event_max_size 'mix'         [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_loaddata_m 'mix'                 [ pass ]   2080
rpl.rpl_row_basic_11bugs 'mix'           [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_special_charset 'mix'            [ pass ]   2089
rpl.rpl_timezone 'mix'                   [ pass ]   2995
rpl.rpl_server_id2 'mix'                 [ pass ]   3647
rpl.rpl_server_id_ignore 'mix'           [ pass ]   4104
rpl.rpl_flush_logs 'mix'                 [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_parallel_multi_db 'mix'          [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_sequential 'mix'                 [ pass ]  96608
rpl.rpl_parallel 'mix'                   [ pass ]  93312
rpl.rpl_parallel_innodb 'mix'            [ pass ]  143314
rpl.rpl_sp 'mix'                         [ pass ]   5675
rpl.rpl_do_table_filter_sensitive 'mix'  [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_gtid_do_table_filter_sensitive 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_gtid_ignore_table_filter_sensitive 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_ignore_table_filter_sensitive 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_do_table_filter_insensitive 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_gtid_do_table_filter_insensitive 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_gtid_ignore_table_filter_insensitive 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_ignore_table_filter_insensitive 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_ignore_db_filter 'mix'           [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_rewrite_db_filter 'mix'          [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_show_master_info_file 'mix'      [ pass ]   1840
rpl.rpl_sporadic_master 'mix'            [ pass ]   3316
rpl.rpl_packet 'mix'                     [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_loaddata_map 'mix'               [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_flushlog_loop 'mix'              [ pass ]   3522
rpl.rpl_cross_version 'mix'              [ pass ]   3061
rpl.rpl_loaddata_symlink 'mix'           [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_row_log 'mix'                    [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_gtid_loaddata_s 'mix'            [ skipped ]  Test requires GTID_MODE=ON.
rpl.rpl_loaddata_s 'mix'                 [ pass ]   2014
rpl.rpl_heartbeat 'mix'                  [ pass ]  18666
rpl.rpl_report_port 'mix'                [ pass ]  13348
rpl.rpl_000011 'mix'                     [ pass ]   1954
rpl.rpl_000013 'mix'                     [ pass ]   1542
rpl.rpl_000017 'mix'                     [ pass ]   1567
rpl.rpl_4threads_deadlock 'mix'          [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_EE_err 'mix'                     [ pass ]   1959
rpl.rpl_LD_INFILE 'mix'                  [ pass ]   1618
rpl.rpl_alter 'mix'                      [ pass ]   1578
rpl.rpl_alter_db 'mix'                   [ pass ]   1475
rpl.rpl_apply_binlog_with_anonymous_gtid 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_apply_binlog_with_anonymous_gtid_when_gtid_mode_on 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_apply_binlog_with_gtid_when_gtid_mode_off 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_auto_increment_11932 'mix'       [ pass ]   1609
rpl.rpl_auto_increment_bug33029 'mix'    [ pass ]   2405
rpl.rpl_avoid_temporal_upgrade 'mix'     [ pass ]   2245
rpl.rpl_binlog_index 'mix'               [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_bit 'mix'                        [ pass ]   1629
rpl.rpl_bit_npk 'mix'                    [ pass ]   1746
rpl.rpl_blackhole 'mix'                  [ pass ]   1937
rpl.rpl_bug31076 'mix'                   [ pass ]   1673
rpl.rpl_bug37426 'mix'                   [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_change_master 'mix'              [ pass ]  27001
rpl.rpl_charset 'mix'                    [ pass ]   1845
rpl.rpl_charset_sjis 'mix'               [ pass ]   1589
rpl.rpl_colSize 'mix'                    [ pass ]   3266
rpl.rpl_conditional_comments 'mix'       [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_connection 'mix'                 [ pass ]   2235
rpl.rpl_create_drop_temp_table 'mix'     [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_create_if_not_exists 'mix'       [ pass ]   3878
rpl.rpl_create_tmp_table_if_not_exists 'mix' [ pass ]   1484
rpl.rpl_critical_errors 'mix'            [ pass ]      1
rpl.rpl_delete_no_where 'mix'            [ pass ]   1575
rpl.rpl_do_grant 'mix'                   [ pass ]   7790
rpl.rpl_drop 'mix'                       [ pass ]   1470
rpl.rpl_drop_db 'mix'                    [ pass ]   3914
rpl.rpl_drop_db_fail 'mix'               [ pass ]   3987
rpl.rpl_drop_view 'mix'                  [ pass ]   2027
rpl.rpl_empty_master_host 'mix'          [ pass ]   2203
rpl.rpl_events 'mix'                     [ pass ]   1813
rpl.rpl_extra_col_master_myisam 'mix'    [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_extra_col_slave_myisam 'mix'     [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_function_defaults 'mix'          [ pass ]   1626
rpl.rpl_general_log 'mix'                [ pass ]   2604
rpl.rpl_geometry 'mix'                   [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_get_lock 'mix'                   [ pass ]   2178
rpl.rpl_grant 'mix'                      [ pass ]   6952
rpl.rpl_gtid_binary_log_as_relay_log 'mix' [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_gtid_mode 'mix'                  [ fail ]
        Test ended at 2015-06-12 16:23:51
 
CURRENT_TEST: rpl.rpl_gtid_mode
mysqltest: In included file "./include/assert_command_output.inc": 
included from ./include/assert_command_output.inc at line 68:
At line 67: command "file_exists" failed with error 1. my_errno=175
 
The result from queries just before the failure was:
< snip >
==== Checks performed at server start when GTID_MODE = ON ====
include/rpl_stop_server.inc [server_number=2]
---- GTID_MODE = UPGRADE_STEP_[1|2] not supported ----
include/assert_command_output.inc
ERROR: Command produced wrong output!
ERROR: Command: '/usr/libexec/mysqld --defaults-group-suffix=.2 --defaults-file=/usr/share/mysql-test/var/my.cnf --log-output=file --default-storage-engine=InnoDB --default-tmp-storage-engine=InnoDB --innodb-page-size=16384 --gtid-mode=upgrade_step_1 --enforce-gtid-consistency 2>&1'
ERROR: Output expected to match perl regex: '--gtid-mode=UPGRADE_STEP_1 or --gtid-mode=UPGRADE_STEP_2 are not yet supported'
======== BEGIN output ========
2015-06-12 17:23:46 0 [Warning] The syntax '--master-retry-count' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER TO master_retry_count = <num>' instead.
2015-06-12 17:23:46 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-06-12 17:23:46 0 [Note] /usr/libexec/mysqld (mysqld 5.6.24-log) starting as process 8010 ...
2015-06-12 17:23:46 8010 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
 
2015-06-12 17:23:46 8010 [ERROR] Aborting
 
2015-06-12 17:23:46 8010 [Note] Binlog end
2015-06-12 17:23:46 8010 [Note] /usr/libexec/mysqld: Shutdown complete
 
 
======== END OUTPUT ========
 
More results from queries before failure can be found in /usr/share/mysql-test/var/log/rpl_gtid_mode.log
 
 - saving '/usr/share/mysql-test/var/log/rpl.rpl_gtid_mode-mix/' to '/usr/share/mysql-test/var/log/rpl.rpl_gtid_mode-mix/'
 
Only  413  of 3642 completed.
mysql-test-run: *** ERROR: Not all tests completed
[root@localhost testappli]# 
[root@localhost testappli]#
Voici l'arborescence complète des données :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
 
[root@localhost testappli]# 
[root@localhost testappli]# 
[root@localhost testappli]# ls -lR /var/lib/mysql 
/var/lib/mysql:
total 110604
-rw-rw----. 1 mysql mysql       56  9 juin  18:52 auto.cnf
-rwx------. 1 mysql mysql 12582912 12 juin  15:45 ibdata1
-rwx------. 1 mysql mysql 50331648 12 juin  15:45 ib_logfile0
-rwx------. 1 mysql mysql 50331648 10 févr. 17:12 ib_logfile1
drwx------. 2 mysql mysql     4096 10 févr. 17:12 mysql
srwxrwxrwx. 1 mysql mysql        0 12 juin  15:45 mysql.sock
drwx------. 2 mysql mysql     4096 11 juin  12:42 performance_schema
 
/var/lib/mysql/mysql:
total 1632
-rwx------. 1 mysql mysql   8820 10 févr. 17:12 columns_priv.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 columns_priv.MYD
-rwx------. 1 mysql mysql   4096 10 févr. 17:12 columns_priv.MYI
-rwx------. 1 mysql mysql   9582 10 févr. 17:12 db.frm
-rwx------. 1 mysql mysql    880 10 févr. 17:12 db.MYD
-rwx------. 1 mysql mysql   5120 10 févr. 17:12 db.MYI
-rwx------. 1 mysql mysql  10223 10 févr. 17:12 event.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 event.MYD
-rwx------. 1 mysql mysql   2048 10 févr. 17:12 event.MYI
-rwx------. 1 mysql mysql   8665 10 févr. 17:12 func.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 func.MYD
-rwx------. 1 mysql mysql   1024 10 févr. 17:12 func.MYI
-rwx------. 1 mysql mysql     35 11 juin  12:42 general_log.CSM
-rwx------. 1 mysql mysql      0 10 févr. 17:12 general_log.CSV
-rwx------. 1 mysql mysql   8776 10 févr. 17:12 general_log.frm
-rwx------. 1 mysql mysql   8700 10 févr. 17:12 help_category.frm
-rwx------. 1 mysql mysql   1120 11 juin  12:42 help_category.MYD
-rwx------. 1 mysql mysql   3072 11 juin  12:42 help_category.MYI
-rwx------. 1 mysql mysql   8612 10 févr. 17:12 help_keyword.frm
-rwx------. 1 mysql mysql  98303 11 juin  12:42 help_keyword.MYD
-rwx------. 1 mysql mysql  19456 11 juin  12:42 help_keyword.MYI
-rwx------. 1 mysql mysql   8630 10 févr. 17:12 help_relation.frm
-rwx------. 1 mysql mysql   9963 11 juin  12:42 help_relation.MYD                                                                                            
-rwx------. 1 mysql mysql  18432 11 juin  12:42 help_relation.MYI
-rwx------. 1 mysql mysql   8770 10 févr. 17:12 help_topic.frm
-rwx------. 1 mysql mysql 551444 11 juin  12:42 help_topic.MYD
-rwx------. 1 mysql mysql  20480 11 juin  12:42 help_topic.MYI
-rwx------. 1 mysql mysql  12982 10 févr. 17:12 innodb_index_stats.frm
-rwx------. 1 mysql mysql  98304 10 févr. 17:12 innodb_index_stats.ibd
-rwx------. 1 mysql mysql   8830 10 févr. 17:12 innodb_table_stats.frm
-rwx------. 1 mysql mysql  98304 10 févr. 17:12 innodb_table_stats.ibd
-rwx------. 1 mysql mysql   8898 10 févr. 17:12 ndb_binlog_index.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 ndb_binlog_index.MYD
-rwx------. 1 mysql mysql   1024 10 févr. 17:12 ndb_binlog_index.MYI
-rwx------. 1 mysql mysql   8586 10 févr. 17:12 plugin.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 plugin.MYD
-rwx------. 1 mysql mysql   1024 10 févr. 17:12 plugin.MYI
-rwx------. 1 mysql mysql   9996 10 févr. 17:12 proc.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 proc.MYD
-rwx------. 1 mysql mysql   2048 10 févr. 17:12 proc.MYI
-rwx------. 1 mysql mysql   8875 10 févr. 17:12 procs_priv.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 procs_priv.MYD
-rwx------. 1 mysql mysql   4096 10 févr. 17:12 procs_priv.MYI
-rwx------. 1 mysql mysql   8800 10 févr. 17:12 proxies_priv.frm
-rwx------. 1 mysql mysql   1386 10 févr. 17:12 proxies_priv.MYD
-rwx------. 1 mysql mysql   5120 10 févr. 17:12 proxies_priv.MYI
-rwx------. 1 mysql mysql   8838 10 févr. 17:12 servers.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 servers.MYD
-rwx------. 1 mysql mysql   1024 10 févr. 17:12 servers.MYI
-rwx------. 1 mysql mysql  10719 10 févr. 17:12 slave_master_info.frm
-rwx------. 1 mysql mysql  98304 10 févr. 17:12 slave_master_info.ibd
-rwx------. 1 mysql mysql   9334 10 févr. 17:12 slave_relay_log_info.frm
-rwx------. 1 mysql mysql  98304 10 févr. 17:12 slave_relay_log_info.ibd
-rwx------. 1 mysql mysql   9230 10 févr. 17:12 slave_worker_info.frm
-rwx------. 1 mysql mysql  98304 10 févr. 17:12 slave_worker_info.ibd
-rwx------. 1 mysql mysql     35 11 juin  12:42 slow_log.CSM
-rwx------. 1 mysql mysql      0 10 févr. 17:12 slow_log.CSV
-rwx------. 1 mysql mysql   9016 10 févr. 17:12 slow_log.frm
-rwx------. 1 mysql mysql   8955 10 févr. 17:12 tables_priv.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 tables_priv.MYD
-rwx------. 1 mysql mysql   4096 10 févr. 17:12 tables_priv.MYI
-rwx------. 1 mysql mysql   8636 10 févr. 17:12 time_zone.frm
-rwx------. 1 mysql mysql   8624 10 févr. 17:12 time_zone_leap_second.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 time_zone_leap_second.MYD
-rwx------. 1 mysql mysql   1024 10 févr. 17:12 time_zone_leap_second.MYI
-rwx------. 1 mysql mysql      0 10 févr. 17:12 time_zone.MYD
-rwx------. 1 mysql mysql   1024 10 févr. 17:12 time_zone.MYI
-rwx------. 1 mysql mysql   8606 10 févr. 17:12 time_zone_name.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 time_zone_name.MYD
-rwx------. 1 mysql mysql   1024 10 févr. 17:12 time_zone_name.MYI
-rwx------. 1 mysql mysql   8686 10 févr. 17:12 time_zone_transition.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 time_zone_transition.MYD
-rwx------. 1 mysql mysql   1024 10 févr. 17:12 time_zone_transition.MYI
-rwx------. 1 mysql mysql   8748 10 févr. 17:12 time_zone_transition_type.frm
-rwx------. 1 mysql mysql      0 10 févr. 17:12 time_zone_transition_type.MYD
-rwx------. 1 mysql mysql   1024 10 févr. 17:12 time_zone_transition_type.MYI
-rwx------. 1 mysql mysql  10684 10 févr. 17:12 user.frm
-rwx------. 1 mysql mysql    396 11 juin  12:40 user.MYD
-rwx------. 1 mysql mysql   2048 11 juin  12:42 user.MYI
 
/var/lib/mysql/performance_schema:
total 632
-rw-rw----. 1 mysql mysql  8706 11 juin  12:42 accounts.frm
-rw-rw----. 1 mysql mysql  8624 11 juin  12:42 cond_instances.frm
-rw-rw----. 1 mysql mysql    61 11 juin  12:42 db.opt
-rw-rw----. 1 mysql mysql  8991 11 juin  12:42 events_stages_current.frm
-rw-rw----. 1 mysql mysql  8991 11 juin  12:42 events_stages_history.frm
-rw-rw----. 1 mysql mysql  8991 11 juin  12:42 events_stages_history_long.frm
-rw-rw----. 1 mysql mysql  8874 11 juin  12:42 events_stages_summary_by_account_by_event_name.frm
-rw-rw----. 1 mysql mysql  8844 11 juin  12:42 events_stages_summary_by_host_by_event_name.frm
-rw-rw----. 1 mysql mysql  8854 11 juin  12:42 events_stages_summary_by_thread_by_event_name.frm
-rw-rw----. 1 mysql mysql  8844 11 juin  12:42 events_stages_summary_by_user_by_event_name.frm
-rw-rw----. 1 mysql mysql  8814 11 juin  12:42 events_stages_summary_global_by_event_name.frm
-rw-rw----. 1 mysql mysql 10525 11 juin  12:42 events_statements_current.frm
-rw-rw----. 1 mysql mysql 10525 11 juin  12:42 events_statements_history.frm
-rw-rw----. 1 mysql mysql 10525 11 juin  12:42 events_statements_history_long.frm
-rw-rw----. 1 mysql mysql 10000 11 juin  12:42 events_statements_summary_by_account_by_event_name.frm
-rw-rw----. 1 mysql mysql 10102 11 juin  12:42 events_statements_summary_by_digest.frm
-rw-rw----. 1 mysql mysql  9970 11 juin  12:42 events_statements_summary_by_host_by_event_name.frm
-rw-rw----. 1 mysql mysql  9980 11 juin  12:42 events_statements_summary_by_thread_by_event_name.frm
-rw-rw----. 1 mysql mysql  9970 11 juin  12:42 events_statements_summary_by_user_by_event_name.frm
-rw-rw----. 1 mysql mysql  9940 11 juin  12:42 events_statements_summary_global_by_event_name.frm
-rw-rw----. 1 mysql mysql  9389 11 juin  12:42 events_waits_current.frm
-rw-rw----. 1 mysql mysql  9389 11 juin  12:42 events_waits_history.frm
-rw-rw----. 1 mysql mysql  9389 11 juin  12:42 events_waits_history_long.frm
-rw-rw----. 1 mysql mysql  8874 11 juin  12:42 events_waits_summary_by_account_by_event_name.frm
-rw-rw----. 1 mysql mysql  8844 11 juin  12:42 events_waits_summary_by_host_by_event_name.frm
-rw-rw----. 1 mysql mysql  8878 11 juin  12:42 events_waits_summary_by_instance.frm
-rw-rw----. 1 mysql mysql  8854 11 juin  12:42 events_waits_summary_by_thread_by_event_name.frm
-rw-rw----. 1 mysql mysql  8844 11 juin  12:42 events_waits_summary_by_user_by_event_name.frm
-rw-rw----. 1 mysql mysql  8814 11 juin  12:42 events_waits_summary_global_by_event_name.frm
-rw-rw----. 1 mysql mysql  8654 11 juin  12:42 file_instances.frm
-rw-rw----. 1 mysql mysql  9740 11 juin  12:42 file_summary_by_event_name.frm
-rw-rw----. 1 mysql mysql  9844 11 juin  12:42 file_summary_by_instance.frm
-rw-rw----. 1 mysql mysql 10483 11 juin  12:42 host_cache.frm
-rw-rw----. 1 mysql mysql  8676 11 juin  12:42 hosts.frm
-rw-rw----. 1 mysql mysql  8684 11 juin  12:42 mutex_instances.frm
-rw-rw----. 1 mysql mysql  8908 11 juin  12:42 objects_summary_global_by_type.frm
-rw-rw----. 1 mysql mysql  8776 11 juin  12:42 performance_timers.frm
-rw-rw----. 1 mysql mysql  8758 11 juin  12:42 rwlock_instances.frm
-rw-rw----. 1 mysql mysql  8716 11 juin  12:42 session_account_connect_attrs.frm
-rw-rw----. 1 mysql mysql  8716 11 juin  12:42 session_connect_attrs.frm
-rw-rw----. 1 mysql mysql  8620 11 juin  12:42 setup_actors.frm
-rw-rw----. 1 mysql mysql  8605 11 juin  12:42 setup_consumers.frm
-rw-rw----. 1 mysql mysql  8637 11 juin  12:42 setup_instruments.frm
-rw-rw----. 1 mysql mysql  8751 11 juin  12:42 setup_objects.frm
-rw-rw----. 1 mysql mysql  8650 11 juin  12:42 setup_timers.frm
-rw-rw----. 1 mysql mysql  8818 11 juin  12:42 socket_instances.frm
-rw-rw----. 1 mysql mysql  9740 11 juin  12:42 socket_summary_by_event_name.frm
-rw-rw----. 1 mysql mysql  9804 11 juin  12:42 socket_summary_by_instance.frm
-rw-rw----. 1 mysql mysql 10578 11 juin  12:42 table_io_waits_summary_by_index_usage.frm
-rw-rw----. 1 mysql mysql 10488 11 juin  12:42 table_io_waits_summary_by_table.frm
-rw-rw----. 1 mysql mysql 13518 11 juin  12:42 table_lock_waits_summary_by_table.frm
-rw-rw----. 1 mysql mysql  9201 11 juin  12:42 threads.frm
-rw-rw----. 1 mysql mysql  8676 11 juin  12:42 users.frm
[root@localhost testappli]# 
[root@localhost testappli]#
Résultats de la commande netstat -ln :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
 
[root@localhost testappli]# 
[root@localhost testappli]# 
[root@localhost testappli]# netstat -ln
Connexions Internet actives (seulement serveurs)
Proto Recv-Q Send-Q Adresse locale          Adresse distante        Etat       
tcp        0      0 0.0.0.0:1714            0.0.0.0:*               LISTEN     
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN     
tcp        0      0 192.168.0.11:5060       0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:5060          0.0.0.0:*               LISTEN     
tcp6       0      0 :::3306                 :::*                    LISTEN     
udp        0      0 192.168.0.11:5060       0.0.0.0:*                          
udp        0      0 127.0.0.1:5060          0.0.0.0:*                          
udp        0      0 0.0.0.0:5353            0.0.0.0:*                          
udp        0      0 0.0.0.0:58920           0.0.0.0:*                          
udp        0      0 0.0.0.0:58958           0.0.0.0:*                          
udp        0      0 0.0.0.0:1714            0.0.0.0:*                          
udp        0      0 192.168.122.1:53        0.0.0.0:*                          
udp        0      0 0.0.0.0:67              0.0.0.0:*                          
udp        0      0 0.0.0.0:68              0.0.0.0:*                          
udp        0      0 0.0.0.0:123             0.0.0.0:*                          
udp        0      0 127.0.0.1:323           0.0.0.0:*                          
udp        0      0 0.0.0.0:29101           0.0.0.0:*                          
udp6       0      0 :::123                  :::*                               
udp6       0      0 ::1:323                 :::*                               
udp6       0      0 :::4827                 :::*                               
raw6       0      0 :::58                   :::*                    7          
Sockets du domaine UNIX actives(seulement serveurs)
Proto RefCnt Flags       Type       State         I-Node   Chemin
unix  2      [ ACC ]     STREAM     LISTENING     27726    @/tmp/.ICE-unix/2115
unix  2      [ ACC ]     STREAM     LISTENING     21761    /tmp/.s.PGSQL.5432
unix  2      [ ACC ]     STREAM     LISTENING     15111    /run/gssproxy.sock
unix  2      [ ACC ]     STREAM     LISTENING     22544    /var/run/libvirt/libvirt-sock
unix  2      [ ACC ]     STREAM     LISTENING     20026    @/tmp/dbus-nDBLH0SK
unix  2      [ ACC ]     STREAM     LISTENING     22547    /var/run/libvirt/libvirt-sock-ro
unix  2      [ ACC ]     STREAM     LISTENING     26136    /tmp/ssh-c2S26VlgMpUr/agent.1973
unix  2      [ ACC ]     STREAM     LISTENING     15110    /var/lib/gssproxy/default.sock
unix  2      [ ACC ]     STREAM     LISTENING     16413    /var/run/cups/cups.sock
unix  2      [ ACC ]     STREAM     LISTENING     20556    @/tmp/.X11-unix/X0
unix  2      [ ACC ]     STREAM     LISTENING     25891    /run/user/1001/systemd/private                                                                    
unix  2      [ ACC ]     STREAM     LISTENING     16422    /var/run/avahi-daemon/socket
unix  2      [ ACC ]     STREAM     LISTENING     25144    /run/user/1001/ksocket-testappli/kdeinit4__0
unix  2      [ ACC ]     STREAM     LISTENING     16448    /var/run/rpcbind.sock
unix  2      [ ACC ]     STREAM     LISTENING     11329    /run/systemd/journal/stdout
unix  2      [ ACC ]     STREAM     LISTENING     15171    /var/run/mcelog-client
unix  2      [ ACC ]     STREAM     LISTENING     13385    /run/systemd/private
unix  2      [ ACC ]     STREAM     LISTENING     16434    @ISCSID_UIP_ABSTRACT_NAMESPACE
unix  2      [ ACC ]     STREAM     LISTENING     20557    /tmp/.X11-unix/X0
unix  2      [ ACC ]     STREAM     LISTENING     16457    /var/run/dbus/system_bus_socket
unix  2      [ ACC ]     STREAM     LISTENING     27727    /tmp/.ICE-unix/2115
unix  2      [ ACC ]     STREAM     LISTENING     18020    /var/run/NetworkManager/private-dhcp
unix  2      [ ACC ]     STREAM     LISTENING     15226    /var/run/abrt/abrt.socket
unix  2      [ ACC ]     SEQPACKET  LISTENING     13435    /run/udev/control
unix  2      [ ACC ]     STREAM     LISTENING     13445    /run/lvm/lvmetad.socket
unix  2      [ ACC ]     STREAM     LISTENING     20025    @/tmp/dbus-ovgH7a4s
unix  2      [ ACC ]     STREAM     LISTENING     26990    @/tmp/dbus-qLBW3OAlei
unix  2      [ ACC ]     STREAM     LISTENING     16441    @ISCSIADM_ABSTRACT_NAMESPACE
unix  2      [ ACC ]     STREAM     LISTENING     25512    @/tmp/dbus-2sZSUYbPx8
unix  2      [ ACC ]     STREAM     LISTENING     27094    /run/user/1001/ksocket-testappli/klauncherhX2084.slave-socket
unix  2      [ ACC ]     STREAM     LISTENING     23699    /var/lib/mysql/mysql.sock
unix  2      [ ACC ]     STREAM     LISTENING     26487    @/tmp/fam-testappli-
unix  2      [ ACC ]     STREAM     LISTENING     18914    /var/run/NetworkManager/private
unix  2      [ ACC ]     STREAM     LISTENING     21737    /var/run/postgresql/.s.PGSQL.5432
unix  2      [ ACC ]     STREAM     LISTENING     29162    /tmp/.esd-1001/socket
unix  2      [ ACC ]     STREAM     LISTENING     29165    /run/user/1001/pulse/native
unix  2      [ ACC ]     STREAM     LISTENING     27084    /home/testappli/.gnupg/S.gpg-agent
Active Bluetooth connections (seulement serveurs)
Proto  Destination       Source            State         PSM DCID   SCID      IMTU    OMTU Security
warning, got bogus l2cap line.
Proto  Destination       Source            State     Channel
[root@localhost testappli]# 
[root@localhost testappli]#