My Blogger

Since you are on the Windows machine, these things can be done, * Execute the following command and look for a ":3306" listener (you did not mention UDP/TCP). This will confirm there is something running on the port. netstat -a -n * After this, if you are expecting incoming connections on this port and feel that the firewall may be blocking them, you could start windows firewall logging and check the logs for dropped connections o Go to the Windows Firewall, Advanced settings o Click on the Settings button next to "Local Area Connection" o Select "Log dropped packets" o Look at the log file location (if not present define one) o Click OK o Now, when the connection attempt is made (assuming you know when this is done), look at the log file for a drop on port 3306. o If this is seen, you will want to add an exception for this port. * There is one more command to check the

1. Location file 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 2. How to check port Type netstat -a -n in the command prompt 3. method 1. location file: xampp/mysql/bin (without extention) 2. open notepad n find location, change to all file format type . Find that file n open. 3. Change port number to 3307 or any port available. This example my file. # Example MySQL config file for small systems. # # This is for a system with little memory (<= 64M) where MySQL is only used # from time to time and it's important that the mysqld daemon # doesn't use much resources. # # You can copy this file to # C:/xampp/mysql/bin/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is C:/xampp/mysql/data) or #