mysql configuration stops at “starting server”

by

Here is what I did:

  1. Installed it with mysql-installer-web-community-5.6.23.0.msi
  2. For my purposes I selected “Custom” install with MySQL servers 5.6.22 – X64 and MySQL Connectors -> Connector ODBC/5.3.4 – 64
  3. Next -> Execute -(ready to configure) -> Next
  4. Config type: Development machine, all defaults (TCP/IP, Port: 3306, Open firewall)
  5. Typed in MySQL Root Password
  6. MySQL user Accounts -> Add user (username, password, OK) -> Next
  7. Configure MySQL Server as a Windows Service (CHECKED)
  8. Windows Service Name: MySQL56 (default)
  9. Start the MySQL Serve at System Startup
  10. THIS IS CRUCIAL (BUG IS HERE): Run Service as…
    Standard System Account (CHECKED – but it will be disregarded and that is BUG)
  11. Next -> Execute, Installation hangs on Starting server, so wait for a while to time out (or don’t, your choice). When Dialog (might be covered with other windows) popup with message “Configuration of MySQL Server is taking longer than expected…, here click OK (so to wait longer)
  12. Meanwhile go to Start -> Control Panel -> Administrative Tools -> Services -> find MySQL56, right click on it -> Properties -> select Log On Tab AND HERE IS BUG -> Although Local System Account was selected, Somehow “This account: Network Service (with some password) was selected -> Select Log on as: Local System Account, Allow service to interact with desktop -> Apply -> Go back on general tab
  13. On general tab click on “Start” button to start service and here it is! Service is started! Click on OK to close MySQL56 Properties dialog. Close Services dialog. Close Administrative tools. Close control panel.
  14. And by that time (while you were closing those dialogs) when you look at MySQl Installer Dialog all steps are finished and checked: Starting Server, Applying security… Creating user accounts.. Updating Start menu link
  15. Confirm with Finish -> Next -> Finish

That’s it, happy MySQL-ing 🙂

More Related Contents:

  1. mysql2 gem compiled for wrong mysql client library
  2. Differences between utf8 and latin1
  3. How can I access the MySQL command line with XAMPP for Windows?
  4. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  5. Import SQL file into mysql
  6. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  7. How to force case sensitive table names?
  8. MySQL my.ini location
  9. Where does MySQL store database files on Windows and what are the names of the files?
  10. Xampp-mysql – “Table doesn’t exist in engine” #1932
  11. MySQL data directory location
  12. How do I specify unique constraint for multiple columns in MySQL?
  13. Select all columns except one in MySQL?
  14. MYSQL OR vs IN performance
  15. MySQL Conditional Insert
  16. MySQL JOIN ON vs USING?
  17. How to store IPv6-compatible address in a relational database
  18. MySql export schema without data
  19. Scaling solutions for MySQL (Replication, Clustering)
  20. mysql check if numbers are in a comma separated list
  21. Relationship between catalog, schema, user, and database instance
  22. What is the difference between BIT and TINYINT in MySQL?
  23. MySQL ERROR 1290 (HY000) –secure-file-priv option
  24. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  25. MySQL, Concatenate two columns
  26. How to only select numeric data from mysql?
  27. What is the MySQL query equivalent of PHP strip_tags?
  28. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Installing PDO driver on MySQL Linux server

Leave a Comment