Re: MySQL Windows Server Remote Access and Missing ini

[George Deprez]

Here is my log showing that I am bound to 0.0.0.0
I still cannot connect to the port.
------------------------------------
2015-11-07T21:15:09.621752Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.9-log) starting as process 5084 ...
2015-11-07T21:15:09.637286Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-07T21:15:09.637286Z 0 [Note] InnoDB: Uses event mutexes
2015-11-07T21:15:09.637286Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2015-11-07T21:15:09.652826Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-07T21:15:09.652826Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2015-11-07T21:15:09.652826Z 0 [Note] InnoDB: Number of pools: 1
2015-11-07T21:15:09.652826Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-07T21:15:09.699665Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2015-11-07T21:15:09.699665Z 0 [Note] InnoDB: Completed initialization of buffer pool
2015-11-07T21:15:09.746544Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-07T21:15:09.887304Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2015-11-07T21:15:09.887304Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2015-11-07T21:15:10.090289Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2015-11-07T21:15:10.105982Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2015-11-07T21:15:10.105982Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2015-11-07T21:15:10.105982Z 0 [Note] InnoDB: Waiting for purge to start
2015-11-07T21:15:10.168358Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 2483351
2015-11-07T21:15:10.168358Z 0 [Note] Plugin 'FEDERATED' is disabled.
2015-11-07T21:15:10.168358Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2015-11-07T21:15:10.168358Z 0 [Note] InnoDB: not started
2015-11-07T21:15:10.183944Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-11-07T21:15:10.183944Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2015-11-07T21:15:10.183944Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2015-11-07T21:15:10.183944Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2015-11-07T21:15:10.340348Z 0 [Note] InnoDB: Buffer pool(s) load completed at 151107 21:15:10
2015-11-07T21:15:10.512185Z 0 [Note] Event Scheduler: Loaded 0 events
2015-11-07T21:15:10.512185Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.9-log' socket: '' port: 3306 MySQL Community Server (GPL)
------------------------------------