J:\wamp\bin\mysql\mysql5.6.26\bin>mysql_upgrade.exe --user=root --host=localhost --password=mon_passe
mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OKIl peut y avoir plusieurs avertissements du style :
Warning: Using a password on the command line interface can be insecure.Ne pas en tenir compte, c'est normal.
#Added to reduce memory used (minimum is 400) table_definition_cache = 600 explicit_defaults_for_timestamp=true
#Added to reduce memory used (minimum is 400) table_definition_cache = 600 explicit_defaults_for_timestamp=trueet l'utilisation de 127.0.0.1 comme nom d'hôte (et pas localhost) je n'ai rien de plus précis à ajouter pour optimiser les performances.
# The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [wampmysqld] #skip-grant-tables port = 3306 socket = /tmp/mysql.sock key_buffer_size = 16M max_allowed_packet = 1M #Added to reduce memory used (minimum is 400) table_definition_cache = 600 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M basedir=J:/wamp/bin/mysql/mysql5.6.25 log-warnings = 0 log-error=J:/wamp/logs/mysql.log #datadir= J:/wamp/bin/mysql/mysql5.6.25/data datadir=G:/wwwbases #Path to the language #See Documentation: # [dev.mysql.com] lc-messages-dir=J:/Wamp/bin/mysql/mysql5.6.25/share lc-messages=fr_FR #lc-messages=en_US # The default storage engine that will be used when create new tables default-storage-engine=MYISAM # New for MySQL 5.6 default_tmp_storage_engine if skip-innodb enable # default_tmp_storage_engine=MYISAM explicit_defaults_for_timestamp=true # Set the SQL mode to strict sql-mode="STRICT_ALL_TABLES" # Disable Federated by default skip-federated # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # New for MySQL 5.6 if no slave skip-slave-start #do not use InnoDB tables # skip-innodb # Uncomment the following if you are using InnoDB tables innodb_data_file_path = ibdata1:10M:autoextend # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 16M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer_size = 2M write_buffer_size = 2M [myisamchk] key_buffer_size = 20M sort_buffer_size_size = 20M read_buffer_size = 2M write_buffer_size = 2M [mysqlhotcopy] interactive-timeout [mysqld] port = 3306