Mysql database operation, can not connect DOS command using Navicat is normal, and a very strange ph-CodePudding

Mysql version: 5.6.21
System: Windows server2012 R2
After installed and configured, using navicat can connect, various operations such as everything is normal, because has been used to the DOS command line operations, will try to connect, DOS not, always prompt:
MySQl won't start - Can 't connect to MySQl server on localhost (10061)
According to some online for long, still can't solve, but there might be weird [inexperience, feel] :
Some net PALS provides such a thought, may be user permissions, and perform the mysqld - skip - grant - tables, skip verification
Then use the mysql - uroot can enter the mysql console! A operation, add user, change permissions or something!
Floundered, enter myql from Navicat. User table, the content has not changed, just operation of the database and Navicat libraries are not the same ah,
My view from the system service mysql services. Ini configuration file, C: \ ProgramData \ mysql \ mysql Server 5.6 \ my ini,
Datadir= C:/ProgramData/MySQL/MySQL Server 5.6/Data , this for the database directory, identified as Navicat normal links database directory,
After the screening to: skip authentication way, and then use mysql under DOS console into library catalog is
C:/Program Files/MySQL/MySQL Server 5.6 \ data the database under the .
DOS show the results of the databases:

Show the results of the databases in Navicat:

Various related processes, kill the mysql restart after service, Navicat still normal, DOS can't use again, must execute mysqld - skip - grant - tables to enter, but
Result is operating library is not my.) specified in the ini, hope to have a big advice, thank you!

Attach my. Ini specifies the mysql library. User table content (and by other computer navicat can remote connection and database operation]

 localhost root password Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 0 0 0 N 
127.0.0.1 root password Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 0 0 0 N 
: : 1 root password Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 0 0 0 N 
% the root password Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 0 0 0 N

CodePudding user response:

Check the navicat first database connection is?

CodePudding user response:

reference 1st floor ACMAIN_CHM response:

check first navicat database connection is?

Really is the local Server, my ini datadir=C:/ProgramData/MySQL/MySQL Server 5.6/Data of the library,

CodePudding user response:

Check the variable, where some variables can see server, such as slow_query_log_file general_log_file

CodePudding user response:

Even not a library, you see your MySQL service point to the configuration file is which