Continued From Bugs.mysql.com…

[sfxworkos]

I am trying to solve this problem. Mysql has been a real annoyance with uninstallation and reinstallation. I need help. Basically I am having trouble installing and launching mysql. Could anyone help me?

Full details can be found in this bug report.

http://bugs.mysql.com/bug.php?id=60446

Ps. Thank you Peter Laursen for helping me so far.

[peterlaursen]

The question is: from your first MySQL 5.5 installation do you have any important data?

1)

If not and if you are willing to discard *completely* the first MySQL 5.5 you had and all data stored with it then do this

* uninstall again from Control Panel

* remove service with 'sc' command as we have discussed

* delete (or better rename) the folders “C:Program FilesMySQLMySQL Server 5.5” and “C:ProgramDataMySQLMySQL Server 5.5” (they may have localized names)

* Now *everything* from first installation is removed from the system and you should be able run install MySQL 5.5 again with the .msi intaller + config wizard

2)

If you have some data you need to keep you can

* start the server with the commands as below

Quote:

C:UsersPeter>cd Program FilesMySQLMySQL Server 5.5bin

C:Program FilesMySQLMySQL Server 5.5bin>mysqld –no-defaults –skip-grant-tables

This will start the server on port 3306 so first ensure that no other instance uses that port (shut down your XAMPP instance in advance if it does).

* You can now connect with any client as 'root' user and *empty* password and backup your data. In attached image

[attachment=1553:connect.jpg]

.. I show that SQLyog connects. If you use SQLyog TRIAL just right-click each database you want to keep and select 'backup as SQL dump' (one more image).

[attachment=1554:backup.jpg]

* when you have backed up all your databases stop/kill the 'mysqld.exe' process started from command line and continue as described in 1)

* and at last restore your backups (in SQLyog you do from tools .. execute SQL script menu)

— as regards 2) there are more ways (such as creating a my.ini manually), but I think I understand you feel most safe about using the installer.

[sfxworkos]

hank you. I had no important data so this helped clear everything out. The installation worked and everything.

The last thing is I am using the mysql workbench to test the connection. I entered the port, but what would I use as the username since it was not set? (The password was set inside the configuration wizard during installation.)

[sfxworkos]

Also, would it be better to use this program? SQLyog that is.

[peterlaursen]

As regards Workbench versus SQLyog this is our position on that:

http://www.webyog.com/faq/content/5/133/en/i-am-already-using-gui-tools-from-mysql-why-should-i-buy-sqlyog.html

I do not understand the question as regards the password. The password defined in the wizard should work for all clients.

[iand123]

Hi sorry to jump in on this but i am having the same issue

I had issues with Mysql last week after it would not restart after a reboot. Luckily i have backed the data up and moved it temporarily to another server. SO i am now trying to install Mysql again onto my windows server 2008 machine. i have tried multiple times in uninstalling Mysql, reinstalling it, using different ports etc and i am just having no luck. ive even tried with different versions of mysql (i originally had v5.1 installed and v5.5 wont work either). WHen i get the server configuration instance window it just hangs on starting the service. I have checked the .err file and all it says is

110317 19:43:17 [Note] Plugin 'FEDERATED' is disabled.

110317 19:43:17 [Note] Plugin 'InnoDB' is disabled.

Has anyone got any ideas? Ive search around online and i just cannot find anything that is of any use. Followed the instrcutions above and still no luck.

Thanks guys

Ian

[iand123]

ok a break through of sorts….

the service still refuses to start but if i kill the service start and run the following from the command line

mysqld –defaults-file=”C:Program FilesMySQLMySQL Server 5.1my.ini”

mysql is then accessible and works fine

[peterlaursen]

You will find quite a lot of similar reports in MySQL Forums and bugs.mysql.com. Here it won't start as a service but starts as a 'user program'. I am not sure what could be the reason here but it looks like related to the service.

You could try to remove the service with “sc delete servicename” command and install it again with “mysqld install servicename –defaults-file= ….” command or do a fresh install after completely removing the old one (following the four steps in my reply to sfxworkos user).

[Author]

Posts