[SOLVED] Cannot start MySQL

  • | 1999 points

    I was using Laragon 4.x, yesterday I installed MySQL Workbench, but I don't think it messed anything up.
    Upgraded to Laragon 5.x now, but still can't start mysql.

    2021-06-12T05:06:22.401449Z 0 [Note] C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin\mysqld (mysqld 5.7.24) starting as process 13476 ...
    2021-06-12T05:06:31.931078Z 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-06-12T05:06:31.931483Z 0 [Note] C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin\mysqld (mysqld 5.7.24) starting as process 4228 ...
    2021-06-12T05:06:31.946567Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2021-06-12T05:06:31.947246Z 0 [Note] InnoDB: Uses event mutexes
    2021-06-12T05:06:31.947667Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
    2021-06-12T05:06:31.948287Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2021-06-12T05:06:31.949083Z 0 [Note] InnoDB: Number of pools: 1
    2021-06-12T05:06:31.949625Z 0 [Note] InnoDB: Not using CPU crc32 instructions
    2021-06-12T05:06:31.952577Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2021-06-12T05:06:31.958923Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2021-06-12T05:06:31.993206Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2021-06-12T05:06:32.212811Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2021-06-12T05:06:32.213672Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2021-06-12T05:06:32.221412Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
    2021-06-12T05:06:32.227158Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
    2021-06-12T05:06:32.227940Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2021-06-12T05:06:32.229119Z 0 [Note] InnoDB: Waiting for purge to start
    2021-06-12T05:06:32.293386Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 300522968
    2021-06-12T05:06:32.294310Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\laragon\data\mysql\ib_buffer_pool
    2021-06-12T05:06:32.294413Z 0 [Note] Plugin 'FEDERATED' is disabled.
    2021-06-12T05:06:32.302857Z 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-06-12T05:06:32.303266Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210612 10:51:32
    2021-06-12T05:06:32.303923Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
    2021-06-12T05:06:32.305273Z 0 [Note] IPv6 is available.
    2021-06-12T05:06:32.305701Z 0 [Note]   - '::' resolves to '::';
    2021-06-12T05:06:32.306226Z 0 [Note] Server socket created on IP: '::'.
    2021-06-12T05:06:32.306766Z 0 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
    2021-06-12T05:06:32.307465Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
    2021-06-12T05:06:32.308178Z 0 [ERROR] Aborting
    2021-06-12T05:06:32.308552Z 0 [Note] Binlog end
    2021-06-12T05:06:32.308941Z 0 [Note] Shutting down plugin 'ngram'
    2021-06-12T05:06:32.309522Z 0 [Note] Shutting down plugin 'partition'
    2021-06-12T05:06:32.310041Z 0 [Note] Shutting down plugin 'BLACKHOLE'
    2021-06-12T05:06:32.310563Z 0 [Note] Shutting down plugin 'ARCHIVE'
    2021-06-12T05:06:32.311056Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2021-06-12T05:06:32.311648Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
    2021-06-12T05:06:32.312206Z 0 [Note] Shutting down plugin 'MyISAM'
    2021-06-12T05:06:32.312708Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
    2021-06-12T05:06:32.313298Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2021-06-12T05:06:32.313849Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2021-06-12T05:06:32.314435Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2021-06-12T05:06:32.315040Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2021-06-12T05:06:32.315602Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2021-06-12T05:06:32.316225Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2021-06-12T05:06:32.316837Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2021-06-12T05:06:32.317413Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2021-06-12T05:06:32.318000Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2021-06-12T05:06:32.318558Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2021-06-12T05:06:32.319142Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2021-06-12T05:06:32.319730Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2021-06-12T05:06:32.320282Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2021-06-12T05:06:32.320864Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2021-06-12T05:06:32.321430Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2021-06-12T05:06:32.322068Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
    2021-06-12T05:06:32.322602Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
    2021-06-12T05:06:32.323219Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2021-06-12T05:06:32.323831Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2021-06-12T05:06:32.324524Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2021-06-12T05:06:32.325102Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2021-06-12T05:06:32.325670Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2021-06-12T05:06:32.326212Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2021-06-12T05:06:32.326707Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2021-06-12T05:06:32.327218Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2021-06-12T05:06:32.327788Z 0 [Note] Shutting down plugin 'INNODB_CMP'
    2021-06-12T05:06:32.328245Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2021-06-12T05:06:32.328727Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
    2021-06-12T05:06:32.329198Z 0 [Note] Shutting down plugin 'INNODB_TRX'
    2021-06-12T05:06:32.329743Z 0 [Note] Shutting down plugin 'InnoDB'
    2021-06-12T05:06:32.330288Z 0 [Note] InnoDB: FTS optimize thread exiting.
    2021-06-12T05:06:32.330950Z 0 [Note] InnoDB: Starting shutdown...
    2021-06-12T05:06:32.435195Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\laragon\data\mysql\ib_buffer_pool
    2021-06-12T05:06:32.437303Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210612 10:51:32
    2021-06-12T05:06:33.854554Z 0 [Note] InnoDB: Shutdown completed; log sequence number 300522987
    2021-06-12T05:06:33.855368Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2021-06-12T05:06:33.855943Z 0 [Note] Shutting down plugin 'MEMORY'
    2021-06-12T05:06:33.856387Z 0 [Note] Shutting down plugin 'CSV'
    2021-06-12T05:06:33.856793Z 0 [Note] Shutting down plugin 'sha256_password'
    2021-06-12T05:06:33.857270Z 0 [Note] Shutting down plugin 'mysql_native_password'
    2021-06-12T05:06:33.857851Z 0 [Note] Shutting down plugin 'binlog'
    2021-06-12T05:06:33.861659Z 0 [Note] C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin\mysqld: Shutdown complete```

  • | 1999 points

    Uninstalled the MySQL workbench, reboot, its all good now. Wasted 1 hour on nothing.

Log in to reply

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