mysqld.service

[unit]
Description=MySQL Server
Documentation=man:mysqld[7]
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
Type=forking
PIDFile=/data/mysql/node.pid
TimeoutSec=0
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --daemonize --pid-file=/data/mysql/node.pid $MYSQLD_OPTS
EnvironmentFile=-/etc/sysconfig/mysql
#sets open_files_limit
LimitNOFILE=65536
Restart=on-failure
RestartPreventExitStatus=1
PrivateTmp=false

cd /usr/lib/tmpfiles.d
cat /usr/lib/tmpfiles.d/mysql.conf
d /data/mysql 0750 mysql mysql -
chmod 644 mysql.conf
systemctl enable mysqld.service
systemctl start mysqld
systemctl 日志
journalctl -u mysqld
systemctl daemon-reload
systemctl restart mysqld

systemctl set-environment MYSQLD_OPTS="--general_log=0"
systemctl restart mysqld

systemctl status firewalld|grep -i "Active:"
systemctl stop firewalld
systemctl disable firewalld

cat etc/selinux/config|egrep -i "SELINUX=e|SELINUX=p|SELINUX=d" 
SELINUX=enforcing
sed -i 's/^SELINUX=enforcing/SELINUX=disabled/' etc/selinux/config

cat /etc/security/limits.conf
mysql soft nproc 2047
mysql hard nproc 16384
mysql soft nofile 1024
mysql hard nofile 65536

ulimit -Sn 1024
ulimit -Hn 65536
ulimit -Su 2047
ulimit -Hu 16384

ulimit -a -S|egrep -i "open files|max user processes"
ulimit -a -H|egrep -i "open files|max user processes"

sysctl -a|egrep -w "fs.file-max|kernel.pid_max"

groupadd mysql
useradd -r -g mysql -s bin/false mysql
mkdir -p mysql/app
mkdir -p mysql/product/{data,log,binlog,relaylog,redo,unod,mysql-files}
chown -R mysql:mysql mysql
chmod -R 750 /mysql
 tar zxvf mysql-...tar.gz  -C /mysql/app --strip-components=1




echo 'export PATH=/mysql/app/bin:$PATH'>> $HOME/.bash_profile
source $HOME/.bash_profile




mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql
cat /mysql/product/log/mysql.err|grep -i "A temporary password"

update mysql.user set authentication_string=password('root') where user='root' and host='localhost';

alter user 'root'@'localhost' identified by 'root';
update mysql.user set authentication_string='' where user='root' and host='localhost';
flush privileges;