Friday 15 April 2011

Re-installing MySql 5.1 notes

Using our MySql 5.1 install guide helps to get you up and running fast. We might include a 5.5 / 5.6 update at some point but i thought this note on re-installing might be of use to those who encounter reinstalling issues.

These notes are in reference to installing an established third party software program on apache-windows.

The Most important part of MySql setup is to record your username/passwords when you first setup MySql. Nothing can test or use the database without this (i would still ignore all VC9 versions until after you get it all working, there are still things that are not VC9 compatible and this side-steps any potential issue. Php 5.3.6 for windows is only moderately open source because not all of the files required to compile the windows source code are easily accessible at this time. So, this means not all can easily compile their own VC6 version yet either).

Your error appears to be that you did not include the correct username password for MySql. And because MySql was not removed properly (not your fault), MySql was not re-installed properly, so just having the right user/pass might not have fixed the problem anyway.

Yes, use windows add-remove first and then you will also need to remove the left over files/folders for both 5.5. and/or 5.1 manually. You will find that these folders still exist. Delete them if there is nothing in your database or move them somewhere else for now if there is anything in them you think you might need later. You can also do a full search for my.ini to make sure the ini file is gone or moved. I would probably re-boot after these steps just to be sure there is no lingering configuration data in memory.

When you get rid of MySql completely, it will re-install like a first time installation. Yes, the custom setup guide displays the windows in a different in order. This gives more control to the installation process and is better to use.

You can also ignore extra developer options in fig. 04, no-one needs these for normal database use. Only useful for developers.

No comments:

Post a Comment

Important Note:

Anyone is free to post links here but only if a back link to this site (or www.websiteadministrator.com.au) is added from your blog or website.