12 January 2016

MySQL Workbench: How to Start/Stop Server

How to start and stop the local MySQL server using the MySQL Workbench.
  1. Open MySQL Workbench.
  2. Select the local connection.
  3. If there is no connection, make one by clicking the plus icon, setting the hostname to 127.0.0.1 (your computer), the port to 3306, and creating a username.
  4. Once the SQL editor is open, click on the Server menu, then Startup/Shutdown.
  5. A new tab will open. Use the Start Server button to turn the server on. Note: You may need to allow the operation in a User Account Control prompt that will pop up.
  6. When the server is running, open the command line client and enter the password. If it works, a welcome message will be displayed. If not, the command line client will close.
  7. To stop the server, click Stop Server in the MySQL Workbench tab.
Video: https://www.youtube.com/watch?v=NlEoF7SH1cM