Installing and Using MySQL using Zip File.
Posted by: Sudhir B
Date: March 31, 2016 02:52AM
Date: March 31, 2016 02:52AM
Hello All,
I've been looking to use mysql only when I need it. For this I have downloaded MySQL Zip folder (mysql-5.7.11-winx64.zip). After I unzipped it and put environment variable as 'MYSQL_HOME' to its location.
Since data folder doesn't exists in the folder I have created a blank folder named data and I did mysqld -initialize to initialize data directory. then I tried to start MySQLd server but I noticed that it's exiting. I noticed below log in error log file.
2016-03-31T08:03:23.794966Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-31T08:03:23.794966Z 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.
2016-03-31T08:03:23.794966Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-03-31T08:03:23.794966Z 0 [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.
2016-03-31T08:03:23.794966Z 0 [Note] mysqld (mysqld 5.7.11) starting as process 4956 ...
2016-03-31T08:03:23.807966Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'
2016-03-31T08:03:23.809967Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-31T08:03:23.809967Z 0 [Note] InnoDB: Uses event mutexes
2016-03-31T08:03:23.810967Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-03-31T08:03:23.810967Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-31T08:03:23.811967Z 0 [Note] InnoDB: Number of pools: 1
2016-03-31T08:03:23.811967Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-31T08:03:23.853969Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-31T08:03:23.867970Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-31T08:03:23.881971Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2016-03-31T08:03:23.882971Z 0 [Note] InnoDB: Setting file '.\ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-31T08:03:24.252992Z 0 [Note] InnoDB: File '.\ibdata1' size is now 12 MB.
2016-03-31T08:03:24.273993Z 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2016-03-31T08:03:24.801023Z 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
2016-03-31T08:03:25.547066Z 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2016-03-31T08:03:25.550066Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-03-31T08:03:25.551066Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-31T08:03:25.552066Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-31T08:03:25.807081Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-03-31T08:03:25.848083Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-03-31T08:03:26.133099Z 0 [Note] InnoDB: Doublewrite buffer created
2016-03-31T08:03:26.160101Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-31T08:03:26.161101Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-31T08:03:26.163101Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-03-31T08:03:26.244106Z 0 [Note] InnoDB: Foreign key constraint system tables created
2016-03-31T08:03:26.249106Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-03-31T08:03:26.277108Z 0 [Note] InnoDB: Tablespace and datafile system tables created.
2016-03-31T08:03:26.278108Z 0 [Note] InnoDB: Creating sys_virtual system tables.
2016-03-31T08:03:26.321110Z 0 [Note] InnoDB: sys_virtual table created
2016-03-31T08:03:26.322110Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-31T08:03:26.373113Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 0
2016-03-31T08:03:26.375113Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2016-03-31T08:03:26.377113Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-03-31T08:03:26.378113Z 0 [ERROR] mysqld: unknown option '-i'
2016-03-31T08:03:26.379113Z 0 [ERROR] Aborting
2016-03-31T08:03:26.379113Z 0 [Note] Binlog end
2016-03-31T08:03:26.380114Z 0 [Note] Shutting down plugin 'ngram'
2016-03-31T08:03:26.381114Z 0 [Note] Shutting down plugin 'partition'
2016-03-31T08:03:26.382114Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-31T08:03:26.382114Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-03-31T08:03:26.383114Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-31T08:03:26.384114Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-31T08:03:26.384114Z 0 [Note] Shutting down plugin 'MyISAM'
2016-03-31T08:03:26.385114Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-03-31T08:03:26.386114Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-31T08:03:26.386114Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-31T08:03:26.387114Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-31T08:03:26.388114Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-31T08:03:26.388114Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-31T08:03:26.389114Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-31T08:03:26.390114Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-31T08:03:26.391114Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-31T08:03:26.391114Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-31T08:03:26.392114Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-31T08:03:26.393114Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-31T08:03:26.394114Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-31T08:03:26.395114Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-31T08:03:26.395114Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-31T08:03:26.396114Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-31T08:03:26.397115Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-31T08:03:26.398115Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-03-31T08:03:26.398115Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-31T08:03:26.399115Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-31T08:03:26.400115Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-31T08:03:26.401115Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-31T08:03:26.401115Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-31T08:03:26.402115Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-31T08:03:26.403115Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-31T08:03:26.403115Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-31T08:03:26.404115Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-31T08:03:26.405115Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-31T08:03:26.406115Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-31T08:03:26.406115Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-31T08:03:26.407115Z 0 [Note] Shutting down plugin 'InnoDB'
2016-03-31T08:03:26.407115Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-03-31T08:03:26.408115Z 0 [Note] InnoDB: Starting shutdown...
2016-03-31T08:03:26.508121Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\RunTimes\MySQL5711\mysql-5.7.11-winx64\data\ib_buffer_pool
2016-03-31T08:03:26.513121Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160331 4:03:26
2016-03-31T08:03:28.088211Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209961
2016-03-31T08:03:28.088211Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-03-31T08:03:28.089211Z 0 [Note] Shutting down plugin 'MEMORY'
2016-03-31T08:03:28.089211Z 0 [Note] Shutting down plugin 'CSV'
2016-03-31T08:03:28.089211Z 0 [Note] Shutting down plugin 'sha256_password'
2016-03-31T08:03:28.090211Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-03-31T08:03:28.091211Z 0 [Note] Shutting down plugin 'keyring_file'
2016-03-31T08:03:28.091211Z 0 [Note] Shutting down plugin 'binlog'
2016-03-31T08:03:28.092211Z 0 [Note] mysqld: Shutdown complete
2016-03-31T08:03:53.949690Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-31T08:03:53.949690Z 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.
2016-03-31T08:03:53.949690Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-03-31T08:03:53.949690Z 0 [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.
2016-03-31T08:03:53.949690Z 0 [Note] mysqld (mysqld 5.7.11) starting as process 688 ...
2016-03-31T08:03:53.957691Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'
2016-03-31T08:03:53.959691Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-31T08:03:53.960691Z 0 [Note] InnoDB: Uses event mutexes
2016-03-31T08:03:53.960691Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-03-31T08:03:53.960691Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-31T08:03:53.961691Z 0 [Note] InnoDB: Number of pools: 1
2016-03-31T08:03:53.961691Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-31T08:03:54.001693Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-31T08:03:54.012694Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-31T08:03:54.134701Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-31T08:03:54.272709Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-31T08:03:54.273709Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-31T08:03:54.412717Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-03-31T08:03:54.464720Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-31T08:03:54.466720Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-31T08:03:54.468720Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 1209961
2016-03-31T08:03:54.469720Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\RunTimes\MySQL5711\mysql-5.7.11-winx64\data\ib_buffer_pool
2016-03-31T08:03:54.469720Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2016-03-31T08:03:54.471720Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-03-31T08:03:54.473720Z 0 [Note] Salting uuid generator variables, current_pid: 688, server_start_time: 1459411433, bytes_sent: 0,
2016-03-31T08:03:54.481721Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160331 4:03:54
2016-03-31T08:03:54.486721Z 0 [Note] Generated uuid: '1cd7a4a6-f717-11e5-9b0c-28d24426b7d4', server_start_time: 1459412121, bytes_sent: 319749664
2016-03-31T08:03:54.487721Z 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: 1cd7a4a6-f717-11e5-9b0c-28d24426b7d4.
2016-03-31T08:03:54.516723Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-03-31T08:03:54.517723Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-31T08:03:54.520723Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-31T08:03:54.521723Z 0 [Note] IPv6 is available.
2016-03-31T08:03:54.521723Z 0 [Note] - '::' resolves to '::';
2016-03-31T08:03:54.521723Z 0 [Note] Server socket created on IP: '::'.
2016-03-31T08:03:54.522723Z 0 [Warning] Failed to open optimizer cost constant tables
2016-03-31T08:03:54.523723Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-03-31T08:03:54.523723Z 0 [ERROR] Aborting
2016-03-31T08:03:54.524723Z 0 [Note] Binlog end
2016-03-31T08:03:54.524723Z 0 [Note] Shutting down plugin 'ngram'
2016-03-31T08:03:54.524723Z 0 [Note] Shutting down plugin 'partition'
2016-03-31T08:03:54.524723Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-31T08:03:54.525723Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-03-31T08:03:54.525723Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-31T08:03:54.525723Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-31T08:03:54.525723Z 0 [Note] Shutting down plugin 'MyISAM'
2016-03-31T08:03:54.526723Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-03-31T08:03:54.526723Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-31T08:03:54.526723Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-31T08:03:54.526723Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-31T08:03:54.527724Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-31T08:03:54.527724Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-31T08:03:54.527724Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-31T08:03:54.528724Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-31T08:03:54.528724Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-31T08:03:54.528724Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-31T08:03:54.528724Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-31T08:03:54.529724Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-31T08:03:54.529724Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-31T08:03:54.529724Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-31T08:03:54.529724Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-31T08:03:54.530724Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-31T08:03:54.530724Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-31T08:03:54.530724Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-03-31T08:03:54.530724Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-31T08:03:54.531724Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-31T08:03:54.531724Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-31T08:03:54.531724Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-31T08:03:54.533724Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-31T08:03:54.533724Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-31T08:03:54.533724Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-31T08:03:54.533724Z 0 [Note] Shutting down plugin 'InnoDB'
2016-03-31T08:03:54.534724Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-03-31T08:03:54.534724Z 0 [Note] InnoDB: Starting shutdown...
2016-03-31T08:03:54.634730Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\RunTimes\MySQL5711\mysql-5.7.11-winx64\data\ib_buffer_pool
2016-03-31T08:03:54.640730Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160331 4:03:54
2016-03-31T08:03:56.054811Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209980
2016-03-31T08:03:56.054811Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-03-31T08:03:56.055811Z 0 [Note] Shutting down plugin 'MEMORY'
2016-03-31T08:03:56.055811Z 0 [Note] Shutting down plugin 'CSV'
2016-03-31T08:03:56.055811Z 0 [Note] Shutting down plugin 'sha256_password'
2016-03-31T08:03:56.055811Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-03-31T08:03:56.056811Z 0 [Note] Shutting down plugin 'keyring_file'
2016-03-31T08:03:56.056811Z 0 [Note] Shutting down plugin 'binlog'
2016-03-31T08:03:56.057811Z 0 [Note] mysqld: Shutdown complete
Please help me know how to start MySQL server.
Thanks,
Sudhir
I've been looking to use mysql only when I need it. For this I have downloaded MySQL Zip folder (mysql-5.7.11-winx64.zip). After I unzipped it and put environment variable as 'MYSQL_HOME' to its location.
Since data folder doesn't exists in the folder I have created a blank folder named data and I did mysqld -initialize to initialize data directory. then I tried to start MySQLd server but I noticed that it's exiting. I noticed below log in error log file.
2016-03-31T08:03:23.794966Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-31T08:03:23.794966Z 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.
2016-03-31T08:03:23.794966Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-03-31T08:03:23.794966Z 0 [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.
2016-03-31T08:03:23.794966Z 0 [Note] mysqld (mysqld 5.7.11) starting as process 4956 ...
2016-03-31T08:03:23.807966Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'
2016-03-31T08:03:23.809967Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-31T08:03:23.809967Z 0 [Note] InnoDB: Uses event mutexes
2016-03-31T08:03:23.810967Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-03-31T08:03:23.810967Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-31T08:03:23.811967Z 0 [Note] InnoDB: Number of pools: 1
2016-03-31T08:03:23.811967Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-31T08:03:23.853969Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-31T08:03:23.867970Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-31T08:03:23.881971Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2016-03-31T08:03:23.882971Z 0 [Note] InnoDB: Setting file '.\ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-31T08:03:24.252992Z 0 [Note] InnoDB: File '.\ibdata1' size is now 12 MB.
2016-03-31T08:03:24.273993Z 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2016-03-31T08:03:24.801023Z 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
2016-03-31T08:03:25.547066Z 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2016-03-31T08:03:25.550066Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-03-31T08:03:25.551066Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-31T08:03:25.552066Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-31T08:03:25.807081Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-03-31T08:03:25.848083Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-03-31T08:03:26.133099Z 0 [Note] InnoDB: Doublewrite buffer created
2016-03-31T08:03:26.160101Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-31T08:03:26.161101Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-31T08:03:26.163101Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-03-31T08:03:26.244106Z 0 [Note] InnoDB: Foreign key constraint system tables created
2016-03-31T08:03:26.249106Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-03-31T08:03:26.277108Z 0 [Note] InnoDB: Tablespace and datafile system tables created.
2016-03-31T08:03:26.278108Z 0 [Note] InnoDB: Creating sys_virtual system tables.
2016-03-31T08:03:26.321110Z 0 [Note] InnoDB: sys_virtual table created
2016-03-31T08:03:26.322110Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-31T08:03:26.373113Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 0
2016-03-31T08:03:26.375113Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2016-03-31T08:03:26.377113Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-03-31T08:03:26.378113Z 0 [ERROR] mysqld: unknown option '-i'
2016-03-31T08:03:26.379113Z 0 [ERROR] Aborting
2016-03-31T08:03:26.379113Z 0 [Note] Binlog end
2016-03-31T08:03:26.380114Z 0 [Note] Shutting down plugin 'ngram'
2016-03-31T08:03:26.381114Z 0 [Note] Shutting down plugin 'partition'
2016-03-31T08:03:26.382114Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-31T08:03:26.382114Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-03-31T08:03:26.383114Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-31T08:03:26.384114Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-31T08:03:26.384114Z 0 [Note] Shutting down plugin 'MyISAM'
2016-03-31T08:03:26.385114Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-03-31T08:03:26.386114Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-31T08:03:26.386114Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-31T08:03:26.387114Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-31T08:03:26.388114Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-31T08:03:26.388114Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-31T08:03:26.389114Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-31T08:03:26.390114Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-31T08:03:26.391114Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-31T08:03:26.391114Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-31T08:03:26.392114Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-31T08:03:26.393114Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-31T08:03:26.394114Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-31T08:03:26.395114Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-31T08:03:26.395114Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-31T08:03:26.396114Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-31T08:03:26.397115Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-31T08:03:26.398115Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-03-31T08:03:26.398115Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-31T08:03:26.399115Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-31T08:03:26.400115Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-31T08:03:26.401115Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-31T08:03:26.401115Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-31T08:03:26.402115Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-31T08:03:26.403115Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-31T08:03:26.403115Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-31T08:03:26.404115Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-31T08:03:26.405115Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-31T08:03:26.406115Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-31T08:03:26.406115Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-31T08:03:26.407115Z 0 [Note] Shutting down plugin 'InnoDB'
2016-03-31T08:03:26.407115Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-03-31T08:03:26.408115Z 0 [Note] InnoDB: Starting shutdown...
2016-03-31T08:03:26.508121Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\RunTimes\MySQL5711\mysql-5.7.11-winx64\data\ib_buffer_pool
2016-03-31T08:03:26.513121Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160331 4:03:26
2016-03-31T08:03:28.088211Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209961
2016-03-31T08:03:28.088211Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-03-31T08:03:28.089211Z 0 [Note] Shutting down plugin 'MEMORY'
2016-03-31T08:03:28.089211Z 0 [Note] Shutting down plugin 'CSV'
2016-03-31T08:03:28.089211Z 0 [Note] Shutting down plugin 'sha256_password'
2016-03-31T08:03:28.090211Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-03-31T08:03:28.091211Z 0 [Note] Shutting down plugin 'keyring_file'
2016-03-31T08:03:28.091211Z 0 [Note] Shutting down plugin 'binlog'
2016-03-31T08:03:28.092211Z 0 [Note] mysqld: Shutdown complete
2016-03-31T08:03:53.949690Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-31T08:03:53.949690Z 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.
2016-03-31T08:03:53.949690Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-03-31T08:03:53.949690Z 0 [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.
2016-03-31T08:03:53.949690Z 0 [Note] mysqld (mysqld 5.7.11) starting as process 688 ...
2016-03-31T08:03:53.957691Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'
2016-03-31T08:03:53.959691Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-31T08:03:53.960691Z 0 [Note] InnoDB: Uses event mutexes
2016-03-31T08:03:53.960691Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-03-31T08:03:53.960691Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-31T08:03:53.961691Z 0 [Note] InnoDB: Number of pools: 1
2016-03-31T08:03:53.961691Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-31T08:03:54.001693Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-31T08:03:54.012694Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-31T08:03:54.134701Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-31T08:03:54.272709Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-31T08:03:54.273709Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-31T08:03:54.412717Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-03-31T08:03:54.464720Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-31T08:03:54.466720Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-31T08:03:54.468720Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 1209961
2016-03-31T08:03:54.469720Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\RunTimes\MySQL5711\mysql-5.7.11-winx64\data\ib_buffer_pool
2016-03-31T08:03:54.469720Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2016-03-31T08:03:54.471720Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-03-31T08:03:54.473720Z 0 [Note] Salting uuid generator variables, current_pid: 688, server_start_time: 1459411433, bytes_sent: 0,
2016-03-31T08:03:54.481721Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160331 4:03:54
2016-03-31T08:03:54.486721Z 0 [Note] Generated uuid: '1cd7a4a6-f717-11e5-9b0c-28d24426b7d4', server_start_time: 1459412121, bytes_sent: 319749664
2016-03-31T08:03:54.487721Z 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: 1cd7a4a6-f717-11e5-9b0c-28d24426b7d4.
2016-03-31T08:03:54.516723Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-03-31T08:03:54.517723Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-31T08:03:54.520723Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-31T08:03:54.521723Z 0 [Note] IPv6 is available.
2016-03-31T08:03:54.521723Z 0 [Note] - '::' resolves to '::';
2016-03-31T08:03:54.521723Z 0 [Note] Server socket created on IP: '::'.
2016-03-31T08:03:54.522723Z 0 [Warning] Failed to open optimizer cost constant tables
2016-03-31T08:03:54.523723Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-03-31T08:03:54.523723Z 0 [ERROR] Aborting
2016-03-31T08:03:54.524723Z 0 [Note] Binlog end
2016-03-31T08:03:54.524723Z 0 [Note] Shutting down plugin 'ngram'
2016-03-31T08:03:54.524723Z 0 [Note] Shutting down plugin 'partition'
2016-03-31T08:03:54.524723Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-31T08:03:54.525723Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-03-31T08:03:54.525723Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-31T08:03:54.525723Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-31T08:03:54.525723Z 0 [Note] Shutting down plugin 'MyISAM'
2016-03-31T08:03:54.526723Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-03-31T08:03:54.526723Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-31T08:03:54.526723Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-31T08:03:54.526723Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-31T08:03:54.527724Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-31T08:03:54.527724Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-31T08:03:54.527724Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-31T08:03:54.528724Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-31T08:03:54.528724Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-31T08:03:54.528724Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-31T08:03:54.528724Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-31T08:03:54.529724Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-31T08:03:54.529724Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-31T08:03:54.529724Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-31T08:03:54.529724Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-31T08:03:54.530724Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-31T08:03:54.530724Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-31T08:03:54.530724Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-03-31T08:03:54.530724Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-31T08:03:54.531724Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-31T08:03:54.531724Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-31T08:03:54.531724Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-31T08:03:54.532724Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-31T08:03:54.533724Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-31T08:03:54.533724Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-31T08:03:54.533724Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-31T08:03:54.533724Z 0 [Note] Shutting down plugin 'InnoDB'
2016-03-31T08:03:54.534724Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-03-31T08:03:54.534724Z 0 [Note] InnoDB: Starting shutdown...
2016-03-31T08:03:54.634730Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\RunTimes\MySQL5711\mysql-5.7.11-winx64\data\ib_buffer_pool
2016-03-31T08:03:54.640730Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160331 4:03:54
2016-03-31T08:03:56.054811Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209980
2016-03-31T08:03:56.054811Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-03-31T08:03:56.055811Z 0 [Note] Shutting down plugin 'MEMORY'
2016-03-31T08:03:56.055811Z 0 [Note] Shutting down plugin 'CSV'
2016-03-31T08:03:56.055811Z 0 [Note] Shutting down plugin 'sha256_password'
2016-03-31T08:03:56.055811Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-03-31T08:03:56.056811Z 0 [Note] Shutting down plugin 'keyring_file'
2016-03-31T08:03:56.056811Z 0 [Note] Shutting down plugin 'binlog'
2016-03-31T08:03:56.057811Z 0 [Note] mysqld: Shutdown complete
Please help me know how to start MySQL server.
Thanks,
Sudhir
Subject
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.