Various methods to restart Mysql under CentOS (recommended)

Various methods to restart Mysql under CentOS (recommended)

1. MySQL installed via rpm package

service mysqld restart
/etc/inint.d/mysqld start

2. MySQL installed from source package

// Linux shutdown MySQL command $mysql_dir/bin/mysqladmin -uroot -p shutdown
// Linux starts the MySQL command $mysql_dir/bin/mysqld_safe &

mysql_dir is the installation directory of MySQL, and mysqladmin and mysqld_safe are located in the bin directory of the MySQL installation directory.

3. When the above methods are ineffective, you can shut down MySQL by forcibly commanding: "killall mysqld".

The above are the various methods of restarting Mysql under CentOS introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • How to correctly restart MySQL in Linux
  • How to restart MySQL under Windows
  • LINUX start/restart/stop MYSQL commands (detailed explanation)
  • Use innodb_force_recovery to solve the problem that MySQL crashes and cannot restart
  • Apache and MySQL restart commands
  • Start, stop, restart MySQL and view error log commands in Ubuntu
  • Detailed explanation of three ways to start/stop/restart MySQL database in Ubuntu Server
  • Modify parameter variables without restarting mysql
  • Detailed explanation of LINUX restart MYSQL command
  • Solution to MySQL restarting automatically

<<:  Windows Server 2008 R2 Multi-User Remote Desktop Connection Licensing

>>:  An example of dynamically implementing different styles of data in a column of el-table of element ui

Recommend

MySQL online DDL tool gh-ost principle analysis

Table of contents 1. Introduction 1.1 Principle 1...

Detailed Example of JavaScript Array Methods

Table of contents Introduction Creating an Array ...

How to start Vue project with M1 pro chip

Table of contents introduction Install Homebrew I...

Summary of Common Problems with Mysql Indexes

Q1: What indexes does the database have? What are...

JavaScript implementation of classic snake game

This article shares the specific code of JavaScri...

Linux parted disk partition implementation steps analysis

Compared with fdisk, parted is less used and is m...

VMware virtual machine installation CentOS 8 (1905) system tutorial diagram

The world-famous virtual machine software VMware-...

jQuery to achieve sliding stairs effect

This article shares the specific code of jQuery t...

Detailed explanation of non-parent-child component communication in Vue3

Table of contents First method App.vue Home.vue H...

Detailed explanation of VUE responsiveness principle

Table of contents 1. Responsive principle foundat...

Flex layout achieves fixed number of rows per line + adaptive layout

This article introduces the flex layout to achiev...

5 ways to quickly remove the blank space of Inline-Block in HTML

The inline-block property value becomes very usef...

How to make a div height adaptive to the browser height

This old question has troubled countless front-end...