mysql5.7.26安装
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