Description:
Description:
mysql-server-5.6-winx64:6 - Looking for valid template
mysql-server-5.6-winx64:12 - Found valid template.
mysql-server-5.6-winx64:18 - Attempting to process template.
mysql-server-5.6-winx64:25 - Processed template.
mysql-server-5.6-winx64:31 - Attempting to configure service.
mysql-server-5.6-winx64:37 - Configured service.
mysql-server-5.6-winx64:43 - Attempting to start service.
typed "c:\dbs>sc qc mysql56" and what the server prints is:
"[SC] QueryServiceConfig SUCCESS
SERVICE_NAME: mysql56
TYPE : 10 WIN32_OWN_PROCESS
START_TYPE : 2 AUTO_START
ERROR_CONTROL : 1 NORMAL
BINARY_PATH_NAME : "C:/Program Files/MySQL/MySQL Server
5.6/bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server
5.6\my.ini" MySQL56
LOAD_ORDER_GROUP :
TAG : 0
DISPLAY_NAME : MySQL56
DEPENDENCIES :
SERVICE_START_NAME : NT AUTHORITY\NetworkService"
open a command prompt screen with Administrator privileges and go to
"C:\Program Files\MySQL\MySQL Server 5.6\bin" directory.
Then make sure the service MySQL56 is not running with the below command:
sc query MySQL56
Then issue the below command:
mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini"
--standalone --console"
what the server prints is:
"The file name, directory name, or volume label syntax is incorrect"
the "my.ini" can be found and opened(by double click)in the above directory.
the following changes to "my.ini" wouldn't help:
# Path to installation directory. All paths are usually resolved
relative to this.
before change——#basedir="C:/Program Files/MySQL/MySQL Server 5.6/"
after change——basedir="C:/Program Files/MySQL/MySQL Server 5.6/"
# Path to the database root
before change——datadir="C:/ProgramData/MySQL/MySQL Server 5.6/data\"
after change——datadir="C:/ProgramData/MySQL/MySQL Server 5.6/data/"
I have only one disk in my computer, and the language is chinese.
How to repeat:
Brand new install(use default sets) MySQL 5.6.14 for win8.1 and the installation hangs on attempting to start service. Tried uninstalling, rebooting, reinstalling, even uninstalling my virus software to no avail.
Suggested fix:
I really wanna know how to fix it. Thanx!