mysqld --initialize-insecureEt là, au miracle, le répertoire '/data' est réapparu.
log-error=J:/wamp/logs/mysql.log #Verbosity Value 1 Errors only, 2 Errors and warnings , 3 Errors, warnings, and notes log_error_verbosity=3Bonne chose, ça permet de ne pas (Valeur 2) encombrer les fichiers et les journaux Windows.
La documentation MySQL me semble plus « nébuleuse » que celles de PHP ou Apache, mais, un fois qu'on « pense » en avoir compris la subtilité et la « logique », il est un peu plus facile de trouver ce que l'on cherche.Citation
Artemus24
L'icône étant orange, j'ai remarqué que le répertoire '/data' n'existait pas.
J'ai cherché dans la documentation afin de recréer ce répertoire, est j'ai lu ce lien : [dev.mysql.com]
# Privilèges pour `domi`@`localhost` GRANT USAGE ON *.* TO 'domi'@'localhost' IDENTIFIED BY PASSWORD '*39216FA025C0E783E05561008C9D3C007534A3CA'; GRANT SELECT, INSERT, UPDATE, DELETE ON `aviatechno`.* TO 'domi'@'localhost'; # Privilèges pour `root`@`127.0.0.1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY PASSWORD '*CCFD7D38456BEB8F90CAA5A7B3BDE6004EF000AD' WITH GRANT OPTION; # Privilèges pour `root`@`::1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY PASSWORD '*CCFD7D38456BEB8F90CAA5A7B3BDE6004EF000AD' WITH GRANT OPTION; # Privilèges pour `root`@`localhost` GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*CCFD7D38456BEB8F90CAA5A7B3BDE6004EF000AD' WITH GRANT OPTION; GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;Pas besoin d'aller chercher PhpMyAdmin.
mysqld --initialize-insecure --log_error_verbosity=3Comme je n'ai pas précisé le fichier 'log-error', il me le crée automatiquement sous le nom 'orion.err' dans le répertoire '/data'.
2015-09-24T16:56:21.622123Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-09-24T16:56:21.637747Z 0 [Note] Ignoring --secure-file-priv value as server is running with --initialize(-insecure) or --bootstrap. 2015-09-24T16:56:21.637747Z 0 [Note] mysqld (mysqld 5.7.8-rc) starting as process 4288 ... 2015-09-24T16:56:21.653374Z 0 [Note] Creating the data directory f:\wamp\bin\mysql\mysql5.7.8RC\data\ Appuyez sur une touche pour continuer...Le répertoire '/data' a bien été créé.
2015-09-24T16:56:21.668998Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2015-09-24T16:56:21.668998Z 0 [Note] InnoDB: Uses event mutexes 2015-09-24T16:56:21.668998Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2015-09-24T16:56:21.668998Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-09-24T16:56:21.668998Z 0 [Note] InnoDB: Number of pools: 1 2015-09-24T16:56:21.684622Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2015-09-24T16:56:21.731499Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2015-09-24T16:56:21.747124Z 0 [Note] InnoDB: Completed initialization of buffer pool 2015-09-24T16:56:21.793999Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created! 2015-09-24T16:56:21.793999Z 0 [Note] InnoDB: Setting file '.\ibdata1' size to 12 MB. Physically writing the file full; Please wait ... 2015-09-24T16:56:21.950252Z 0 [Note] InnoDB: File '.\ibdata1' size is now 12 MB. 2015-09-24T16:56:21.981517Z 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB 2015-09-24T16:56:22.580509Z 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB 2015-09-24T16:56:23.410247Z 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0 2015-09-24T16:56:23.410247Z 0 [Warning] InnoDB: New log files created, LSN=45790 2015-09-24T16:56:23.410247Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2015-09-24T16:56:23.425834Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2015-09-24T16:56:23.628635Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2015-09-24T16:56:23.709583Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new 2015-09-24T16:56:23.943008Z 0 [Note] InnoDB: Doublewrite buffer created 2015-09-24T16:56:23.991422Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2015-09-24T16:56:23.991422Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2015-09-24T16:56:23.991422Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2015-09-24T16:56:24.007048Z 0 [Note] InnoDB: Foreign key constraint system tables created 2015-09-24T16:56:24.007048Z 0 [Note] InnoDB: Creating tablespace and datafile system tables. 2015-09-24T16:56:24.022671Z 0 [Note] InnoDB: Tablespace and datafile system tables created. 2015-09-24T16:56:24.022671Z 0 [Note] InnoDB: Creating sys_virtual system tables. 2015-09-24T16:56:24.022671Z 0 [Note] InnoDB: sys_virtual table created 2015-09-24T16:56:24.022671Z 0 [Note] InnoDB: Waiting for purge to start 2015-09-24T16:56:24.085345Z 0 [Note] InnoDB: 5.7.8 started; log sequence number 0 2015-09-24T16:56:24.085345Z 0 [Note] Plugin 'FEDERATED' is disabled. 2015-09-24T16:56:24.085345Z 0 [Note] Salting uuid generator variables, current_pid: 4288, server_start_time: 1443113781, bytes_sent: 0, 2015-09-24T16:56:24.100799Z 0 [Note] Generated uuid: '303a0137-62dd-11e5-8eb7-0024814ba126', server_start_time: 1443118069, bytes_sent: 295854427184 2015-09-24T16:56:24.116425Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 303a0137-62dd-11e5-8eb7-0024814ba126. 2015-09-24T16:56:24.132050Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2015-09-24T16:56:24.132050Z 0 [Warning] Failed to setup SSL 2015-09-24T16:56:24.132050Z 0 [Warning] SSL error: SSL context is not usable without certificate and private key 2015-09-24T16:56:24.132050Z 1 [Note] Creating the system database 2015-09-24T16:56:24.132050Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2015-09-24T16:56:24.132050Z 1 [Note] Creating the system tables 2015-09-24T16:56:27.446562Z 1 [Note] Filling in the system tables, part 1 2015-09-24T16:56:27.446562Z 1 [Note] Filling in the system tables, part 2 2015-09-24T16:56:27.446562Z 1 [Note] Filling in the mysql.help table 2015-09-24T16:56:27.792554Z 1 [Note] Creating the sys schema 2015-09-24T16:56:29.320969Z 1 [Note] Bootstrapping complete 2015-09-24T16:56:29.320969Z 0 [Note] Binlog end 2015-09-24T16:56:29.352221Z 0 [Note] InnoDB: FTS optimize thread exiting. 2015-09-24T16:56:29.352221Z 0 [Note] InnoDB: Starting shutdown... 2015-09-24T16:56:29.461769Z 0 [Note] InnoDB: Dumping buffer pool(s) to .\\ib_buffer_pool 2015-09-24T16:56:29.461769Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 150924 18:56:29 2015-09-24T16:56:30.805965Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2418632 2015-09-24T16:56:30.805965Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"Jusque là, je considère que tout va bien, enfin je crois, vu que je ne sais pas si le comportement est normale ou pas.
# ------------# # Log # # ------------# log-error = f:/Wamp/logs/mysql_error.log log-error-verbosity = 3 general-log = 0J'avais pourtant compris que la valeur par défaut est 3. Et qu'il n'est pas nécessaire de le préciser.
-------------- show variables like 'log%' -------------- +------------------------------------------+--------+ | Variable_name | Value | +------------------------------------------+--------+ | log_backward_compatible_user_definitions | OFF | | log_bin | OFF | | log_bin_basename | | | log_bin_index | | | log_bin_trust_function_creators | OFF | | log_bin_use_v1_row_events | OFF | | log_error | stderr | | log_error_verbosity | 3 | | log_output | FILE | | log_queries_not_using_indexes | OFF | | log_slave_updates | OFF | | log_slow_admin_statements | OFF | | log_slow_slave_statements | OFF | | log_syslog | ON | | log_syslog_tag | | | log_throttle_queries_not_using_indexes | 0 | | log_timestamps | UTC | | log_warnings | 2 | +------------------------------------------+--------+ Appuyez sur une touche pour continuer...Je devrais avoir mon fichier 'f:/Wamp/logs/mysql_error.log' dans la variable 'log-error'. Or j'ai à la place 'stderr'.
Citation
Otomatic
Il semblerait qu'au lancement de MySQL, --console soit prit par défaut (stderr) ...
mysqld --verbose --helpet la variable 'console' est bien à 'false'.
Espérons que cela soit le cas.Citation
[2 Oct 7:28] Ståle Deraas
Posted by developer:
Hi Dominique,
5.7.8 introduced this bug, and this is now fixed in 5.7.9, which will be released shortly.
[Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
[Warning] CA certificate f:/Wamp/bin/apache/apache2.4.17/conf/certificat/ca/ca.crt is self signed.