Bonsoir @tous,
en executant la commande:
root@didiercl:~# mysql_upgrade
Phase 1/6: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats OK
mysql.columns_priv
Error : Incorrect file format 'columns_priv’
error : Corrupt
mysql.db
Error : Incorrect file format 'db’
error : Corrupt
mysql.event
Error : Incorrect file format 'event’
error : Corrupt
mysql.func
Error : Incorrect file format 'func’
error : Corrupt
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin
Error : Incorrect file format 'plugin’
error : Corrupt
mysql.proc OK
mysql.procs_priv
Error : Incorrect file format 'procs_priv’
error : Corrupt
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv
Error : Incorrect file format 'tables_priv’
error : Corrupt
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user
Error : File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
Error : File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
Error : Table ‘./mysql/user.MYI’ is read only
error : Corrupt
Repairing tables
mysql.columns_priv
Error : Incorrect file format 'columns_priv’
error : Corrupt
mysql.db
Error : Incorrect file format 'db’
error : Corrupt
mysql.event
Error : Incorrect file format 'event’
error : Corrupt
mysql.func
Error : Incorrect file format 'func’
error : Corrupt
mysql.plugin
Error : Incorrect file format 'plugin’
error : Corrupt
mysql.procs_priv
Error : Incorrect file format 'procs_priv’
error : Corrupt
mysql.tables_priv
Error : Incorrect file format 'tables_priv’
error : Corrupt
mysql.user
Error : File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
Error : File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
Error : Table ‘./mysql/user.MYI’ is read only
error : Corrupt
Phase 2/6: Fixing views
Phase 3/6: Running 'mysql_fix_privilege_tables’
ERROR 29 (HY000) at line 141: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 143: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 144: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 146: Incorrect file format 'db’
ERROR 29 (HY000) at line 147: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 148: Incorrect file format 'db’
ERROR 29 (HY000) at line 150: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 155: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 156: Incorrect file format 'tables_priv’
ERROR 130 (HY000) at line 158: Incorrect file format 'tables_priv’
ERROR 130 (HY000) at line 166: Incorrect file format 'tables_priv’
ERROR 130 (HY000) at line 174: Incorrect file format 'columns_priv’
ERROR 130 (HY000) at line 177: Incorrect file format 'columns_priv’
ERROR 130 (HY000) at line 186: Incorrect file format 'columns_priv’
ERROR 130 (HY000) at line 189: Incorrect file format 'func’
ERROR 29 (HY000) at line 191: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 192: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 200: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 201: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 205: Incorrect file format 'db’
ERROR 29 (HY000) at line 211: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 212: Incorrect file format 'db’
ERROR 29 (HY000) at line 214: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 215: Incorrect file format 'func’
ERROR 29 (HY000) at line 216: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 220: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 244: Incorrect file format 'db’
ERROR 130 (HY000) at line 249: Incorrect file format 'db’
ERROR 130 (HY000) at line 279: Incorrect file format 'func’
ERROR 130 (HY000) at line 281: Incorrect file format 'func’
ERROR 130 (HY000) at line 312: Incorrect file format 'plugin’
ERROR 29 (HY000) at line 317: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 318: Incorrect file format 'db’
ERROR 130 (HY000) at line 319: Incorrect file format 'db’
ERROR 29 (HY000) at line 322: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 323: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 324: Incorrect file format 'db’
ERROR 130 (HY000) at line 325: Incorrect file format 'db’
ERROR 29 (HY000) at line 328: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 329: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 330: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 332: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 333: Incorrect file format 'db’
ERROR 130 (HY000) at line 334: Incorrect file format 'db’
ERROR 29 (HY000) at line 337: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 338: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 339: Incorrect file format 'db’
ERROR 130 (HY000) at line 340: Incorrect file format 'db’
ERROR 29 (HY000) at line 343: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 344: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 345: Incorrect file format 'db’
ERROR 130 (HY000) at line 346: Incorrect file format 'db’
ERROR 29 (HY000) at line 349: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 350: Incorrect file format 'db’
ERROR 29 (HY000) at line 352: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 353: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 355: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 356: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 357: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 358: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 361: Incorrect file format 'procs_priv’
ERROR 130 (HY000) at line 364: Incorrect file format 'procs_priv’
ERROR 130 (HY000) at line 367: Incorrect file format 'procs_priv’
ERROR 130 (HY000) at line 370: Incorrect file format 'procs_priv’
ERROR 130 (HY000) at line 373: Incorrect file format 'procs_priv’
ERROR 29 (HY000) at line 472: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 473: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 474: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 475: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 476: Incorrect file format 'db’
ERROR 130 (HY000) at line 477: Incorrect file format 'db’
ERROR 130 (HY000) at line 478: Incorrect file format 'event’
ERROR 130 (HY000) at line 479: Incorrect file format 'event’
ERROR 130 (HY000) at line 480: Incorrect file format 'event’
ERROR 130 (HY000) at line 481: Incorrect file format 'event’
ERROR 130 (HY000) at line 515: Incorrect file format 'event’
ERROR 130 (HY000) at line 516: Incorrect file format 'event’
ERROR 130 (HY000) at line 517: Incorrect file format 'event’
ERROR 130 (HY000) at line 518: Incorrect file format 'event’
ERROR 130 (HY000) at line 519: Incorrect file format 'event’
ERROR 130 (HY000) at line 521: Incorrect file format 'event’
ERROR 130 (HY000) at line 524: Incorrect file format 'event’
ERROR 130 (HY000) at line 526: Incorrect file format 'event’
ERROR 130 (HY000) at line 529: Incorrect file format 'event’
ERROR 130 (HY000) at line 531: Incorrect file format 'event’
ERROR 130 (HY000) at line 534: Incorrect file format 'event’
ERROR 130 (HY000) at line 536: Incorrect file format 'event’
ERROR 130 (HY000) at line 538: Incorrect file format 'event’
ERROR 130 (HY000) at line 539: Incorrect file format 'db’
ERROR 29 (HY000) at line 541: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 542: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 543: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 546: Incorrect file format 'db’
ERROR 130 (HY000) at line 547: Incorrect file format 'db’
ERROR 29 (HY000) at line 548: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 550: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 551: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 552: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 553: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 554: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 555: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 556: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 557: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 558: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 559: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 1436 (HY000) at line 574: Thread stack overrun: 4872 bytes used of a 131072 byte stack, and 0 bytes needed. Use ‘mysqld --thread_stack=#’ to specify a bigger stack.
ERROR 29 (HY000) at line 577: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 29 (HY000) at line 597: File ‘./mysql/user.MYD’ not found (Errcode: 13 “Permission denied”)
ERROR 130 (HY000) at line 598: Incorrect file format 'db’
ERROR 130 (HY000) at line 599: Incorrect file format 'tables_priv’
ERROR 130 (HY000) at line 600: Incorrect file format 'columns_priv’
ERROR 130 (HY000) at line 601: Incorrect file format 'procs_priv’
ERROR 130 (HY000) at line 603: Incorrect file format 'event’
ERROR 130 (HY000) at line 608: Incorrect file format 'procs_priv’
ERROR 130 (HY000) at line 609: Incorrect file format 'tables_priv’
ERROR 130 (HY000) at line 625: Incorrect file format 'event’
ERROR 1050 (42S01) at line 644: Table ‘cond_instances’ already exists
ERROR 1050 (42S01) at line 669: Table ‘events_waits_current’ already exists
FATAL ERROR: Upgrade failed
voila ce qui en ressort.
une idée?
bonne nuit.
didier58