Geek Answers Handbook

XAMPP - Error: MySQL shutdown unexpectedly

For some reason, I reinstalled XAMPP and MySQL does not work, as a result of which the following error appeared in the console:

01:56:03 [mysql] Error: MySQL shutdown unexpectedly. 01:56:03 [mysql] This may be due to a blocked port, missing dependencies, 01:56:03 [mysql] improper privileges, a crash, or a shutdown by another method. 01:56:03 [mysql] Check the "/xampp/mysql/data/mysql_error.log" file 01:56:03 [mysql] and the Windows Event Viewer for more clues

When checking the file "/xampp/mysql/data/mysql_error.log" I get:

 130302 1:48:06 InnoDB: Waiting for the background threads to start 130302 1:48:07 InnoDB: 1.1.8 started; log sequence number 1600324627 130302 1:48:07 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130302 1:48:07 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130302 1:48:07 [Note] Server socket created on IP: '0.0.0.0'. 130302 1:51:12 [Note] Plugin 'FEDERATED' is disabled. 130302 1:51:12 InnoDB: The InnoDB memory heap is disabled 130302 1:51:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130302 1:51:12 InnoDB: Compressed tables use zlib 1.2.3 130302 1:51:12 InnoDB: Initializing buffer pool, size = 16.0M 130302 1:51:12 InnoDB: Completed initialization of buffer pool 130302 1:51:12 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130302 1:51:12 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130302 1:51:13 InnoDB: Waiting for the background threads to start 130302 1:51:14 InnoDB: 1.1.8 started; log sequence number 1600324627 130302 1:51:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130302 1:51:14 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130302 1:51:14 [Note] Server socket created on IP: '0.0.0.0'. 130302 1:56:01 [Note] Plugin 'FEDERATED' is disabled. 130302 1:56:01 InnoDB: The InnoDB memory heap is disabled 130302 1:56:01 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130302 1:56:01 InnoDB: Compressed tables use zlib 1.2.3 130302 1:56:01 InnoDB: Initializing buffer pool, size = 16.0M 130302 1:56:01 InnoDB: Completed initialization of buffer pool 130302 1:56:01 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130302 1:56:01 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130302 1:56:02 InnoDB: Waiting for the background threads to start 130302 1:56:03 InnoDB: 1.1.8 started; log sequence number 1600324627 130302 1:56:03 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130302 1:56:03 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130302 1:56:03 [Note] Server socket created on IP: '0.0.0.0'.

This is just part of the magazine, the full is too big.

reference

+7
source share
18 answers

Close your skype and try if skype is opne

or

Go to your xampp / wamp, find httpd.conf. Open this file using the text panel / notepad, search for Listen or 80, update the listening port to 8081 and save the file. Restart xampp / wamp, start the servers.


or follow these steps in skype enter image description here

+6
source

In my case, I did two things:

  • moved xampp/mysql/backup files to xampp/mysql/data
  • RUN XAMPP as administrator

It worked for me :)

+9
source

You must:

  • Close xampp
  • Go to the folder where you installed it, if in (c :) there could be something like C: \ xampp \, access folder C: \ xampp \ mysql \ data strong>
  • Delete ibdata1 file
  • starts XAMPP again.
+3
source

It worked for me

  • exit XAMPP
  • cut all files in C: \ xampp \ mysql \ backup
  • insert and replace files in C: \ xampp \ mysql \ data strong>
  • run as XAMPP administrator
+2
source

Perhaps the MySQL server installed previously on your computer will try to uninstall it and run MySQL on XAMPP. This is resolved.

+1
source

The best solution for this problem is to simply open the mysql my.ini configuration configuration file present in the C: \ xampp \ mysql \ bin folder and change the information associated with the ports, usually some programs take port no. 3306 as a result of the fact that it stops working. Now you follow two steps to get it working.

 enter code here Step-1. Search for ['client'], you can see some thing like this [client] # password = your_password port = 3306 socket = "C:/xampp/mysql/mysql.sock" Now in the port section remove 3306 and add port = 3306 > 3307 as shown below. [client] # password = your_password port = 3306 > 3307 socket = "C:/xampp/mysql/mysql.sock" Step -2. Similarly Search for ['mysqld'], you can see something like this [mysqld] port= 3306 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" Now here change the port number 3306 to 3307 and add a line "innodb_force_recovery = 1" exactly as shown below. [mysqld] port= 3307 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" innodb_force_recovery = 1

Here it is, restart the mysql service, it will work for sure.

+1
source

I will just try reinstalling XAMPP.

0
source

one of the reasons I found (and was not mentioned in addition to the other answers given on this site for a similar problem) was to go to the task manager on Windows and stop mysqld that is already running and prevent the server from starting mysql.

0
source

just run your xammp as administrator, it works

0
source

For those who searched and clicked on this link, I decided to just find the mysql alert and stop mysql from starting. Then run mysql again in xampp and it will start. why does it work? iam is not an expert, but I think it’s easy: the port was already taken with mysql notifier, so I had to stop it and run it here.

0
source

I am new to XAMPP, but I find that a combination of these suggestions works best (at least on Windows 8.1 with the latest version of XAMPP. Note that the computer I tested on this also had skype).

Log in to Skype first and go to "Tools <Options <Advanced <Connection." Then check the box "Use port 80 and 443 for additional inbound connections." Save, close and exit skype mode.

Then, on the XAMPP control panel, click "config <my.ini" and change lines 19 and 27 (must have port = 3306) from "3306" to "3307".

In addition, you will need to go to xampp <phpMyAdmin <config.inc and change line 27, which should look something like this:

$ cfg ['Servers'] [$ i] ['host'] = '127.0.0.1';

You need to add "3307" as follows:

$ cfg ['Servers'] [$ i] ['host'] = '127.0.0.1lla307';

Now open your browser and you will see the xampp page when you enter "localhost". Also, if you are using xampp for the first time, you can see a warning about your password shortage (highlighted in pink) on your localhost / phpmyadmin / page. This can be easily fixed by going to the "user accounts" tab in phpmyadmin, clicking "change permissions" and entering the password. Remember to save the hashed version of all and all passwords that you create, as we will use this further! - I opened the notebook and saved (and numbered) them. Please note that phpMyadmin will notify you that you are changing the password for the current session (this will appear at the top of the phpMyadmin page and is very important since you will need a specific hashed version of your password).

Then you will need to go to the next address "xampp <phpMyAdmin <config.inc" on your computer and open and edit the file using a text editor. You want to put a hashed version of your password between single quotes for the password and change "AllowNoPassword" from true to false.

And that should do it.

0
source

In my case: I just replaced

 ....xampp/mysql/backup files

in

 **xampp/mysql/data**

It worked for me.

0
source

If Apache works without any problems and you find some locks on the system’s security settings, just let it instead of blocking or closing the dialog box. And change the port number for MySQL to 3607, as it was before 3606. This worked for me.

0
source

if you are inistalled mysql independently you can stop the mysql service when starting none of these answers work for me this work for me

0
source

Okay, first, I know it late, so I don’t know if anyone can promote it, but, oh, okay, well, secondly, removing xampp may not do you any good, because the process using port 3306 ( the default port is Mysql), it will still work somewhere on your system. may be skype, but may not be skype.

therefore, the best way is to find out which process uses port 3306 and then terminate the process.

to find out which process uses port 3306, open a command prompt and enter

 netstat -n -o -a

you will get a screen like this.

Then find the address with the port number 3306 and find out the corresponding PID.

Then just open a command prompt as administrator and type

 taskkill /F /PID 1234

replace 1234 with your PID. Then you can try running mysql and it will work.

And now, if you are too lazy to take this step again when you restart your computer ,,

you can simply use the following batch version of the script to automatically end the process and use :)

 @echo off setlocal enableextensions set "port=3306" for /f "tokens=1,4,5" %%a in ( 'netstat -aon ^| findstr /r /c:"[TU][CD]P[^[]*\[::\]:%port%"' ) do if "%%a"=="UDP" (taskkill /F /PID %%b) else (taskkill /f /PID %%c) endlocal pause

save it as anything.bat and run it every time you want to use mysql. :)

0
source

** → "xampp-> mysql-> data" cut all files from the data folder and paste into another folder

→ Now restart MySQL

→ paste all folders from your folder into myslq-> data folder

and also insert ib_logfile0.ib_logfile1, ibdata1 into the data folder from your folder.

your database and your data are now available in phpmyadmin .. **

0
source

If installing 2 XAMP, the same error occurred. First of all, the test Xamp is installed

0
source

The true way to RECONFIGURE your application. with MYSQL setup. You can open your setup again and change the port from 3306 to 3307 .

enter image description here

-2
source

More articles:


All Articles