From the course: MySQL Database Administration
Unlock this course with a free trial
Join today to access over 24,500 courses taught by industry experts.
Server management - MySQL Tutorial
From the course: MySQL Database Administration
Server management
- [Instructor] All right, now we're ready to talk about server management. When we're working in the real world situation, sometimes the server will need to be restarted. Most of the time, things will work as expected, but every once in a while, you're going to encounter an unexpected stop in your server. So here, I'm going to show you how we monitor the status of the server and then how we can actually start and stop the server when we need to. So the Administration tab in MySQL Workbench gives us the option to monitor and control the status of the MySQL Server that we're connected to. The Server Status view gives us a quick view of our server, and you can see a little preview of that here. So you click on Server Status under the Administration tab, and you'll see this little dashboard here. The main thing to note is in the top right where you see the green triangle and it says Running, that's going to be the indicator that your server is running. If you see a red square and it says…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.