Thursday, February 21, 2008

MySQL Reconfiguration problems.

MySQL has some bugs, may be a bug, i am not sure, may be my wrong configuration.

if do reconfig, it will get error during excuting the details, actually in starting the service.

after do some research, i found a related answer as below. in today's case, it should be the old entries still in the registry.

Obviously there are some bugs, which might interact with each other:
a) Pathnames, as proposed, with included blanks (and probably dots, etc).
b) A security/acl issue when trying to alter the security settings.
c) When there a old entries in the registry...

Hopefully, somebody of MySQL AB will recognise this to be a problem, since this is a annoying bug. The follwing receipt helped me on both 'essential' versons, MySQL Vs. 4.1.9 and 5.0.2, respectively.

Hope, it helps! ... regards, A.N.


Gary Williams wrote:
> Hi Guys,
>
> I've had exactly the same problem and this is how
> I got it working for me, starting with a non
> working installation.
>
> 1. Stop the windows service for any existing mysql
> installation.
>
> 2. Uninstall Mysql.
>
> As with most uninstalls, old files are left
> behind. If your directory is C:\mysql\ etc then
> delete the innob, etc, files but leave the
> directories themselves as well as any existing
> databases in 'data'. If your directory is
> C:\Program Files\ etc, delete all the mysql
> directories.
>
> 3. It's now worth running regedit to make sure
> the old registry entries are deleted as well by
> the uninstall. If not, delete them.
>
> 4. It's ok to use the new .msi installer
> (essential files only), however ....
>
> 5. Do not use their default install path! Some
> genius set a path with spaces in it! Choose the
> custom install and select a sensible path, ie,
> C:\mysql
>
> 6. Do not choose to alter the security settings.
> Uncheck the relevant box and the install will
> complete without having to set a root password.
>
> I think I have remembered everything.
>
> Good luck
>
> Gary

No comments: