systemctl start mysql.service报错问题

pid文件位置问题:


cat /etc/systemd/system/mysql.service


[Unit]

Description=MySQL Server

Documentation=man:mysqld(8)

Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html

After=network.target

After=syslog.target


[Install]

WantedBy=multi-user.target

Alias=mysql.service


[Service]

User=mysql

Group=mysql


Type=forking


PIDFile=/var/lib/mysql/Devops-mysql-slave-150.pid   //修改为正确的mysql pid位置


# Disable service start and stop timeout logic of systemd for mysqld service.

TimeoutSec=0


# Execute pre and post scripts as root

PermissionsStartOnly=true


# Needed to create system tables

ExecStartPre=/usr/bin/mysqld_pre_systemd


# Start main service

ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/lib/mysql/Devops-mysql-slave-150.pid $MYSQLD_OPTS    ## 修改pid位置


# Use this to switch malloc implementation

EnvironmentFile=-/etc/sysconfig/mysql


# Sets open_files_limit

LimitNOFILE = 5000


Restart=on-failure


RestartPreventExitStatus=1


PrivateTmp=false


启动 :

systemctl start mysql.service


如果嫌mysql.service 麻烦  ,可以修改Alias=mysql.service为mysqld

systemctl start mysqld



上一篇:sqlserver2014忘记所有用户密码


下一篇:into outfile csv问题: