MySQL database startup and Shutdown

MySQL database startup and Shutdown

MySQL database server usually refers to mysqld, while command line mysql is a mysql client program. These two concepts are often confusing. Generally, the mysql server is started to start the mysqld process. After mysqld is started, you can connect to the mysql server through mysql. This article describes how to start a mysql server and how to disable it.

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------

1. Start directly with mysqld
Mysqld is the mysql server. You can call this command to directly start the mysql server.
Mysqld reads [mysqld] and [server] consumer group content from the configuration file, or you can directly follow the parameter through the command line.
The order in which the mysqld server reads configuration files. If multiple configuration files exist and the same parameter has multiple values, the last read prevails.
Command line parameters have the highest priority

# Current mysql server running environment
[Root @ rhel64a ~] # Cat/etc/issue
Red Hat Enterprise Linux Server release 6.4 (Santiago)

# View the default mysqld startup options
[Root @ rhel64a ~] # Mysqld -- print-defaults
Mysqld wowould have been started with the following arguments:
-- Socket =/tmp/mysql3306.sock -- port = 3306 -- pid-file =/var/lib/mysql/my3306.pid -- user = mysql -- server-id = 3306 -- federated
[Root @ rhel64a ~] # Ps-ef | grep mysql
Root 2963 2840 0 00:00:00 pts/0 grep mysql

# Author: Leshami
# Blog:

1 2 Next Page