MySQL Forums
Forum List  »  Newbie

Re: MySQL Server 5.6 restart does not restore users and schemas
Posted by: Nicholas Taylor
Date: September 10, 2017 08:01PM

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)

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.