Mysqld ne se lance pas

Bonjour,

Le démon mysqld doit être lancé en tâche de fond pour ouvrir un prompt mysql.
La commande mysqld échoue, lorsque j'entre la commande mysqld du répertoire bin de mysql version 5.6.14 pour windows 64.

4 réponses

  1. Voici ce que retourne la console:
    C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld
    2013-10-21 14:44:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
    ted. Please use --explicit_defaults_for_timestamp server option (see documentati
    on for more details).
    2013-10-21 14:44:21 1124 [Warning] Can't create test file C:\Program Files\MySQL
    \MySQL Server 5.6\data\Stardust-PC.lower-test
    2013-10-21 14:44:21 1124 [Warning] Can't create test file C:\Program Files\MySQL
    \MySQL Server 5.6\data\Stardust-PC.lower-test
    2013-10-21 14:44:21 1124 [Note] Plugin 'FEDERATED' is disabled.
    2013-10-21 14:44:21 1124 [Note] InnoDB: The InnoDB memory heap is disabled
    2013-10-21 14:44:21 1124 [Note] InnoDB: Mutexes and rw_locks use Windows interlo
    cked functions
    2013-10-21 14:44:21 1124 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2013-10-21 14:44:21 1124 [Note] InnoDB: Not using CPU crc32 instructions
    2013-10-21 14:44:21 1124 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2013-10-21 14:44:21 1124 [Note] InnoDB: Completed initialization of buffer pool
    2013-10-21 14:44:21 1124 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write
    mode
    2013-10-21 14:44:21 1124 [ERROR] InnoDB: The system tablespace must be writable!

    2013-10-21 14:44:21 1124 [ERROR] Plugin 'InnoDB' init function returned error.
    2013-10-21 14:44:21 1124 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGIN
    E failed.
    2013-10-21 14:44:21 1124 [ERROR] Unknown/unsupported storage engine: InnoDB
    2013-10-21 14:44:21 1124 [ERROR] Aborting

    2013-10-21 14:44:21 1124 [Note] Binlog end
    2013-10-21 14:44:21 1124 [Note] Shutting down plugin 'partition'
    2013-10-21 14:44:21 1124 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD
    '
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_METRICS'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET
    '
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_CMP'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_LOCKS'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'INNODB_TRX'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'BLACKHOLE'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'ARCHIVE'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'MRG_MYISAM'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'MyISAM'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'MEMORY'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'CSV'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'sha256_password'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'mysql_old_password'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'mysql_native_password'
    2013-10-21 14:44:22 1124 [Note] Shutting down plugin 'binlog'
    2013-10-21 14:44:22 1124 [Note] mysqld: Shutdown complete
    0
    1. Je précise que Apache et php fonctionnent sans problème, tous deux installés manuellement.
      0
      1. Apparemment ce serait le fichier my.ini qui serait introuvable par le serveur mysql.
        0
        1. Cela était juste dû au UAC user account control (Contrôle de Compte Utilisateur). J'ai donc ouvert une LI (Command Line Interpretor) avec privilèges, Démarrer > cmd > ctrl alt shift.
          0
          1. CLI
            0