mysql linux close

MySQL is a popular relational database management system, and Linux is a widely used operating system. These two technologies and programs are related to each other in many cases. Under the Linux operating system, MySQL can be shut down in various ways. This article will introduce some simple and easy-to-understand methods for you to shut down MySQL easily.

1. Use the command line to shut down MySQL

In Linux systems, you can use the command line to shut down the MySQL service through the terminal window. This is one of the most commonly used methods. To shut down MySQL in Linux, you only need to perform the following steps:

1. Stop the MySQL service

Use the following command in the Linux terminal Stop the MySQL service:

sudo systemctl stop mysqld

If you are using MariaDB, you can use the following commands:

sudo systemctl stop mariadb

These commands will Stop the MySQL service and shut down all its related processes.

2. Close the MySQL service

If you wish to shut down the MySQL service and disable automatic startup at startup, you can run the following command:

sudo systemctl disable mysqld

If MariaDB is used in the system, you can use the following command:

sudo systemctl disable mariadb

This will prevent the MySQL service from starting automatically after restarting.

3. Restart the MySQL service

If you want to restart the MySQL service, you can run the following command:

sudo systemctl restart mysqld

If you use MariaDB, you can use the following command:

sudo systemctl restart mariadb

Executing this command will restart the MySQL service and start all its related processes. If the MySQL service is running, executing this command will kill the service and restart it.

2. Use the MySQL command to shut down MySQL

In addition to using the Linux command line, you can also shut down the MySQL service under the MySQL command line. MySQL can be shut down by following these steps:

1. Login to MySQL

Log in to MySQL using the following command:

mysql -u root -p

This will prompt you for the password of the MySQL administrator (root user) and open the MySQL command line prompt, where you can enter SQL commands.

2. Close the MySQL service

Execute the following command to shut down the MySQL service:

shutdown

This command will shut down the MySQL service and shut down All related MySQL processes.

Summary:

MySQL is a widely used database service. There are many methods to choose from to shut down the MySQL service in the Linux system. You can use the Linux command line to shut down the MySQL service through the terminal window, or you can shut down the service under the MySQL command line. With the simple steps described in this article, you can easily shut down the MySQL service in your Linux system.

The above is the detailed content of mysql linux close. For more information, please follow other related articles on the PHP Chinese website!