Re: MySQL Server 5.6 restart does not restore users and schemas

[Nicholas Taylor]

Thank you, strange, the first command worked well, but the second command failed.

Results in First Window
C:\Users\Owner>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56 --console --skip-grant-tables
2017-09-10 18:47:29 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-09-10 18:47:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-10 18:47:29 0 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe (mysqld 5.6.37-log) starting as process 972 ...

Results in Second Window
C:\Users\Owner>chdir C:\Program Files\MySQL\MySQL Server 5.6\bin\

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)