Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I had MySQL 5.1 running on Windows Server 2008 R2. I upgraded the system to Server 2012 and I thought it was the time to upgrade the database server too.

I removed the old version of MySQL after stopping the services. I downloaded the MySQL Windows installer from their website and installed it. Everything went ok until the end of the configuration. It wasn't able to start the service. I don't remember the exact error back then.

Well, what ever I tried, I wasn't able to start the service. Then I checked mysqld --console and it said InnoDB wasn't recognized as an database engine..?

After struggling for hours with the installer, I downloaded the 64 bit zip paggage. I copied the contents into C:\Program Files\MySQL\MySQL Server 5.5\. Then I used mysqld --install to install MySQL as an Windows service. Worked. Then I started it successfully with net start MySQL.

Now the database is running on the server. I can connect it, insert data there and read it. No problem. I have a few questions:

  1. When I'm trying to connect the database with MySQL Workbench to read it, I can't get the table structures shown. I googled and it seems there are such problems. What I tried didn't help. What is the problem with it? Previously it worked.

  2. Where are the users stored? I just copied the zip contents and all the users exists in the new version.

  3. Why doesn't the installer work? I remember I had the problem with the previous version too, a few years back. I don't remember checking the console, so I can't be sure it was the same problem now too, but at least it's acting the same way.

If you are curious about how I installed the server, it seems this guide looks quite the same except I didn't choose that many users to be allowed to connect at the same time.

By the way, when I look at the Startup / Shutdown tab in the administration panel of the database in MySQL Workbench, I see it says the database server instance is starting. What does this mean exactly? The server is already running because I can read and insert data there.

I'm also interested to know how to install MySQL with the installer, because I'd like to have the program shown in Control Panel and in the list of installed programs.

share|improve this question
    
The reason it wasn't working is because of the fact Windows Server 2012 is 64-bit. As to the reason it wasn't actually working is a bunch of reasons including stuff that was depreciated years ago. –  Ramhound Dec 13 '12 at 15:31

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.