All geek questions in one place

Cannot restart mysql after changing datadir

I can not restart the server after changing the default datadirfrom C: /ProgramData/MySQL/MySQL Server 5.7\Datato D: /Data.

  • I changed datadirtodatadir="D: /Data"
  • Then i stopped mysql
  • Copy the directory DatatoD:/
  • Attempt to restart the server
  • Unable to start

What could be the reason for this?

Error Snapshot:

enter image description here

However, it works fine if the original data path is restored.

+5
source share
2 answers

Assign full permissions for the NETWORK SERVICE service to the "D: / Data" folder

+9
source

, my.ini ANSI , Notepad++

datadir my.ini Windows, , -, UTF-8. Notepad++ ANSI, mysql. MySQL.

+2

Source: https://habr.com/ru/post/1624981/

More articles:


All Articles