Linux从入门到放弃 MySQL二进制安装

mkdir -p /data/app/ /data/3306/data  /data/3306/binlog

useradd mysql

chown -R mysql.mysql /data

vim /etc/profile
#添加一行： 
export PATH=/data/app/mysql5.7/bin:$PATH 

cat >/etc/my.cnf <<EOF 
[mysqld]
user=mysql
basedir=/data/app/mysql5.7 
datadir=/data/3306/data
server_id=6
socket=/tmp/mysql.sock 
[client]
socket=/tmp/mysql.sock
EOF

mysqld --initialize-insecure --user=mysql --basedir=/data/app/mysql5.7 --datadir=/data/3306/data

 yum install -y libaio-devel

C7 管理方式 systemd
[root@db01 ~]# cp /data/app/mysql5.7/support-files/mysql.server /etc/init.d/mysqld
[root@db01 ~]# chkconfig --add mysqld
[root@db01 ~]# systemctl stop mysqld
[root@db01 ~]# systemctl start mysqld
[root@db01 ~]# systemctl restart mysqld

手工定制（单机多实例的模式）

vim /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
[Service]
User=mysql
Group=mysql
ExecStart=/data/app/mysql5.7/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000

[root@db01 data]# mysqladmin -uroot -p password 123456
Enter password: 
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
[root@db01 data]# mysql -uroot -p123456