Linux 安装 MySQL 详细教程

cd /soft
tar -xvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.20-linux-glibc2.12-x86_64 mysql
1.
2.
3.

systemctl stop firewalld
systemctl disable firewalld
systemctl status firewalld
1.
2.
3.

groupadd mysql
useradd -r -g mysql -s /bin/false mysql
1.
2.

mkdir -p /data/mysql
chown -R mysql:mysql /data
chown -R mysql:mysql /soft
chmod 750 /data
1.
2.
3.
4.

cat <<EOF>> /root/.bash_profile
export PATH=\$PATH:/soft/mysql/bin
EOF
##生效环境变量
source /root/.bash_profile
1.
2.
3.
4.
5.

##挂载镜像源
mount /dev/cdrom /mnt
##配置yum源
cat <<EOF>>/etc/yum.repos.d/local.repo
[local]
name=local
baseurl=file:///mnt
gpgcheck=0
enabled=1
EOF
##安装依赖包
yum install -y libaio
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.

mysqld --initialize --user=mysql --basedir=/soft/mysql --datadir=/data/mysql/
1.

cat <<EOF>/etc/my.cnf
[mysqld]
user=mysql
basedir=/soft/mysql
datadir=/data/mysql
server_id=6
port=3306
socket=/tmp/mysql.sock
##客户端
[mysql]
socket=/tmp/mysql.sock
prompt=lucifer [\\\\d]>
EOF
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.

/soft/mysql/support-files/mysql.server start
1.

cp /soft/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig mysqld on
1.
2.

##配置mysqld.service文件：
cat <<EOF>>/usr/lib/systemd/system/mysqld.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=/soft/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
EOF
systemctl enable mysqld
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.

mysql -uroot -pyhfvt_rP,24M
1.

mysqladmin -uroot -pyhfvt_rP,24M password mysql
1.

mysql -uroot -pmysql
1.