mkdir -p /application
995 tar xf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
997 mv mysql-5.7.26-linux-glibc2.12-x86_64 /application/mysql
998 cd /application/mysql/
999 ll
vim /etc/profile
export PATH=/application/mysql/bin:$PATH
source /etc/profile
1000 mysql -V
1001 rpm -qa|grep mariadb
1002 yum remove mariadb-libs-5.5.60-1.el7_5.x86_64
1005 userdel mysql
1006 useradd -s /sbin/nologin mysql
1007 id mysql
加磁盘
1012 fdisk -l
格式化
1013 mkfs.xfs /dev/sdb
1014 mkdir /data
挂载1031 blkid
1032 vim /etc/fstab
UUID=4e31f701-eaa5-4d2f-b634-f9d7f54b2c38 /data xfs defaults 0 0
1033 mount -a
1034 df -h
1035 chown -R mysql.mysql /application/*
1036 chown -R mysql.mysql /data
1037 mkdir /data/mysql/data -p
1038 chown -R mysql.mysql /data
1039 mysqld --initialize --user=mysql --basedir=/application/mysql --datadir=/data/mysql/data
1040 \rm -rf /data/mysql/data/*
1041 mysqld --initialize-insecure --user=mysql --basedir=/application/mysql --datadir=/data/mysql/data
1042 cd /data/mysql/data/
1043 ll
1044 cd
1045 cat >/etc/my.cnf <<EOF
[mysqld]
user=mysql
basedir=/application/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=6
port=3306
[mysql]
socket=/tmp/mysql.sock
EOF
1046 vim /etc/my.cnf
1047 cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld
1048 service mysqld start
1049 mysql
1050 netstat -lnp|grep 330
1051 ps -ef|grep 330
1052 /etc/init.d/mysqld stop
设置密码
mysqladmin -uroot -p password 123
使用systemd管理mysql
cat >/etc/systemd/system/mysqld.service <<EOF
[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=/application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
EOF
