Get Started with the MySQL Server
Explore how to manage the MySQL server by learning to start and stop it using different methods on Mac and Linux. Understand how to verify if the server is running and where to find key configuration files. This lesson helps you confidently handle MySQL server operations essential for managing relational databases.
We'll cover the following...
We’ll discuss the basics of the MySQL server, including how to start and stop using different methods and how to verify if the server is running. Note that we can run all the following commands in the terminal at the end of the lesson.
Verify MySQL is running as a server
Let’s start a terminal.
Using the terminal, we’re going to check whether the MySQL server is running or not. In order to do that, we type in the following command:
ps -ef |grep 'mysql'
When we run that, we see an output similar to this:
The process that’s currently running refers to MySQL and verifies that the MySQL server is running properly on our machine.
Note: The above output will differ on your machine. It will also change based on the operating system you’re running.
It’s ...