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:
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.
Where are the users stored? I just copied the zip contents and all the users exists in the new version.
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.