MySQL Bugs: #60446: Re-installing issues.

Bug #60446	Re-installing issues.
Submitted:	13 Mar 2011 1:07	Modified:	14 Mar 2011 4:05
Reporter:	Sam Walker	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.5.9	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Failure, installation

Description:
The first time I installed mysql from here http://dev.mysql.com/downloads/mirror.php?id=401808
everything went fine. So fine that I was very very happy. The reason I couldn't keep it like that was because I had to have it run on a different port. So, I uninstalled it, went through the procedure, and reinstalled it....during the final phase of reinstallation (when you use the Instance Configuration Wizard) it froze...(when it had to write to some system file after i hit execute)

It still freezes when I try to install it. Best part is, when I go to reinstall it, I get the "A Windows service with the name MySQL
already exists. Please uninstall this service correctly or choose a different name for the new service." error....

So I used a different name...now I try it under mysql workbench and I get error code 10061...

Things iv tried:Uninstalling, clearing registry....
none have been successful

How to repeat:
Install mysql
Uninstall mysql
Reinstall mysql

To remove the service execute from a command shell "sc delete mysql" ("sc" command means 'service control' and service names are case insensitive).  It is a knowb problem with the 64 bit uninstaller that it does not remove the service completely - refer: http://bugs.mysql.com/bug.php?id=45050

But you did not need to do all this to change the port.  In your configuration file (my.ini in the installation folder) you have a setting "port={port_no}". You only need to edit the port number in the file and restart the server (using either commands "net stop mysql" + "net start mysql" or using the service manager from Control Panel .. Administration .. Services).

Peter
(not a MySQL person)

I try to run that command in command prompt after I uninstalled mysql and workbench. I get an access denied error??

Not to mention I am an administrator so...why would I get a denied error?

http://sfxworks.comxa.com/bb4.png

This is because you have UAC ('User Account Control') enabled.  Even administrators do not automatically have full admin privileges with UAC on in Vista and later Windows.

Try this: 
Start menu .. accessories .. *right click* command prompt .. select 'run as administrator' and now try the command (or turn off UAC from Control Panel .. User management).

That worked. But...
I successfully reinstalled mysql. When I run the configuration wizard however, it freezes up. Its been frozen like this for a good 10 minutes. This is what has been happening every time I try to reinstall it. The first time it didn't do this but...ever since then..

http://sfxworks.comxa.com/bb5.png

There are lots of similar reports.  Forget about the configuration wizard. Simply skip/close/kill it.

If server is running (check for a 'mysqld.exe' process in Task Manager) you should now be able to connect to the server as 'root' with either an empty password or your old password. You can do what the config wizard does with any client easily. 

If server is not running try start it with "net start mysql" command (as administrator!).

As you have an old instance that was uninstalled you most likely already have 'security settings' intact from your previous installation.

.. but you may need manually to open the new port you use ..

Thanks for working with me so far.

I closed out the wizard but now im running into another problem...
When trying to start mysql through command prompt I get an error.

http://sfxworks.comxa.com/bb6.png

Do you have a my.ini file or was it deleted?

I did a search for it and yes I do. Why?

Infact I have two...
One from mysql and one from WAMP i installed a long time ago.

@Sam .. this is not a bug report any more.  I think it is clear that you have encountered http://bugs.mysql.com/bug.php?id=45050 (of which this should be considered a duplicate) and a posssible few more bugs (all of which it is very annoying that were not fixed). 

I think MySQL people should help you here - though they may ask you to do to the MySQL Forums (as 'this is not an appropriate place to ask support - SIGH!).

It is very simple to resolve actually, but I feel I have no right to continue here.  If you don't get help from MySQL I'd be happy to help you at our/Webyog Forums (http://www.webyog.com/forums). If you post in MySQL Forums I will not.  I do not attend it as the worst abuse/insult I have ever experienced in my life happened there by the most idiotic MySQL developer ever existing (and they/he deleted the post so I cannot link to it).

I made a form posts...
http://www.webyog.com/forums/index.php?showtopic=6034

Also you mentioned in the bug report something about purging my registry?
How would I do that? Or is that the command line you were talking about?

I apologize if I didn't put it in the right area..

Don't worry.  I have replied anyway here http://www.webyog.com/forums/index.php?showtopic=6034.

If you both agree that this is a duplicate of bug #45050 - let it be so.