CODEWITHSUNDEEP
phpmysqllaravelxampp
Fatih Can
Fatih Can

Reputation: 499

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 .

Upvotes: 0

Views: 4745

Answers (4)

Muhammet
Muhammet

Reputation: 446

Go to Services and stop MySQL80. It worked to me.

Upvotes: 0

Saheed
Saheed

Reputation: 312

The error message says you might already have a server running on port 445.

On your terminal, try shutting down all xammp server then restart xammp.

C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin" −u root shutdown

Upvotes: 1

Dhruvik Ghevariya
Dhruvik Ghevariya

Reputation: 134

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

Upvotes: 1

r0pe-12
r0pe-12

Reputation: 77

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

Upvotes: 0

Related Questions