MySQL Forums
Forum List  »  Newbie

Re: mysqld won't start on Windows 10
Posted by: CE Stanley
Date: October 13, 2016 03:19PM

Starting mysqld with --console option:

$ ./mysqld.exe --console
2016-10-13T18:00:42.110766Z 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-10-13T18:00:42.111768Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.15) starting as process 8324 ...
2016-10-13T18:00:42.116771Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-10-13T18:00:42.116771Z 0 [Note] InnoDB: Uses event mutexes
2016-10-13T18:00:42.116771Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-10-13T18:00:42.116771Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-13T18:00:42.116771Z 0 [Note] InnoDB: Number of pools: 1
2016-10-13T18:00:42.116771Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-10-13T18:00:42.118785Z 0 [Note] InnoDB: Initializing buffer pool, total size = 47M, instances = 1, chunk size = 47M
2016-10-13T18:00:42.120772Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-10-13T18:00:42.143003Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-13T18:00:42.215872Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-10-13T18:00:42.216966Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-10-13T18:00:42.262820Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-10-13T18:00:42.264819Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-10-13T18:00:42.264819Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-10-13T18:00:42.264819Z 0 [Note] InnoDB: Waiting for purge to start
2016-10-13T18:00:42.315982Z 0 [Note] InnoDB: 5.7.15 started; log sequence number 2528505
2016-10-13T18:00:42.316982Z 0 [Note] InnoDB: Loading buffer pool(s) from c:\Program Files\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-10-13T18:00:42.316982Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-10-13T18:00:42.326984Z 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-10-13T18:00:42.326984Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-10-13T18:00:42.327984Z 0 [Note] IPv6 is available.
2016-10-13T18:00:42.327984Z 0 [Note] - '::' resolves to '::';
2016-10-13T18:00:42.327984Z 0 [Note] Server socket created on IP: '::'.
2016-10-13T18:00:42.339501Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161013 11:00:42
2016-10-13T18:00:42.362987Z 0 [Note] Event Scheduler: Loaded 0 events
2016-10-13T18:00:42.363987Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.15' socket: '' port: 3306 MySQL Community Server (GPL)

^C closes mysqld at this point.

I am on a Windows PC.

Options: ReplyQuote


Subject
Written By
Posted
October 13, 2016 11:11AM
Re: mysqld won't start on Windows 10
October 13, 2016 03:19PM


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.