mysql - Mysql由于某种原因没有运行

Question

我在不同的端口上使用我的终端，但 MySQL 正在使用 xampp，之后将一些库添加到我的节点项目之一，如 auth google、express fetch、nodemon、SendGrid 电子邮件等。重新启动后它停止工作电脑，所以现在不工作了

它给我带来的错误是下一个：

2020-08-02 14:20:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-02 14:20:07 0 [Note] InnoDB: Uses event mutexes
2020-08-02 14:20:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-02 14:20:07 0 [Note] InnoDB: Number of pools: 1
2020-08-02 14:20:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-02 14:20:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-02 14:20:07 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-02 14:20:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-02 14:20:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-02 14:20:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-02 14:20:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-02 14:20:07 0 [Note] InnoDB: Waiting for purge to start
2020-08-02 14:20:07 0 [Note] InnoDB: 10.4.13 started; log sequence number 2242307; transaction id 2704
2020-08-02 14:20:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-02 14:20:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-02 14:20:07 0 [Note] Server socket created on IP: '::'.
2020-08-02 14:20:07 0 [Note] InnoDB: Buffer pool(s) load completed at 200802 14:20:07
InnoDB: using atomic writes.
2020-08-02 14:59:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-02 14:59:33 0 [Note] InnoDB: Uses event mutexes
2020-08-02 14:59:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-02 14:59:33 0 [Note] InnoDB: Number of pools: 1
2020-08-02 14:59:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-02 14:59:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-02 14:59:33 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-02 14:59:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-02 14:59:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-02 14:59:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-02 14:59:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-02 14:59:33 0 [Note] InnoDB: Waiting for purge to start
2020-08-02 14:59:33 0 [Note] InnoDB: 10.4.13 started; log sequence number 2242316; transaction id 2704
2020-08-02 14:59:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-02 14:59:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-02 14:59:33 0 [Note] Server socket created on IP: '::'.
2020-08-02 14:59:33 0 [Note] InnoDB: Buffer pool(s) load completed at 200802 14:59:33

所以我不确定发生了什么，我所做的一切都不应该影响 MySQL

这是 xampp 中显示的内容：

02:15:59 p. m.  [main]  Initializing Control Panel
02:15:59 p. m.  [main]  Windows Version:  Home  64-bit
02:15:59 p. m.  [main]  XAMPP Version: 7.2.31
02:15:59 p. m.  [main]  Control Panel Version: 3.2.4  [ Compiled: Jun 5th 2019 ]
02:15:59 p. m.  [main]  You are not running with administrator rights! This will work for
02:15:59 p. m.  [main]  most application stuff but whenever you do something with services
02:15:59 p. m.  [main]  there will be a security dialogue or things will break! So think 
02:15:59 p. m.  [main]  about running this application with administrator rights!
02:15:59 p. m.  [main]  XAMPP Installation Directory: "c:\xampp\"
02:15:59 p. m.  [main]  Checking for prerequisites
02:16:01 p. m.  [main]  All prerequisites found
02:16:01 p. m.  [main]  Initializing Modules
02:16:01 p. m.  [main]  Starting Check-Timer
02:16:01 p. m.  [main]  Control Panel Ready
02:16:28 p. m.  [mysql]     Attempting to start MySQL app...
02:16:28 p. m.  [mysql]     Status change detected: running
02:16:33 p. m.  [mysql]     Status change detected: stopped
02:16:33 p. m.  [mysql]     Error: MySQL shutdown unexpectedly.
02:16:33 p. m.  [mysql]     This may be due to a blocked port, missing dependencies, 
02:16:33 p. m.  [mysql]     improper privileges, a crash, or a shutdown by another method.
02:16:33 p. m.  [mysql]     Press the Logs button to view error logs and check
02:16:33 p. m.  [mysql]     the Windows Event Viewer for more clues
02:16:33 p. m.  [mysql]     If you need more help, copy and post this
02:16:33 p. m.  [mysql]     entire log window on the forums
02:20:02 p. m.  [Apache]    Attempting to start Apache app...
02:20:02 p. m.  [Apache]    Status change detected: running
02:20:07 p. m.  [mysql]     Attempting to start MySQL app...
02:20:07 p. m.  [mysql]     Status change detected: running
02:20:12 p. m.  [mysql]     Status change detected: stopped
02:20:12 p. m.  [mysql]     Error: MySQL shutdown unexpectedly.
02:20:12 p. m.  [mysql]     This may be due to a blocked port, missing dependencies, 
02:20:12 p. m.  [mysql]     improper privileges, a crash, or a shutdown by another method.
02:20:12 p. m.  [mysql]     Press the Logs button to view error logs and check
02:20:12 p. m.  [mysql]     the Windows Event Viewer for more clues
02:20:12 p. m.  [mysql]     If you need more help, copy and post this
02:20:12 p. m.  [mysql]     entire log window on the forums
02:59:33 p. m.  [mysql]     Attempting to start MySQL app...
02:59:34 p. m.  [mysql]     Status change detected: running
02:59:38 p. m.  [mysql]     Status change detected: stopped
02:59:38 p. m.  [mysql]     Error: MySQL shutdown unexpectedly.
02:59:38 p. m.  [mysql]     This may be due to a blocked port, missing dependencies, 
02:59:38 p. m.  [mysql]     improper privileges, a crash, or a shutdown by another method.
02:59:38 p. m.  [mysql]     Press the Logs button to view error logs and check
02:59:38 p. m.  [mysql]     the Windows Event Viewer for more clues
02:59:38 p. m.  [mysql]     If you need more help, copy and post this
02:59:38 p. m.  [mysql]     entire log window on the forums

标签： mysqlxampp

Answer 1

问题出在数据库上，我将备份和部分放入文档中，它解决了问题