Database server not working


  • | 4169 points

    I cant start mysql server. Error log:
    2020-04-03T13:23:26.826046Z 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.
    2020-04-03T13:23:26.826642Z 0 [Note] D:\laragon\bin\mysql\mysql-5.7.29-winx64\bin\mysqld (mysqld 5.7.29) starting as process 9056 ...
    2020-04-03T13:23:26.853444Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-04-03T13:23:26.854839Z 0 [Note] InnoDB: Uses event mutexes
    2020-04-03T13:23:26.855672Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
    2020-04-03T13:23:26.856930Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-04-03T13:23:26.858353Z 0 [Note] InnoDB: Number of pools: 1
    2020-04-03T13:23:26.859368Z 0 [Note] InnoDB: Not using CPU crc32 instructions
    2020-04-03T13:23:26.864920Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2020-04-03T13:23:26.874473Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-04-03T13:23:27.004725Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2020-04-03T13:23:27.192357Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-04-03T13:23:27.194157Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-04-03T13:23:27.441163Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
    2020-04-03T13:23:27.468018Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
    2020-04-03T13:23:27.469597Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2020-04-03T13:23:27.471349Z 0 [Note] InnoDB: Waiting for purge to start
    2020-04-03T13:23:27.538726Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 2630688
    2020-04-03T13:23:27.540524Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\laragon\data\mysql\ib_buffer_pool
    2020-04-03T13:23:27.540547Z 0 [Note] Plugin 'FEDERATED' is disabled.
    2020-04-03T13:23:27.547779Z 0 [ERROR] unknown variable 'binding-site=0.0.0.0'
    2020-04-03T13:23:27.548959Z 0 [ERROR] Aborting

    2020-04-03T13:23:27.549669Z 0 [Note] Binlog end
    2020-04-03T13:23:27.550406Z 0 [Note] Shutting down plugin 'ngram'
    2020-04-03T13:23:27.551321Z 0 [Note] Shutting down plugin 'partition'
    2020-04-03T13:23:27.552272Z 0 [Note] Shutting down plugin 'BLACKHOLE'
    2020-04-03T13:23:27.553260Z 0 [Note] Shutting down plugin 'ARCHIVE'
    2020-04-03T13:23:27.554190Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2020-04-03T13:23:27.555290Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
    2020-04-03T13:23:27.556262Z 0 [Note] Shutting down plugin 'MyISAM'
    2020-04-03T13:23:27.557229Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
    2020-04-03T13:23:27.558298Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2020-04-03T13:23:27.559401Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2020-04-03T13:23:27.559494Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200403 20:23:27
    2020-04-03T13:23:27.560520Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2020-04-03T13:23:27.562785Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2020-04-03T13:23:27.563816Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2020-04-03T13:23:27.564796Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2020-04-03T13:23:27.565780Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2020-04-03T13:23:27.566766Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2020-04-03T13:23:27.567785Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2020-04-03T13:23:27.568763Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2020-04-03T13:23:27.569865Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2020-04-03T13:23:27.570883Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2020-04-03T13:23:27.571946Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2020-04-03T13:23:27.572985Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2020-04-03T13:23:27.573955Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2020-04-03T13:23:27.575025Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
    2020-04-03T13:23:27.575962Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
    2020-04-03T13:23:27.576990Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2020-04-03T13:23:27.578039Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2020-04-03T13:23:27.579062Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2020-04-03T13:23:27.580044Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2020-04-03T13:23:27.581113Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2020-04-03T13:23:27.582114Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2020-04-03T13:23:27.583104Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2020-04-03T13:23:27.584031Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2020-04-03T13:23:27.585074Z 0 [Note] Shutting down plugin 'INNODB_CMP'
    2020-04-03T13:23:27.585967Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2020-04-03T13:23:27.586938Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
    2020-04-03T13:23:27.587855Z 0 [Note] Shutting down plugin 'INNODB_TRX'
    2020-04-03T13:23:27.588749Z 0 [Note] Shutting down plugin 'InnoDB'
    2020-04-03T13:23:27.589685Z 0 [Note] InnoDB: FTS optimize thread exiting.
    2020-04-03T13:23:27.590787Z 0 [Note] InnoDB: Starting shutdown...
    2020-04-03T13:23:27.694595Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\laragon\data\mysql\ib_buffer_pool
    2020-04-03T13:23:27.698050Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200403 20:23:27
    2020-04-03T13:23:29.047084Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2630707
    2020-04-03T13:23:29.048916Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2020-04-03T13:23:29.050115Z 0 [Note] Shutting down plugin 'MEMORY'
    2020-04-03T13:23:29.050982Z 0 [Note] Shutting down plugin 'CSV'
    2020-04-03T13:23:29.051809Z 0 [Note] Shutting down plugin 'sha256_password'
    2020-04-03T13:23:29.052765Z 0 [Note] Shutting down plugin 'mysql_native_password'
    2020-04-03T13:23:29.054026Z 0 [Note] Shutting down plugin 'binlog'
    2020-04-03T13:23:29.063294Z 0 [Note] D:\laragon\bin\mysql\mysql-5.7.29-winx64\bin\mysqld: Shutdown complete


  • administrators
    | 125583 points

    @rescenic : The error is straightforward:

    2020-04-03T13:23:27.547779Z 0 [ERROR] unknown variable 'binding-site=0.0.0.0'
    
    

  • | 4169 points

    If I remove binding-site, the error is now:
    2020-04-03T23:07:16.341751Z 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.
    2020-04-03T23:07:16.342268Z 0 [Note] D:\laragon\bin\mysql\mysql-5.7.29-winx64\bin\mysqld (mysqld 5.7.29) starting as process 7456 ...
    2020-04-03T23:07:16.372216Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-04-03T23:07:16.373684Z 0 [Note] InnoDB: Uses event mutexes
    2020-04-03T23:07:16.374589Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
    2020-04-03T23:07:16.375967Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-04-03T23:07:16.377592Z 0 [Note] InnoDB: Number of pools: 1
    2020-04-03T23:07:16.379014Z 0 [Note] InnoDB: Not using CPU crc32 instructions
    2020-04-03T23:07:16.384476Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2020-04-03T23:07:16.396312Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-04-03T23:07:16.581678Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2020-04-03T23:07:16.967286Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-04-03T23:07:16.969155Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-04-03T23:07:17.268284Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
    2020-04-03T23:07:17.274044Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
    2020-04-03T23:07:17.275754Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2020-04-03T23:07:17.277774Z 0 [Note] InnoDB: Waiting for purge to start
    2020-04-03T23:07:17.342386Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 2630764
    2020-04-03T23:07:17.344288Z 0 [Note] Plugin 'FEDERATED' is disabled.
    2020-04-03T23:07:17.344447Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\laragon\data\mysql\ib_buffer_pool
    2020-04-03T23:07:17.527980Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
    2020-04-03T23:07:17.529877Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
    2020-04-03T23:07:17.533525Z 0 [Warning] CA certificate ca.pem is self signed.
    2020-04-03T23:07:17.534752Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
    2020-04-03T23:07:17.536338Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200404 6:07:17
    2020-04-03T23:07:17.536579Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
    2020-04-03T23:07:17.539017Z 0 [Note] IPv6 is available.
    2020-04-03T23:07:17.539792Z 0 [Note] - '::' resolves to '::';
    2020-04-03T23:07:17.540707Z 0 [Note] Server socket created on IP: '::'.
    2020-04-03T23:07:17.541666Z 0 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
    2020-04-03T23:07:17.542951Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
    2020-04-03T23:07:17.544467Z 0 [ERROR] Aborting

    2020-04-03T23:07:17.545208Z 0 [Note] Binlog end
    2020-04-03T23:07:17.545982Z 0 [Note] Shutting down plugin 'ngram'
    2020-04-03T23:07:17.546965Z 0 [Note] Shutting down plugin 'partition'
    2020-04-03T23:07:17.548364Z 0 [Note] Shutting down plugin 'BLACKHOLE'
    2020-04-03T23:07:17.549662Z 0 [Note] Shutting down plugin 'ARCHIVE'
    2020-04-03T23:07:17.550840Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2020-04-03T23:07:17.551944Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
    2020-04-03T23:07:17.552964Z 0 [Note] Shutting down plugin 'MyISAM'
    2020-04-03T23:07:17.553934Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
    2020-04-03T23:07:17.555017Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2020-04-03T23:07:17.556144Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2020-04-03T23:07:17.557295Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2020-04-03T23:07:17.558436Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2020-04-03T23:07:17.559730Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2020-04-03T23:07:17.560803Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2020-04-03T23:07:17.561917Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2020-04-03T23:07:17.562998Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2020-04-03T23:07:17.564169Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2020-04-03T23:07:17.565261Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2020-04-03T23:07:17.566379Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2020-04-03T23:07:17.567700Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2020-04-03T23:07:17.568771Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2020-04-03T23:07:17.569922Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2020-04-03T23:07:17.571117Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2020-04-03T23:07:17.572330Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
    2020-04-03T23:07:17.573279Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
    2020-04-03T23:07:17.574333Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2020-04-03T23:07:17.575465Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2020-04-03T23:07:17.576500Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2020-04-03T23:07:17.577491Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2020-04-03T23:07:17.578570Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2020-04-03T23:07:17.579580Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2020-04-03T23:07:17.580629Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2020-04-03T23:07:17.581619Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2020-04-03T23:07:17.582684Z 0 [Note] Shutting down plugin 'INNODB_CMP'
    2020-04-03T23:07:17.583671Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2020-04-03T23:07:17.584736Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
    2020-04-03T23:07:17.585753Z 0 [Note] Shutting down plugin 'INNODB_TRX'
    2020-04-03T23:07:17.586730Z 0 [Note] Shutting down plugin 'InnoDB'
    2020-04-03T23:07:17.587721Z 0 [Note] InnoDB: FTS optimize thread exiting.
    2020-04-03T23:07:17.589262Z 0 [Note] InnoDB: Starting shutdown...
    2020-04-03T23:07:17.695102Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\laragon\data\mysql\ib_buffer_pool
    2020-04-03T23:07:17.698096Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200404 6:07:17
    2020-04-03T23:07:19.027550Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2630783
    2020-04-03T23:07:19.029558Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2020-04-03T23:07:19.030868Z 0 [Note] Shutting down plugin 'MEMORY'
    2020-04-03T23:07:19.031766Z 0 [Note] Shutting down plugin 'CSV'
    2020-04-03T23:07:19.032647Z 0 [Note] Shutting down plugin 'sha256_password'
    2020-04-03T23:07:19.033905Z 0 [Note] Shutting down plugin 'mysql_native_password'
    2020-04-03T23:07:19.035640Z 0 [Note] Shutting down plugin 'binlog'
    2020-04-03T23:07:19.043801Z 0 [Note] D:\laragon\bin\mysql\mysql-5.7.29-winx64\bin\mysqld: Shutdown complete


  • | 4169 points

    And I dont have app that open port 3306:
    https://ibb.co/vDCXsJb


  • administrators
    | 125583 points

    @rescenic: Are you sure your settings are fine?
    If yes, please backup C:\laragon\data to C:\laragon\data.bak, Laragon will re-create a new fresh one for you.


  • | 4169 points

    It seems that Laragon confuses the local network. I reset the network in Windows Setting. Restart the computer and voila, it works again. Thank you for your time.
    It seems Docker and Hyper-V are the culprits.


  • administrators
    | 125583 points

    @rescenic : I am glad to hear that. Docker is a nightmare on Windows - Be careful with it. If you want to learn it, use Linux.


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.