求解答XAMPP无法启动MySQL

因为以前安装过MySQL,后来卸载了,现在安装xampp,一直无法启动mysql,尝试改了端口号,注册表也改了,就是无法启动,求各位大神解救图片说明

1个回答

直接重新安装一下mysql。

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
Python+OpenCV计算机视觉

Python+OpenCV计算机视觉

XAMPP下 mysql服务启动失败 错误1067

本人macbook双系统装了win10,没下其他数据库,只下了一个XAMPP自带的mysql,下到了C:/上,刚下载完毕就打开MySQL服务就报error ![图片说明](https://img-ask.csdn.net/upload/201812/12/1544613903_211923.png) 然后我用管理员身份安装了bin目录下的 **mysqld.exe** 于是在服务中有了MySQL这个服务,然后我再打开mysql还是报如上图一样的错误,所以我尝试直接在服务中打开MySQL服务,但是发现启动不了 ![图片说明](https://img-ask.csdn.net/upload/201812/12/1544613891_281593.png) 然后我看了日志发现错误如下 **InnoDB: File (unknown): 'close' returned OS error 206. Cannot continue operation** 然后我就蒙蔽了, 有大神指点指点我该怎么办啊!!! my.ini片段如下 ![图片说明](https://img-ask.csdn.net/upload/201812/12/1544614501_618324.png)

XAMPP中的MySQL超时

<div class="post-text" itemprop="text"> <p>I have XAMPP installed on Microsoft Windows Server 2003. I have a PHP application in xampp/htdocs directory. I have started the Apache and MySQL instances. </p> <p>I have noticed that every morning, my application gives a MySQL Error when I try to log in to my application. This is fixed after restarting MySQL instance in XAMPP control panel on the server. I think this may be due to timeout. How do I prevent timeout?</p> <p>This is the my.ini:</p> <pre><code>[client] port = 3306 socket = "D:/xampp/mysql/mysql.sock" [mysqld] port= 3306 socket = "D:/xampp/mysql/mysql.sock" basedir = "D:/xampp/mysql" tmpdir = "D:/xampp/tmp" datadir = "D:/xampp/mysql/data" pid_file = "mysql.pid" key_buffer = 16M max_allowed_packet = 1M sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log_error = "mysql_error.log" plugin_dir = "D:/xampp/mysql/lib/plugin/" skip-federated server-id = 1 innodb_data_home_dir = "D:/xampp/mysql/data" innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = "D:/xampp/mysql/data" innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout </code></pre> <p>This is the error I come across every morning before restarting MySQL on XAMPP:</p> <pre><code>Warning: mysql_pconnect(): MySQL server has gone away in D:\MyApplication\mysql.inc on line 432 Warning: mysql_pconnect(): Link to server lost, unable to reconnect in D:\MyApplication\mysql.inc on line 432 Fatal Error: Failed to connect to database </code></pre> </div>

win7系统--xampp中启动mysql状态为已启动,会中断,是什么原因?

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

xampp里的mysql启动报错

![图片说明](https://img-ask.csdn.net/upload/201709/24/1506183935_606316.png) 我的mysql怎么跑不起来。是什么原因呢?之前是端口号冲突。把3306改成3307了但还是跑不起来

我在xampp windows中启动mysql时出现MySql错误

<div class="post-text" itemprop="text"> <p>When I start mysql in control panel I obtain this error:</p> <pre><code>Error: MySQL shutdown unexpectedly. 09:35:03 [mysql] This may be due to a blocked port, missing dependencies, 09:35:03 [mysql] improper privileges, a crash, or a shutdown by another method. 09:35:03 [mysql] Press the Logs button to view error logs and check 09:35:03 [mysql] the Windows Event Viewer for more clues 09:35:03 [mysql] If you need more help, copy and post this 09:35:03 [mysql] entire log window on the forums </code></pre> <p>Anyone can help me?</p> </div>

win7系统--xampp中启动mysql状态为已启动后提示mysqld已停止工作,不知道是什么原因?求解决

10:39:00 [mysql] entire log window on the forums 10:41:34 [mysql] Attempting to start MySQL app... 10:41:34 [mysql] Status change detected: running 10:41:45 [mysql] Status change detected: stopped 10:41:45 [mysql] Error: MySQL shutdown unexpectedly. 10:41:45 [mysql] This may be due to a blocked port, missing dependencies, 10:41:45 [mysql] improper privileges, a crash, or a shutdown by another method. 10:41:45 [mysql] Press the Logs button to view error logs and check 10:41:45 [mysql] the Windows Event Viewer for more clues 10:41:45 [mysql] If you need more help, copy and post this 10:41:45 [mysql] entire log window on the forums 10:00〔39〕:MySQL on the window论坛全部日志 〔10〕:41 34 to start attempting MySQL MySQL… 〔10〕:41 34运行状态变化detected:MySQL的 〔10〕:45 41:MySQL的函数是detected地位的变化: 〔10〕45 41:::MySQL的MySQL unexpectedly ERROR shutdown。 〔10〕:45 41:MySQL this may be missing两端口的限制,BO, 〔10〕:45 41:MySQL权限improper,碰撞,或在另一个备用的关闭方法。 〔10〕:45 41:MySQL日志Press the button to view错误日志和检查 〔10〕:45 41:MySQL的Windows事件查看器for the更多的线索 〔10〕:MySQL 45 41:如果你需要更多的帮助,这和后复制 10:[全部]:45 41日志mysql扩大on the window ![图片说明](https://img-ask.csdn.net/upload/201901/19/1547866081_549092.png)

xampp中的mysql运行七八秒后突然停止工作,如图,应该如何操作?求大神解答!

![![图片说明](https://img-ask.csdn.net/upload/201511/20/1448007850_332662.jpg)图片说明](https://img-ask.csdn.net/upload/201511/20/1448007836_283414.jpg)

XAMPP如何使用本地已安装Mysql?

XAMpp安装有自带的mysql,要安装部署的服务器已安装部署了mysql。 问: 1、怎么操作设置并使用服务器已安装的MYsql,Xampp自带的mysql不使用

XAMPP错误:MySQL意外关闭

<div class="post-text" itemprop="text"> <p>I just installed XAMPP and when I press start for MySQL, it started normally, and then suddenly it stopped. Here what I got in the console:</p> <pre><code>12:52:45 AM [mysql] Error: MySQL shutdown unexpectedly. 12:52:45 AM [mysql] This may be due to a blocked port, missing dependencies, 12:52:45 AM [mysql] improper privileges, a crash, or a shutdown by another method. 12:52:45 AM [mysql] Press the Logs button to view error logs and check 12:52:45 AM [mysql] the Windows Event Viewer for more clues 12:52:45 AM [mysql] If you need more help, copy and post this 12:52:45 AM [mysql] entire log window on the forums </code></pre> <p>And here is in the error log file:</p> <pre><code>Version: '5.6.24' socket: '' port: 3306 MySQL Community Server (GPL) 2015-10-22 10:01:43 7700 [Note] Plugin 'FEDERATED' is disabled. 2015-10-22 10:01:43 12f0 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. 2015-10-22 10:01:43 7700 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-10-22 10:01:43 7700 [Note] InnoDB: The InnoDB memory heap is disabled 2015-10-22 10:01:43 7700 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2015-10-22 10:01:43 7700 [Note] InnoDB: Memory barrier is not used 2015-10-22 10:01:43 7700 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-10-22 10:01:43 7700 [Note] InnoDB: Not using CPU crc32 instructions 2015-10-22 10:01:43 7700 [Note] InnoDB: Initializing buffer pool, size = 16.0M 2015-10-22 10:01:43 7700 [Note] InnoDB: Completed initialization of buffer pool 2015-10-22 10:01:43 7700 [Note] InnoDB: Highest supported file format is Barracuda. 2015-10-22 10:01:43 7700 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 39662092 in the ib_logfiles! 2015-10-22 10:01:43 7700 [Note] InnoDB: Database was not shutdown normally! 2015-10-22 10:01:43 7700 [Note] InnoDB: Starting crash recovery. 2015-10-22 10:01:43 7700 [Note] InnoDB: Reading tablespace information from the .ibd files... 2015-10-22 10:01:44 7700 [Note] InnoDB: Restoring possible half-written data pages 2015-10-22 10:01:44 7700 [Note] InnoDB: from the doublewrite buffer... 2015-10-22 10:01:44 7700 [Note] InnoDB: 128 rollback segment(s) are active. 2015-10-22 10:01:44 7700 [Note] InnoDB: Waiting for purge to start 2015-10-22 10:01:44 7700 [Note] InnoDB: 5.6.24 started; log sequence number 39662092 2015-10-22 10:01:44 7700 [Note] Server hostname (bind-address): '*'; port: 3306 2015-10-22 10:01:44 7700 [Note] IPv6 is available. 2015-10-22 10:01:44 7700 [Note] - '::' resolves to '::'; 2015-10-22 10:01:44 7700 [Note] Server socket created on IP: '::'. 2015-10-22 10:01:45 7700 [Note] Event Scheduler: Loaded 0 events 2015-10-22 10:01:45 7700 [Note] mysql\bin\mysqld.exe: ready for connections. Version: '5.6.24' socket: '' port: 3306 MySQL Community Server (GPL) </code></pre> <p>Can anyone help me? I should get back to work with this XAMPP. Thanks before!</p> </div>

关于xampp下的mysql 启动初始化时,my.ini的问题

xampp lite 2016 下的mysql默认的my.ini不在熟知的根目录下 而是在mysql的bin目录里, 但是在配置字符集(utf8)的时候,bin目录下的my.ini文件配置过后只对character_set_server和character_set_database有效,却对character_set_client,character_set_connection和 character_set_results 起不到作用,我尝试着在根目录下又放置了一个my.ini进行同样的配置,重启mysql后发现另外三个参数也都成功更改了。 很奇怪,这样以来,两个my.ini在不同位置竟然能同时互补地起配置作用,百思不得其解,不知道哪里的问题,求大神指点。 另外求问: mysql 启动时 my.ini的位置是如何确定,也就是说mysql启动时是怎样确定到哪里去找my.ini? 两个配置文件的截图如下 1.xampp\mysql\bin\my.ini ![图片说明](https://img-ask.csdn.net/upload/201608/22/1471875460_204707.png) 2.xampp\mysql\my.ini ![图片说明](https://img-ask.csdn.net/upload/201608/22/1471875539_96522.png)

无法使用XAMPP连接到MySQL数据库

<div class="post-text" itemprop="text"> <p>I am new to programming and I have been trying to run a PHP application from Murachs PHP and MySQL instructional book, the source code is actually from their website, but have been getting an error message. The error message is as follows; </p> <p>"Database Error There was an error connecting to the database. The database must be installed as described in the appendix. MySQL must be running as described in chapter 1. Error message: SQLSTATE[HY000] [1045] Access denied for user 'mgs_user'@'localhost' (using password: YES)"</p> <p>I downloaded XAMPP and it is running fine but for some reason I am unable to use the MySQL database. I have searched and Googled and searched some more for the last two days but I can't seem to find a solution. </p> <p>I remember setting up a username and password during installation and I set up a username called "root" and a password through PHPMyAdmin yesterday but why will this application not run?</p> <p>Any help is appreciated.</p> <p>Update #1</p> <p>Here are samples of the code that creates the database, the user and the password.</p> <p>This is downloaded from Murach's site so the code should be good. I am thinking there is something wrong with the XAMPP/MySQL that will not allow a connection to the database.</p> <pre><code>/***************************************** * Create the my_guitar_shop1 database *****************************************/ DROP DATABASE IF EXISTS my_guitar_shop1; CREATE DATABASE my_guitar_shop1; USE my_guitar_shop1; -- MySQL command -- Create a user named mgs_user GRANT SELECT, INSERT, UPDATE, DELETE ON * TO mgs_user@localhost IDENTIFIED BY 'pa55word'; </code></pre> <p>Update #2</p> <p>I created the user "mgs_user@localhost" in PHPMyAdmin and gave it permissions and now I get the following error;</p> <p>"Database Error There was an error connecting to the database.</p> <p>The database must be installed as described in the appendix.</p> <p>MySQL must be running as described in chapter 1.</p> <p>Error message: SQLSTATE[HY000] [1049] Unknown database 'my_guitar_shop1' "</p> <p>The code seems to be correct but it is not creating users or databases in MySQL. </p> <p>Update #3</p> <p>Created the database "my_guitar_shop1" through PHPMyAdmin and now I get these errors with corresponding code just below each error message;</p> <p>( ! ) Notice: Undefined index: category_id in C:\xampp\htdocs\book_apps\ch05_guitar_shop\product_manager\index.php on line 16</p> <pre><code>if ($action == 'list_products') { // Get the current category ID $category_id = $_GET['category_id']; &lt;-----this is line #16 if (!isset($category_id)) { $category_id = 1; } </code></pre> <p>( ! ) Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\book_apps\ch05_guitar_shop\model\category_db.php on line 15</p> <pre><code>function get_category_name($category_id) { global $db; $query = "SELECT * FROM categories WHERE categoryID = $category_id"; $category = $db-&gt;query($query); $category = $category-&gt;fetch(); &lt;-----this is line #15 $category_name = $category['categoryName']; return $category_name; } </code></pre> </div>

无法启动xampp mysql服务器(已经更改3306以外的端口)

<div class="post-text" itemprop="text"> <p>I try starting the xampp mysql service and i failed. I already disable mysql service in the windows service panel and i change the ports 3306 to 3309 in the my.ini file. </p> <pre><code># The following options will be passed to all MySQL clients [client] # password = your_password port = 3309 // change here socket = "C:/xampp/mysql/mysql.sock" # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3309 // change here socket = "C:/xampp/mysql/mysql.sock" basedir = "C:/xampp/mysql" tmpdir = "C:/xampp/tmp" datadir = "C:/xampp/mysql/data" pid_file = "mysql.pid" # enable-named-pipe key_buffer = 16M max_allowed_packet = 1M sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log_error = "mysql_error.log" </code></pre> <p>However, it stills say that </p> <pre><code>5:56:19 PM [mysql] Problem detected! 5:56:19 PM [mysql] Port 3306 in use by "C:\mysql_community_server\bin\mysqld MySQL"! 5:56:19 PM [mysql] MySQL WILL NOT start without the configured ports free! 5:56:19 PM [mysql] You need to uninstall/disable/reconfigure the blocking application 5:56:19 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port </code></pre> <p>Logs:</p> <pre><code>2015-11-10 15:26:56 10fc 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. 2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled 2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used 2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions 2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M 2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool 2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda. 2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active. 2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start 2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027 2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started 2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled. 2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'. 2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events 2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown 2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events 2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting. 2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown... 2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037 2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete </code></pre> <p>Question:</p> <ol> <li><p>Why I change to port 3309 and it is still connecting to the port 3306?</p></li> <li><p>I already disable other mysql service so even though it is 3306 and it should still able to connect</p></li> </ol> </div>

如何配置XAMPP以远程连接MySQL

<div class="post-text" itemprop="text"> <p>I have a problem to connect my online MySQL database from my local system. </p> <p>I installed XAMPP on my Windows 7 and created a PHP file with this code: </p> <pre><code>&lt;?php $db_path = mysqli_connect('printcity24.com', 'printci1_admin', 'xr10s20191', 'printci1_db', '3306'); if(!$db_path) { echo mysqli_connect_error(); }else{ echo "Connected successfully"; } ?&gt; </code></pre> <p>Then i created a database on my website : www.printcity24.com </p> <p>My web host admin configured my host and opened firewall. </p> <p>When i use XAMPP command line to connect to my database every thing is ok, i can connect to my database remotely with this code : </p> <pre><code># mysql -u printci1_admin -p -h printcity24.com </code></pre> <p>but when i use php code to connect to my database i get this error : </p> <pre><code> Warning: mysqli_connect(): MySQL server has gone away in D:\Xampp Server\htdocs\st\index.php on line 2 Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in D:\Xampp Server\htdocs\st\index.php on line 2 MySQL server has gone away </code></pre> <p>I upload my php code on to other <a href="https://mehrac.ir/test/index.php" rel="nofollow noreferrer">websites</a> and test for connection and everything is "ok" but on my local xampp can't connect. </p> <p>In <a href="https://stackoverflow.com/questions/42095946/php-not-connecting-to-remote-mysql">this link</a> said i have to use this command : </p> <pre><code>setsebool -P httpd_can_network_connect=1 </code></pre> <p>but I don't know where to put this code and how to configure my xampp. </p> </div>

MySql不会在XAMPP中启动

<div class="post-text" itemprop="text"> <p>I know this question has been asked several times, I have looked through other answers but couldn't find the solution.<br> Last night MySQL was working fine on my XAMPP. Today, When I started MySQL from control panel, it started for a brief moment and then stopped immediately. I tried again but same thing happened.I completely stopped XAMPP from task manager and restarted again but no use. I checked if some other application is using port 80 at <a href="http://canyouseeme.org/" rel="nofollow">canyouseeme.org</a> but its giving an error,means port 80 is free.<br> BTW Apache is running fine.<br> Control panel log says "MySql started", but it stops immediately after that.</p> </div>

试图启动MySQL应用程序

<div class="post-text" itemprop="text"> <p>When I install xampp server on window 7 after that I run a control panel of xampp. then I start the apache service its done successfully but when I click to start the MySQL I view this type of error "Attempting to start MySQL app.." and myself didn't start what is the solution??</p> </div>

如何将MySQL与XAMPP服务器连接?

<div class="post-text" itemprop="text"> <p>Hi I'm new to SQLyog program. And I kind of got this project from my lab in my college.<br> I have to make a website using database, specifically I have to make a simple social media for my department. The tables and queries is all done, but I can't connect my MySQLto XAMPP.<br> What do I do so my database could connect to XAMPP and I can make a web out of it?</p> </div>

XAMPP中的MySQL不允许远程连接

<div class="post-text" itemprop="text"> <p>After following some online tutorials, allowing wildcard (%) connections to the user, assuring that the port and firewall allow connections, and comparing the login info, I'm at a complete loss recving MySQL error 111.</p> <p>The script I'm using to connect [PHP]</p> <pre><code>$connection = mysqli_connect('remotehost', 'user', 'pass') or die(mysqli_connect_error()); mysqli_select_db($connection, 'db'); </code></pre> <p>I believe everything is in order, isn't it?</p> <p>What should my next step be? </p> </div>

MySQL服务器在启动后关闭

<div class="post-text" itemprop="text"> <p>I tried shutting down XAMPP and deleting the ibdata1 already. Yesterday the server did still work, but when starting up today it didn't start anymore. I'm using the server for a PHP project using PHPMyAdmin. This is the error log from XAMPP: </p> <pre><code>2016-05-26 09:07:29 15a0 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. 160526 9:07:29 [Note] InnoDB: Using mutexes to ref count buffer pool pages 160526 9:07:29 [Note] InnoDB: The InnoDB memory heap is disabled 160526 9:07:29 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 160526 9:07:29 [Note] InnoDB: Memory barrier is not used 160526 9:07:29 [Note] InnoDB: Compressed tables use zlib 1.2.3 160526 9:07:29 [Note] InnoDB: Not using CPU crc32 instructions 160526 9:07:29 [Note] InnoDB: Initializing buffer pool, size = 16.0M 160526 9:07:29 [Note] InnoDB: Completed initialization of buffer pool 160526 9:07:29 [Note] InnoDB: Restoring page 0 of tablespace 0 160526 9:07:29 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0 160526 9:07:29 [ERROR] InnoDB: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1 160526 9:07:29 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data! 160526 9:07:29 [ERROR] Plugin 'InnoDB' init function returned error. 160526 9:07:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 160526 9:07:29 [Note] Plugin 'FEEDBACK' is disabled. 160526 9:07:29 [ERROR] Unknown/unsupported storage engine: InnoDB 160526 9:07:29 [ERROR] Aborting 160526 9:07:29 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete` </code></pre> </div>

MySQL数据库无法在XAMPP Manager-osx中启动

<div class="post-text" itemprop="text"> <p>I downloaded XAMPP about a month ago and it was working just fine. Today I installed a voice recognition software and then restarted my computer. Ever since, MySQL won't start in my manager-osx application. It doesn't throw me an in the application log. This is what it says:</p> <pre><code>Stopping all servers... Stopping Apache Web Server... /Applications/XAMPP/xamppfiles/apache2/scripts/ctl.sh : httpd stopped Stopping ProFTPD... Checking syntax of configuration file /Applications/XAMPP/xamppfiles/proftpd/scripts/ctl.sh : proftpd stopped Restarting all servers... Starting MySQL Database... Starting Apache Web Server... /Applications/XAMPP/xamppfiles/apache2/scripts/ctl.sh : httpd started Starting ProFTPD... Checking syntax of configuration file /Applications/XAMPP/xamppfiles/proftpd/scripts/ctl.sh : proftpd started </code></pre> <p>Both my ProFTPD and my Apache Web Server are running. MySQL isn't. When I go to phpmyadmin, it throws me this error message.</p> <pre><code>#2002 - No such file or directory The server is not responding (or the local server's socket is not correctly configured). </code></pre> <p>Please help me. I have no idea what to do.</p> <p>UPDATE: </p> <p>After looking around the internet a bit, I found a similar problem a user had with MAMP, another user recommended killing the mysql process, what ever that means. Could this be a fix to my problem?</p> <p>UPDATE 2: </p> <p>I found the answer to my problem but I can't answer it yet. So here's the answer:</p> <p>1) Open terminal and type</p> <pre><code>sudo su </code></pre> <p>and then put in your password</p> <p>2) Then type </p> <pre><code>ps aux | grep mysql </code></pre> <p>(just copy and paste this)</p> <p>3) You will need to get the process id of mysql. There should be number near the top, something like 739 or 8827</p> <p>4) Kill the process using</p> <pre><code>kill -9 {process id} </code></pre> <p>this should look something like this: kill -9 739</p> <p>5) Restart MySQL in manager-osx</p> </div>

2019 Python开发者日-培训

2019 Python开发者日-培训

150讲轻松搞定Python网络爬虫

150讲轻松搞定Python网络爬虫

设计模式(JAVA语言实现)--20种设计模式附带源码

设计模式(JAVA语言实现)--20种设计模式附带源码

YOLOv3目标检测实战:训练自己的数据集

YOLOv3目标检测实战:训练自己的数据集

java后台+微信小程序 实现完整的点餐系统

java后台+微信小程序 实现完整的点餐系统

三个项目玩转深度学习(附1G源码)

三个项目玩转深度学习(附1G源码)

初级玩转Linux+Ubuntu(嵌入式开发基础课程)

初级玩转Linux+Ubuntu(嵌入式开发基础课程)

2019 AI开发者大会

2019 AI开发者大会

玩转Linux:常用命令实例指南

玩转Linux:常用命令实例指南

一学即懂的计算机视觉(第一季)

一学即懂的计算机视觉(第一季)

4小时玩转微信小程序——基础入门与微信支付实战

4小时玩转微信小程序——基础入门与微信支付实战

Git 实用技巧

Git 实用技巧

Python数据清洗实战入门

Python数据清洗实战入门

使用TensorFlow+keras快速构建图像分类模型

使用TensorFlow+keras快速构建图像分类模型

实用主义学Python(小白也容易上手的Python实用案例)

实用主义学Python(小白也容易上手的Python实用案例)

程序员的算法通关课:知己知彼(第一季)

程序员的算法通关课:知己知彼(第一季)

MySQL数据库从入门到实战应用

MySQL数据库从入门到实战应用

机器学习初学者必会的案例精讲

机器学习初学者必会的案例精讲

手把手实现Java图书管理系统(附源码)

手把手实现Java图书管理系统(附源码)

极简JAVA学习营第四期(报名以后加助教微信:eduxy-1)

极简JAVA学习营第四期(报名以后加助教微信:eduxy-1)

.net core快速开发框架

.net core快速开发框架

玩转Python-Python3基础入门

玩转Python-Python3基础入门

Python数据挖掘简易入门

Python数据挖掘简易入门

微信公众平台开发入门

微信公众平台开发入门

程序员的兼职技能课

程序员的兼职技能课

Windows版YOLOv4目标检测实战:训练自己的数据集

Windows版YOLOv4目标检测实战:训练自己的数据集

HoloLens2开发入门教程

HoloLens2开发入门教程

微信小程序开发实战

微信小程序开发实战

Java8零基础入门视频教程

Java8零基础入门视频教程

相关热词 c#跨线程停止timer c#批量写入sql数据库 c# 自动安装浏览器 c#语言基础考试题 c# 偏移量打印是什么 c# 绘制曲线图 c#框体中的退出函数 c# 按钮透明背景 c# idl 混编出错 c#在位置0处没有任何行
立即提问