'XAMPP - Error: MySQL shutdown unexpectedly / Blocked Port

I just installed Visual Studio 2022 Community . After that Xampp gives blocked port error.

Then I uninstall VS22 but still the same.

Error:

180718 12:43:04 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
180718 12:43:04 [ERROR] Do you already have another mysqld server running on port: 445?
180718 12:43:04 [ERROR] Aborting

I checked connections and I don't know if it matters but doesn't have 3306 port.

enter image description here

I've tried to change ports in config files but still doesn't work .

phpmysqllaravelxampp


Solution 1:[1]

It say your server is already running use on terminal C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin" ?u root shutdown to shut it down thhen restart xammp

Solution 2:[2]

Instead, first try using the MySQL backup folder which is included with XAMPP. So do next steps:

  1. Rename folder mysql/data to mysql/data_old
  2. Make a copy of mysql/backup folder and name it as mysql/data
  3. Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, and phpmyadmin folders)
  4. Copy mysql/data_old/ibdata1 file into mysql/data folder
  5. Start MySQL from XAMPP control panel

Solution 3:[3]

I would suggest you to use Homestad. It is lot easier to use

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Saheed
Solution 2 Dhruvik Ghevariya
Solution 3 r0pe-12

Related Questions