Completely Unistall MySQL

Whenever you install MySQL, uninstall it and try to install it again, you might not be able to do so because MySQL will ask for the old password. You cannot install MySQL if you do not have the old password. Solution for this is:

• Uninstall MySQL
• Go to your MySQL installation folder for e.g. C:\Program Files and delete the MySQL folder
• Delete MySQL from your AppData folder. I am using windows XP and in my case, the location is C:\Documents and Settings\All Users\Application Data. Here you will find MySQL folder. Delete this folder.
• Finally, reinstall MySQL and you should be able to install it successfully.

Slow Connection to MySQL installed on windows from linux (Solved)

If you have MySQL installed in Windows server and you are querying from Linux, you might notice that the performance of you application is very slow. This is because, when your application in Linux connects to database in Windows, even a simple query takes 3-4 seconds to execute.

The solution for this problem is to put a line 'skip-nam-resovle' in my.ini of your mysql server. Search for [mysqld] in my.ini and put that line below it as below.

[mysqld]
skip-name-resolve