Bug #70934 | I typed "c:\dbs>sc qc mysql56" and saw the following information | ||
---|---|---|---|
Submitted: | 18 Nov 2013 3:36 | Modified: | 8 Dec 2013 13:57 |
Reporter: | john john | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL for Windows: Installer | Severity: | S3 (Non-critical) |
Version: | community-5.6.14 | OS: | Windows (windows 8.1) |
Assigned to: | CPU Architecture: | Any | |
Tags: | fix suggestion |
[18 Nov 2013 3:36]
john john
[18 Nov 2013 14:53]
john john
I typed "c:\dbs>sc qc mysql56" and saw the following information "[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"
[18 Nov 2013 20:43]
MySQL Verification Team
Please open a command prompt screen with Administrator privileges and go to "C:\Program Files\MySQL\MySQL Server 5.6\bin" directory. Be 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 and print here what the server prints. Thanks.
[19 Nov 2013 8:36]
john john
Thanks for your reply. Now i have to go on a business trip(today to December 1st). I will take a try according to your prompt as soon as possible and put result here.
[19 Nov 2013 14:51]
MySQL Verification Team
Thank you for the feedback. Please reopen when you will have the answer. Thanks.
[2 Dec 2013 7:09]
john john
screen pic
Attachment: screen pic.png (image/png, text), 21.59 KiB.
[2 Dec 2013 7:11]
john john
Hi Godofredo miguel Solorzano, I tried it according to your prompt: "[18 Nov 20:43] Godofredo Miguel Solorzano Please open a command prompt screen with Administrator privileges and go to "C:\Program Files\MySQL\MySQL Server 5.6\bin" directory. Be 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" PS: I have only one disk in my computer and the "my.ini" can be found in "C:\ProgramData\MySQL\MySQL Server 5.6". thanx for your help!
[2 Dec 2013 7:17]
john john
PS: the following changes to "my.ini" wouldn't help: # Path to installation directory. All paths are usually resolved relative to this. before——#basedir="C:/Program Files/MySQL/MySQL Server 5.6/" after——basedir="C:/Program Files/MySQL/MySQL Server 5.6/" # Path to the database root before——datadir="C:/ProgramData/MySQL/MySQL Server 5.6/data\" after——datadir="C:/ProgramData/MySQL/MySQL Server 5.6/data/"
[8 Dec 2013 13:45]
john john
ok,maybe you can solve the trouble by the following tips: 1 when installing mysql5.6.14,do select ”show adviced setting” and make sure that those directories of the .log files contains only english words OR 2 when installing the win8.1,name your computer in English instead of other language
[8 Dec 2013 13:57]
john john
problem solved