Start mysqld.exe but as offline at the begining



  • How can I start my mysql server as usual using "./bin/mysqld.exe" on windows, but it has to be offline at the very begining?

    Right now when I start mysqld.exe, I always need to start Mysql Workbench and push the button "bring it offline" at "instance / startup/shutdown" first. It is annoying.

    I need mysql server only for localhost purposes, there is no need to be it online for the Internet. Tried to googling and duckducking it but suprisingly there is zero talk about it.



  • Set bind-address=127.0.0.1 in the my.cnf file to restrict all access to the localhost and local filesocket only.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2