port 3306 being used

[evios]

I'm currently working on my project. I use Vertrigo as my virtual server. However recently i always see this message when i use it....
MySQL database server does not work correctly. Check whether other applications use the important port (3306)...
i'd no clue at all but then i reconfigure my MySQL..problem still persist.
Any solution here? How do i check whether any application using that port as well? Thanks

[nav33n]

hmm.. AFAIK, only mysql uses port 3306. To check what ports are being used, open command prompt and type netstat -ab. It ll list all the applications and the ports used by those applications.

Maybe that port is blocked by your firewall ?

[kv79]

Did you ever install any web sever like Apache .
1) First you might know that MySQL and MS SQL do not like each other .

Correct me if I am wrong .

[vijayr]

I have the same prob too :-( Any suggestions?

[peter_budo]

I have the same prob too :-( Any suggestions?

That problem description is very inacurate, you better provide full description of your problem...

[vijayr]

I installed vertrigo server. The installation went smoothly, the only thing I changed was the installation path, instead of c:\program files... I gave C:\software.

When I attempt to start vertrigoserv, I can start Apache, PHP work correctly, but not MySQL.

[alkafy]

After MUCH Googling, I couldn't find the solution to this very same problem until I had an epiphany. MySQL would always run fine on installation, but it would error when it was started again any time after that. This led me to the solution:

If you are using Windows Vista, right click your Vertrigo shortcut and select "Run as Administrator."

I pulled my hair out looking for this solution and it's so obvious. I hope this helps anyone else with the same trouble.

[varmadba]

As the Error Says 3306 is being used by some other application

user netstat to find out which application is using it or try turnning off firewall if any

or else you have to use different port for Mysql

[muztang101]

MySql database server does not work correctly. check whether other application use the

important por(3306)and terminate them.Moreover, check firewall settings and correctness the

configuration files <--- what should i do to solve the problem

[varmadba]

you will find

port=3306

in my.ini or my.cnf file
change that to some thing else say 3307 n try

or you have to check if any other application is using it
go to CMD and type netstat ,there you will find if 3306 is in use or not
if no application is using 3306 try disabling firewall

[learner_2009]

same problem running in windows 7, just run by administrator then problem gone. thanks alkafy

[weeldiin]

thank u very much it works thanks a lot

[soyouare]

Hi I know this is an Old Thread but I would like to answer this for any one who looks, It may not be a program using the port but a service, Such at apache or apache-Tomcat if they are running End the service and your port should be open.

[ma.podoplelov]

Hello fellows. i had the same problem, and solved it this way:
i discovered that i already have mysql installed on my machine by another program, and so it was running as a win service. so i killed it and then installed full mysql
hope it will help.

sorry for my english.

[melody_1]

the same problem also appeared on my vertrigo, and in the CMD window i find mysqld.exe was using the 3306, that confused me, mysqld and mysql database have conflicts？

[Viki_1]

You need to find out the reason for blocking the port.

[AnnDash]

I advise you to use a special tool that checks the operation of ports. So much easier to control their work than to check manually.

[AnnDash]

What tool do you use to check ports? For example https://www.host-tracker.com/InstantCheck/Create/?type=Port It is easier to find the problem and fix it.