MySQL cannot start on Windows, nothing else running on port 3306


  • | 1946 points

    2021-03-22T09:21:08.825178Z 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.
    2021-03-22T09:21:08.825431Z 0 [Note] C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin\mysqld (mysqld 5.7.24) starting as process 25756 ...
    2021-03-22T09:21:18.949787Z 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.
    2021-03-22T09:21:18.949996Z 0 [Note] C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin\mysqld (mysqld 5.7.24) starting as process 14332 ...
    2021-03-22T09:21:18.959373Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2021-03-22T09:21:18.959857Z 0 [Note] InnoDB: Uses event mutexes
    2021-03-22T09:21:18.960143Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
    2021-03-22T09:21:18.960613Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2021-03-22T09:21:18.961161Z 0 [Note] InnoDB: Number of pools: 1
    2021-03-22T09:21:18.961551Z 0 [Note] InnoDB: Not using CPU crc32 instructions
    2021-03-22T09:21:18.963494Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2021-03-22T09:21:18.967739Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2021-03-22T09:21:18.988421Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2021-03-22T09:21:19.025074Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2021-03-22T09:21:19.025695Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2021-03-22T09:21:19.056713Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
    2021-03-22T09:21:19.058131Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
    2021-03-22T09:21:19.058623Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2021-03-22T09:21:19.059196Z 0 [Note] InnoDB: Waiting for purge to start
    2021-03-22T09:21:19.110483Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 2592094
    2021-03-22T09:21:19.111065Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\laragon\data\mysql\ib_buffer_pool
    2021-03-22T09:21:19.111099Z 0 [Note] Plugin 'FEDERATED' is disabled.
    2021-03-22T09:21:19.116446Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
    2021-03-22T09:21:19.117118Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
    2021-03-22T09:21:19.117600Z 0 [Note] IPv6 is available.
    2021-03-22T09:21:19.117864Z 0 [Note] - '::' resolves to '::';
    2021-03-22T09:21:19.118181Z 0 [Note] Server socket created on IP: '::'.
    2021-03-22T09:21:19.118513Z 0 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
    2021-03-22T09:21:19.118935Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
    2021-03-22T09:21:19.119169Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210322 13:21:19
    2021-03-22T09:21:19.119360Z 0 [ERROR] Aborting

    2021-03-22T09:21:19.119911Z 0 [Note] Binlog end
    2021-03-22T09:21:19.120197Z 0 [Note] Shutting down plugin 'ngram'
    2021-03-22T09:21:19.120491Z 0 [Note] Shutting down plugin 'partition'
    2021-03-22T09:21:19.120791Z 0 [Note] Shutting down plugin 'BLACKHOLE'
    2021-03-22T09:21:19.121091Z 0 [Note] Shutting down plugin 'ARCHIVE'
    2021-03-22T09:21:19.121383Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2021-03-22T09:21:19.121729Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
    2021-03-22T09:21:19.122036Z 0 [Note] Shutting down plugin 'MyISAM'
    2021-03-22T09:21:19.122333Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
    2021-03-22T09:21:19.122663Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2021-03-22T09:21:19.122998Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2021-03-22T09:21:19.123339Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2021-03-22T09:21:19.123683Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2021-03-22T09:21:19.124012Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2021-03-22T09:21:19.124336Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2021-03-22T09:21:19.124663Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2021-03-22T09:21:19.124990Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2021-03-22T09:21:19.125329Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2021-03-22T09:21:19.125651Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2021-03-22T09:21:19.125987Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2021-03-22T09:21:19.126326Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2021-03-22T09:21:19.126645Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2021-03-22T09:21:19.126989Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2021-03-22T09:21:19.127311Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2021-03-22T09:21:19.127665Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
    2021-03-22T09:21:19.127980Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
    2021-03-22T09:21:19.128322Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2021-03-22T09:21:19.128671Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2021-03-22T09:21:19.129011Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2021-03-22T09:21:19.129339Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2021-03-22T09:21:19.129695Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2021-03-22T09:21:19.130030Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2021-03-22T09:21:19.130362Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2021-03-22T09:21:19.130673Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2021-03-22T09:21:19.130991Z 0 [Note] Shutting down plugin 'INNODB_CMP'
    2021-03-22T09:21:19.131311Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2021-03-22T09:21:19.131647Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
    2021-03-22T09:21:19.131962Z 0 [Note] Shutting down plugin 'INNODB_TRX'
    2021-03-22T09:21:19.132321Z 0 [Note] Shutting down plugin 'InnoDB'
    2021-03-22T09:21:19.132679Z 0 [Note] InnoDB: FTS optimize thread exiting.
    2021-03-22T09:21:19.133084Z 0 [Note] InnoDB: Starting shutdown...
    2021-03-22T09:21:19.234498Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\laragon\data\mysql\ib_buffer_pool
    2021-03-22T09:21:19.235611Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210322 13:21:19
    2021-03-22T09:21:20.553262Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2592113
    2021-03-22T09:21:20.553942Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2021-03-22T09:21:20.554386Z 0 [Note] Shutting down plugin 'MEMORY'
    2021-03-22T09:21:20.554687Z 0 [Note] Shutting down plugin 'CSV'
    2021-03-22T09:21:20.554970Z 0 [Note] Shutting down plugin 'sha256_password'
    2021-03-22T09:21:20.555294Z 0 [Note] Shutting down plugin 'mysql_native_password'
    2021-03-22T09:21:20.555703Z 0 [Note] Shutting down plugin 'binlog'
    2021-03-22T09:21:20.557091Z 0 [Note] C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin\mysqld: Shutdown complete


  • | 744 points

    Another person had the same problem in this forum: Check here

    And this one might explain why: Outside link


Log in to reply
 

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