Mysql学习

最新推荐文章于 2025-04-14 14:17:57 发布

原创最新推荐文章于 2025-04-14 14:17:57 发布 · 811 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#mysql

技术专栏收录该内容

2 篇文章

订阅专栏

本文介绍了在CentOS操作系统中如何使用服务命令启动、查看、关闭以及重启MySQL数据库服务。通过`service mysqld start|status|stop|restart`命令，可以轻松管理MySQL服务的状态，确保数据库系统的正常运行。

1. CentOS 下启动、关闭、重启、查看MySQL服务

1. 启动服务

[root@localhost ~]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service

2. 查看服务

[root@localhost ~]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Sat 2021-08-14 02:04:07 EDT; 20min ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 1234 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 1313 (mysqld)
   Status: "Server is operational"
   CGroup: /system.slice/mysqld.service
           └─1313 /usr/sbin/mysqld

Aug 14 02:04:06 localhost.localdomain systemd[1]: Starting MySQL Server...
Aug 14 02:04:07 localhost.localdomain systemd[1]: Started MySQL Server.

3. 关闭服务

[root@localhost ~]# service mysqld stop
Redirecting to /bin/systemctl stop mysqld.service

4. 重启服务

[root@localhost ~]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service

5. 查看配置

[root@localhost ~]# cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid