Help on XAMPP - Mysql wont start

400kg · Jan 10, 2021

I am working on creating a website on my pc. I am using Xampp and wordpress. Yesterday all was ok . Today when starting Xampp control pannel , started apache ok, started mysql has gived me this error:

Code:

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

In mysql error log , i cant understand much whats there.

Code:

2021-01-10 18:38:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-10 18:38:29 0 [Note] InnoDB: Uses event mutexes
2021-01-10 18:38:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-10 18:38:29 0 [Note] InnoDB: Number of pools: 1
2021-01-10 18:38:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-10 18:38:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-10 18:38:29 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-10 18:38:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-10 18:38:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-10 18:38:29 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-10 18:38:29 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-10 18:38:29 0 [Note] InnoDB: Waiting for purge to start
2021-01-10 18:38:29 0 [Note] InnoDB: 10.4.14 started; log sequence number 237419649; transaction id 148362
2021-01-10 18:38:29 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-10 18:38:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-10 18:38:29 0 [Note] Server socket created on IP: '::'.

I have tried to change the port of the mysql like in all videos from youtube but didnt help. I dont want to lose the data created on my xampp.
Is there any solution in making mysql work again ? I didnt install any program , didnt modify anything on the pc. Only making the wordpress site.

UpwardDescent · Jan 10, 2021

Are you running any processes that you weren't last time?
Something on your machine is using the same port as MYSQL.

400kg · Jan 10, 2021

I'm not using anything thats the big question for me. I started normaly my pc and after that xampp. Saw that mysql gives me that error . Tried fixing changing port 3306 to 3307 , 3308...3325 in mysql ... my.ini and same in the xampp service setings / mysql port . But changing the port for mysql is giving me the same error. In xampp, netstats there is nothing that is using mysql port, but mysql still not starting . Any solutions ?

CyHead · Jan 10, 2021

Close Xampp, you might have to shut it down with task manager (look for all SQL processes & services).

Then right click on Xampp and go to Run as administrator. Once it loads up, click on start if it doesn't auto-start. You should see it turn green, if not it might be you have a conflict or your computer/firewall/antirvirus is blocking the port it's running off of.

400kg · Jan 10, 2021

Xamp is always runing as administrator because i had some errors before. I have tried restarting the pc but no luck. I deactivated the antivirus and firewall but same , no luck . This is the strangest thing happened so far, with no reason doesnt work anymore. I have tried for a test to replace the content fromy mysql / backup folder to mysql / data folder , and its working afte replacing the files. But all my data is gone, so its not a good solution for me.

simovada · Jan 10, 2021

Change port and it will work

400kg · Jan 10, 2021

I have changed the port but same error. But if i copy from mysql/backkup folder to mysql/data folder and replace all the content. The mysql is working but im losing all my data.

V · Jan 10, 2021

Do you use Skype? A few years ago, I also experienced the same problem, and Skype was somehow interfering with XAMPP. I don't know if that's the case now.

D'aconia · Jan 10, 2021

Well if the port think doesn't help. I few year ago used next method

Rename the folder mysql/data (reccomenden mysql/data_old but you can use any name
Create a new folder mysql/data
Copy the content that resides in mysql/backup to the new mysql/data folder
Copy all your database folders that are in your old folder we renamed on step 1 to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders)
Finally copy the ibdata1 file from folder you renamed in step 1 and replace it inside mysql/data folder
Start MySQL from XAMPP control panel

That helped me. I found this solution somewhere on stackoverflow.

V said:
Do you use Skype? A few years ago, I also experienced the same problem, and Skype was somehow interfering with XAMPP. I don't know if that's the case now.

Because they used same port (80) so this is not the case in this situation.

400kg · Jan 10, 2021

Hi, i dont use skybe but i have fixed the problem after 4 hours .
I have tried and read all the internet but found only one fix for my problem .

This video explains all

If not the 3306 port is the problem then you need to add the folowing line in mysql/bin/my.ini under the [mysqld]

Code:

skip-grant-tables

Don't do delete any files from xampp if you have important data. Youtube is full of stupid videos and tutorials. Just follow the steps from the video in the link.

400kg · Jan 10, 2021

D'aconia said:
Well if the port think doesn't help. I few year ago used next method

Rename the folder mysql/data (reccomenden mysql/data_old but you can use any name

Create a new folder mysql/data

Copy the content that resides in mysql/backup to the new mysql/data folder

Copy all your database folders that are in your old folder we renamed on step 1 to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders)

Finally copy the ibdata1 file from folder you renamed in step 1 and replace it inside mysql/data folder

Start MySQL from XAMPP control panel

That helped me. I found this solution somewhere on stackoverflow.

Because they used same port (80) so this is not the case in this situation.

This can be another solution . Thanks for it, but i have found the problem after 4 hours of searching.

Help on XAMPP - Mysql wont start

400kg

Registered Member

UpwardDescent

Junior Member

400kg

Registered Member

CyHead

Supreme Member

400kg

Registered Member

simovada

Newbie

400kg

Registered Member

V

Elite Member

D'aconia

Registered Member

400kg

Registered Member

400kg

Registered Member

Main Menu

Marketplace

Making Money

BlackHat World