Re: Instal on Windows 10/64 with custom configuration

[Hubert CANEVET]

Well, it appears there is no chance to get it with the installation program, as it reinitiates the ini file before getting any idea of what is in it.
So, it makes the installation with default-character-set=0.0, which does not exist.

I had to copy the command line from the log, and execute it in a command line window.

I obtained this :

D:\Projets Visual Studio\Web>"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on...
2018-04-19T09:31:45.425747Z 0 [Warning] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ignoring option '--initialize-insecure' due to invalid value 'on...'
2018-04-19T09:31:45.516433Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-19T09:31:45.516460Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-04-19T09:31:45.516485Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-04-19T09:31:45.516940Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.21) starting as process 119612 ...
2018-04-19T09:31:45.529356Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-04-19T09:31:45.530144Z 0 [Note] InnoDB: Uses event mutexes
2018-04-19T09:31:45.531966Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-04-19T09:31:45.532344Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-04-19T09:31:45.533303Z 0 [Note] InnoDB: Number of pools: 1
2018-04-19T09:31:45.533779Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-04-19T09:31:45.541099Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-04-19T09:31:45.549160Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-04-19T09:31:45.792328Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-19T09:31:45.920093Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-04-19T09:31:45.921056Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-04-19T09:31:46.084507Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2018-04-19T09:31:46.088197Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-04-19T09:31:46.089330Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-04-19T09:31:46.091123Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 1209980
2018-04-19T09:31:46.091912Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\MySql\data\ib_buffer_pool
2018-04-19T09:31:46.092203Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2018-04-19T09:31:46.093520Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-04-19T09:31:46.093627Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180419 11:31:46
2018-04-19T09:31:46.096897Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-04-19T09:31:46.098169Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-04-19T09:31:46.098436Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-04-19T09:31:46.099466Z 0 [Note] IPv6 is available.
2018-04-19T09:31:46.099694Z 0 [Note] - '::' resolves to '::';
2018-04-19T09:31:46.100127Z 0 [Note] Server socket created on IP: '::'.
2018-04-19T09:31:46.104426Z 0 [Warning] Failed to open optimizer cost constant tables

2018-04-19T09:31:46.117342Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2018-04-19T09:31:46.118390Z 0 [ERROR] Aborting

2018-04-19T09:31:46.118969Z 0 [Note] Binlog end
2018-04-19T09:31:46.120491Z 0 [Note] Shutting down plugin 'ngram'
2018-04-19T09:31:46.120843Z 0 [Note] Shutting down plugin 'partition'
2018-04-19T09:31:46.121804Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-04-19T09:31:46.122649Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-04-19T09:31:46.123388Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-04-19T09:31:46.125468Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-04-19T09:31:46.125843Z 0 [Note] Shutting down plugin 'MyISAM'
2018-04-19T09:31:46.127864Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-04-19T09:31:46.128352Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-04-19T09:31:46.128695Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-04-19T09:31:46.129025Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-04-19T09:31:46.129360Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-04-19T09:31:46.129669Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-04-19T09:31:46.130190Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-04-19T09:31:46.130539Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-04-19T09:31:46.130894Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-04-19T09:31:46.131222Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-04-19T09:31:46.131547Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-04-19T09:31:46.132016Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-04-19T09:31:46.132425Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-04-19T09:31:46.132753Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-04-19T09:31:46.133284Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-04-19T09:31:46.133625Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-04-19T09:31:46.136487Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-04-19T09:31:46.137247Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-04-19T09:31:46.138013Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-04-19T09:31:46.140139Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-04-19T09:31:46.140367Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-04-19T09:31:46.140830Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-04-19T09:31:46.141245Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-04-19T09:31:46.141652Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-04-19T09:31:46.142086Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-04-19T09:31:46.142430Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-04-19T09:31:46.142744Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-04-19T09:31:46.143184Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-04-19T09:31:46.143497Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-04-19T09:31:46.143822Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-04-19T09:31:46.144305Z 0 [Note] Shutting down plugin 'InnoDB'
2018-04-19T09:31:46.144692Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-04-19T09:31:46.147283Z 0 [Note] InnoDB: Starting shutdown...
2018-04-19T09:31:46.248459Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\MySql\data\ib_buffer_pool
2018-04-19T09:31:46.250987Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180419 11:31:46
2018-04-19T09:31:47.499792Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209999
2018-04-19T09:31:47.503586Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-04-19T09:31:47.506112Z 0 [Note] Shutting down plugin 'MEMORY'
2018-04-19T09:31:47.507094Z 0 [Note] Shutting down plugin 'CSV'
2018-04-19T09:31:47.508440Z 0 [Note] Shutting down plugin 'sha256_password'
2018-04-19T09:31:47.510750Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-04-19T09:31:47.512842Z 0 [Note] Shutting down plugin 'binlog'
2018-04-19T09:31:47.514537Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete


Workbench says it cannot start the server.