Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours on Instagram and YouTube and waste money on coffee and fast food, but won’t spend 30 minutes a day learning skills to boost our careers.
Master in DevOps, SRE, DevSecOps & MLOps!

Learn from Guru Rajesh Kumar and double your salary in just one year.


Get Started Now!

How to Fix MySql port 3306 already in use Error/another instance already running.

There are two types of errors  which occur in MySql are as follows:-

  1. Another instance is already running:- This error occurs when MySql has been installed by you in command-line (cmd) before installing XAMPP server.
    ▪Open cmd and run as administrator
    ▪So, type this in command-line (cmd ) = “sc delete mysql”
    ▪It will show you that running instance has deleted succesfully.

2. MySql port 3306 already in use error:-
Often , this error occurs when  XAMPP or MAMP is used for  configuring to start MySQL and PHP on system startup and by default MySQL uses port 3306.
We have to change this port from old to new one like this :-
▪Firstly you have to open XAMPP Control Panel.
▪Just click MySql config button->click my.ini file
▪It will open in Notepad , after that u have to find and change port no from 3306 to 3307 in two places
▪ Save it. 

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.