php Xampp MySQL错误?

2o7dmzc5  于 2023-02-03  发布在  PHP
关注(0)|答案(2)|浏览(140)

今天我已经在C:/xampp中安装了XAMPP。
我得到一个错误,而试图运行MYSQL像这样:

12:29:29  [mysql]   Status change detected: running
12:29:30  [mysql]   Status change detected: stopped
12:29:30  [mysql]   Error: MySQL shutdown unexpectedly.
12:29:30  [mysql]   This may be due to a blocked port, missing dependencies, 
12:29:30  [mysql]   improper privileges, a crash, or a shutdown by another method.
12:29:30  [mysql]   Press the Logs button to view error logs and check
12:29:30  [mysql]   the Windows Event Viewer for more clues
12:29:30  [mysql]   If you need more help, copy and post this
12:29:30  [mysql]   entire log window on the forums

下面是错误日志文件的副本:

2014-02-08 12:29:30 3208 [Note] Plugin 'FEDERATED' is disabled.
2014-02-08 12:29:30 34c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-02-08 12:29:30 3208 [Note] InnoDB: The InnoDB memory heap is disabled
2014-02-08 12:29:30 3208 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-02-08 12:29:30 3208 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-02-08 12:29:30 3208 [Note] InnoDB: Not using CPU crc32 instructions
c:\xampp\mysql\bin\mysqld.exe: File 'C:\xampp\tmp\ib9241.tmp' not found (Errcode: 13 - Permission denied)
2014-02-08 12:29:30 34c  InnoDB: Error: unable to create temporary file; errno: 13
2014-02-08 12:29:30 3208 [ERROR] Plugin 'InnoDB' init function returned error.
2014-02-08 12:29:30 3208 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-02-08 12:29:30 3208 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-02-08 12:29:30 3208 [ERROR] Aborting

2014-02-08 12:29:30 3208 [Note] Binlog end
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'partition'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_METRICS'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_CMP'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'INNODB_TRX'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'BLACKHOLE'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'ARCHIVE'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'MRG_MYISAM'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'MyISAM'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'MEMORY'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'CSV'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'sha256_password'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'mysql_old_password'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'mysql_native_password'
2014-02-08 12:29:30 3208 [Note] Shutting down plugin 'binlog'
2014-02-08 12:29:30 3208 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

我一直在尝试使用Xampp安装Joomla。
Xampp版本〉〉3.2.1已编译:二〇一三年五月七日
Joomla版本〉〉3.2.2(稳定的完整包)
有人能帮帮我吗?

iqjalb3h

iqjalb3h1#

mysql使用端口3306,您是否有其他程序在此端口上运行?如果有,请关闭它们,然后重新启动mysql。如果可以,请转到http://www.apachefriends.org/download.html,下载最新版本的Xampp并重新安装,这可能是你丢失了一个文件或有一个损坏的文件.你可以复制你的htdocs文件夹到你的桌面,这样你就不会丢失任何东西,然后再复制回来.祝你好运!

gwbalxhn

gwbalxhn2#

我能够通过从mysql文件夹中删除这2个日志文件来解决此问题

/mysql/data/ib_logfile0 
/mysql/data/ib_logfile1

我希望这对任何有同样问题的人都有帮助。

相关问题