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

Detailed explanation of the correct way to install opencv on ubuntu

This article describes how to install opencv with...

Understanding JavaScript prototype chain

Table of contents 1. Understanding the Equality R...

How to implement controllable dotted line with CSS

Preface Using css to generate dotted lines is a p...

Quick solution for forgetting MySQL8 password

Preface When we forget the MySQL database passwor...

Introduction to JavaScript Number and Math Objects

Table of contents 1. Number in JavaScript 2. Math...

Explanation and example usage of 4 custom instructions in Vue

Four practical vue custom instructions 1. v-drag ...

css add scroll to div and hide the scroll bar

CSS adds scrolling to div and hides the scroll ba...

Detailed explanation of Angular dynamic components

Table of contents Usage scenarios How to achieve ...

How to implement concurrency control in JavaScript

Table of contents 1. Introduction to Concurrency ...

Example of how to create a database name with special characters in MySQL

Preface This article explains how to create a dat...