Need help to open port 3306

2 posts

1. edenvalen
   
   Regular
   Joined: Jun '08
   Posts: 85

   Hi,
   I occured port 3306 not open error while configurating the MySQL.
   Can anyone help me? thanks.. eden

   Posted 1 year ago » Permalink

2. edenvalen
   
   Regular
   Joined: Jun '08
   Posts: 85

   After much finding, i found someone in MySQL forum using this method and it help, my problem resolved. Hope this help you too..

   
I'd been having the "Can't connect to MySQL server on localhost (10061)" issue for a couple of days trying to read through the posts here an there on how people solved the issue. Nothing was working for me. Found out I needed to open the port on the windows firewall (Windows NT SP2). But still was having no luck; I opened the port, opened the programs mysqld_nt and mysql on the windows firewall - shutdown and rebooted, then, even after that, with "telnet localhost 3306", It was giving me the error it couldn't connect to the port.

   But - I finally solved the issue! I went to the C:/mysql/data folder, deleted the ib_logfile0, ibdata1 and ib_logfile1 files,
   ran this: "C:\MySQL\bin\mysqld-nt" --defaults-file="C:\MySQL\my.ini" MySQL

   and I am finally able to see the database - and the mysqld-nt process running in the task manager!

   Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.