lorz’s blog

blog • programming • web design • tutorials • seo

Archive for the ‘MySQL’ Category

Apache slow on Windows Vista? Not anymore!

Have you ever encountered a 2-3 second delay when loading your local pages on Windows Vista and thought “Windows Vista sucks” and after that reinstalled good old XP?

Well, the problem lays in the HOSTS file. There is a line there which slows Apache. (sincerely, I don’t know why).

So, to solve the problem:

1. Open Windows Explorer and choose the partition where you have Windows Vista installed;

2. Navigate to Windows -> system32 -> drivers -> etc

3. Open the HOSTS file with Notepad.

4. Find the line “::1             localhost” and put a “#” symbol before it

5. Save the file with Ctrl + S and restart your Apache server.

After completing these steps, you should not experience loading problems anymore.

HiJackThis utility from TrendMicro™ and MySQL

Yesterday I downloaded HiJackThis utility from TrendMicro™ to get rid of the Bonjour Service from Adobe. I got rid of that but I also unintentionally got rid of MySQL, today getting a beautiful message on localhost:

Could not connect to MySQL: Can’t connect to MySQL server on ‘localhost’ (10061)

So, if you have MySQL on your localhost, don’t use HiJackThis unless you want to reinstall some parts of your server.