How to stop MySQL command line?

MySQL server is an open-source relational database management system which is a major support for web based applications. Databases and related tables are the main component of many websites and applications as the data is stored and exchanged over the web. 

Use the STA command to stop or restart the MySQL server. You may need to do this during database management activities.

Stop the MySQL Server

Stop the MySQL database server when performing database management activities in which the MySQL server is running, but the rest of the STA application is not.

1. IMPORTANT: Do not stop the MySQL server if the rest of the STA application is running.

2. Open a terminal session on the STA server, and log in as the Oracle user.

3. Stop the MySQL server:

   $ STA stop mysql
   

4. Verify the server is not running:

   $ STA status mysql
   

   You should see:
   mysql is shutdown

Restart the MySQL Server

Restart the MySQL database server when performing database management activities in which you must shut down the STA application and then restart just the MySQL server.

Let us understand how MySQL server can be started and stopped on Linux and Windows −

Linux – Start and Stop Server

On Linux, the start and stop can be done from the command line as shown below −

/etc/init.d/mysqld start
/etc/init.d/mysqld stop

/etc/init.d/mysqld restart

Linux – Service Commands

Some Linux types offer service command as well −

service mysqld start

service mysqld stop

service mysqld restart

(or)

service mysql start

service mysql stop

service mysql restart

Windows – Start and Stop Server

Let us understand how it can be done on Windows −

• Open ‘Run’ Window by using Win key + R

• Type ‘services.msc’

• Now search for MySQL service based on the version that is installed.

• Click on ‘stop’, ‘start’ or ‘restart’ the service option.

Otherwise, the user can start/stop MySQL from the command prompt. It can be done as shown below −

C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld"

C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin" −u root shutdown

The program mysqladmin locates in the folder <path_to_installation_dir>\bin, where path_to_installation_dir is the path to the installation directory e.g., C:\Program Files\MySQL\MySQL Server 8.0\

Typically, you should add the pathname of the MySQL bin directory to Windows path environment variable to access any MySQL programs in the bin directory faster.

To stop MySQL, you follow these steps:

First, launch the Command Prompt by pressing Windows+R to open the Run box and type

/etc/init.d/mysqld stop 

/etc/init.d/mysqld stop 

Second, navigate to the bin folder of the MySQL if it is not in the Window path environment.

Third, use the following command to stop MySQL Server:

mysqladmin -u root -p shutdown
Enter password: ********

It prompts for a password of the

/etc/init.d/mysqld stop 

/etc/init.d/mysqld stop 

In this post, we are going to see how to start, stop, and restart MySQL Server on macOS, Linux, and Windows.

1. On Mac

You can start/stop/restart MySQL Server via the command line.

• For the version of MySQL older than 5.7:

sudo /usr/local/mysql/support-files/mysql.server start
sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server restart

• For the MySQL version 5.7 and newer:

sudo launchctl load -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

• Or you can turn it on/off via the macOS Preference Panel

There’s another way which you can use DBngin, an free utility to install and manage multiple database servers on Mac.

• To turn on/off, it’s just one click away from the server control panel:

2. On Linux

• On Linux start/stop from the command line:

/etc/init.d/mysqld start 
/etc/init.d/mysqld stop 
/etc/init.d/mysqld restart 

• Some Linux flavours offer the service command too

service mysqld start 
service mysqld stop 
service mysqld restart

• or

service mysql start
service mysql stop
service mysql restart

3. On Windows

• Open Run Window by Winkey + R
• Type services.msc
• Search MySQL service based on version installed.
• Click stop, start or restart the service option.

Or you can start/stop MySQL from the command prompt:

C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld"
C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin" -u root shutdown

Need a good GUI tool for MySQL on MacOS and Windows? TablePlus is a modern, native tool with an elegant GUI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.


How to stop MySQL in terminal?

How do I shut down MySQL?

How do I stop a MySQL script?

How do I close a SQL command line?