Mysql安装

Window系统下安装

下载点这里mysql安装包，按提示安装即可，注意使用传统的加密方式，chacha20和sha256加密方式需要额外的组件才能使用，许多客户端也就不支持这些加密方式。

Linux系统下安装

通过yum安装

shell> wget https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm
shell> yum localinstall mysql80-community-release-el7-2.noarch.rpm
shell> yum repolist enabled | grep "mysql.*-community.*"
shell> yum install -y mysql-community-server
shell> systemctl start mysqld
shell> mv /etc/my.cnf /etc/my.cnf_bak && sed 's/^# \(default-authentication-plugin\)/\1/' /etc/my.cnf_bak >/etc/my.cnf
shell> cat <<EOF >>/etc/my.cnf 
[mysql]
character-set-server = utf8
lower_case_table_name=1
EOF
shell> systemctl enable mysqld && systemctl daemon-reload && systemctl restart mysqld


mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Zz1029384756.+';
mysql> CREATE USER 'zhangshuai'@'%' IDENTIFIED BY 'Zjk123,.{2a';
mysql> grant all on *.* to 'zhangshuai'@'%';

通过编译安装

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
cd /usr/local/mysql-8.0.11
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306 -DWITH_BOOST=/usr/local/mysql-8.0.11/boost 
make  && make install