MySQL 启动和关闭

[root@db01 ~]$ mysqld &
[root@db01 ~]$ mysql -u root -p
mysql> shutdown;

[root@db01 ~]$ mysqld_safe &
[root@db01 ~]$ mysql -u root -p
mysql> shutdown;

[root@db01 ~]$ mysqld_safe &
[root@db01 ~]$ mysqladmin -u root -pmysql shutdown

[root@db01 ~]$ mysql -u root -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[root@db01 ~]$ netstat -tulnp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name 
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1185/sshd 
tcp6 0 0 :::22 :::* LISTEN 1185/sshd

1 启动

systemctl start mysqld ----> mysql.server ---->mysql_safe ---->mysqld

mysqld_safe和mysqld , 可以在启动数据库时，加入自己执行的参数
--skip-grant-tables :跳过授权表
--skip-networking   :跳过TCP/IP连接
--defaults-file=/opt/my.cnf

2 关闭

systemctl stop mysqld
service mysqld stop
/etc/init.d/mysqld stop
mysqladmin -uroot -p123 shutdown
mysql -uroot -p123 -e "shutdown"