阿里云CentOS7安装MySQL8

创建目录

[root@node1 ~]# mkdir /usr/local/mysql
[root@node1 ~]# cd /usr/local/mysql/

下载安装包

到MySQL官网查看需要下载的版本，并获取到下载地址

https://downloads.mysql.com/archives/community/

下载

[root@node1 mysql]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.24-1.el7.x86_64.rpm-bundle.tar

查看下载文件

[root@node1 mysql]# ls
mysql-8.0.24-1.el7.x86_64.rpm-bundle.tar

解压安装包

[root@node1 mysql]# tar -xvf mysql-8.0.24-1.el7.x86_64.rpm-bundle.tar 

查看解压后的文件

[root@node1 mysql]# ll
total 1550012
-rw-r--r-- 1 root root  793600000 Mar 28 11:08 mysql-8.0.24-1.el7.x86_64.rpm-bundle.tar
-rw-r--r-- 1 7155 31415  47664272 Mar 23  2021 mysql-community-client-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415    193620 Mar 23  2021 mysql-community-client-plugins-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415    628908 Mar 23  2021 mysql-community-common-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   6783892 Mar 23  2021 mysql-community-devel-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  23587688 Mar 23  2021 mysql-community-embedded-compat-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   4226224 Mar 23  2021 mysql-community-libs-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   1262864 Mar 23  2021 mysql-community-libs-compat-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415 448452756 Mar 23  2021 mysql-community-server-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415 260789456 Mar 23  2021 mysql-community-test-8.0.24-1.el7.x86_64.rpm

解压后的文件不属于root，修改所属者和所属组为root

[root@node1 mysql]# chown root:root /usr/local/mysql -R

再次查看解压文件，文件的所属者和所属组都变为了root

[root@node1 mysql]# ll
total 1550012
-rw-r--r-- 1 root root 793600000 Mar 28 11:08 mysql-8.0.24-1.el7.x86_64.rpm-bundle.tar
-rw-r--r-- 1 root root  47664272 Mar 23  2021 mysql-community-client-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 root root    193620 Mar 23  2021 mysql-community-client-plugins-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 root root    628908 Mar 23  2021 mysql-community-common-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 root root   6783892 Mar 23  2021 mysql-community-devel-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 root root  23587688 Mar 23  2021 mysql-community-embedded-compat-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 root root   4226224 Mar 23  2021 mysql-community-libs-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 root root   1262864 Mar 23  2021 mysql-community-libs-compat-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 root root 448452756 Mar 23  2021 mysql-community-server-8.0.24-1.el7.x86_64.rpm
-rw-r--r-- 1 root root 260789456 Mar 23  2021 mysql-community-test-8.0.24-1.el7.x86_64.rpm

卸载MySQL及安装必要的工具

卸载MySQL依赖（这一步不可少）

[root@node1 mysql]# yum remove mysql-libs

由于阿里云服务器安装的是Linux最小系统版，没有如下工具，所以需要安装。

[root@node1 mysql]# yum install libaio
[root@node1 mysql]# yum -y install autoconf

卸载MySQL

[root@node1 mysql]# systemctl stop mysql mysqld 2>/dev/null
[root@node1 mysql]# rpm -qa | grep -i 'mysql\|mariadb' | xargs -n1 rpm -e --nodeps 2>/dev/null
[root@node1 mysql]# rm -rf /var/lib/mysql /var/log/mysqld.log /usr/lib64/mysql /etc/my.cnf /usr/my.cnf

 

安装MySQL

[root@node1 mysql]# yum install -y *.rpm >/dev/null 2>&1

启动MySQL

[root@node1 mysql]# systemctl start mysqld

更改密码级别(可选)

[root@node1 mysql]# sed -i '/\[mysqld\]/avalidate_password.length=4\nvalidate_password.policy=0' /etc/my.cnf

配置MySQL

[root@node1 mysql]# tpass=$(cat /var/log/mysqld.log | grep "temporary password" | awk '{print $NF}')

[root@node1 mysql]# cat << EOF | mysql -uroot -p"${tpass}" --connect-expired-password >/dev/null 2>&1
set password='000000';
update mysql.user set host='%' where user='root';
alter user 'root'@'%' identified with mysql_native_password by '000000';
flush privileges;
EOF

注意：000000是密码，建议修改为更加安全的密码。

登录MySQL命令行

[root@node1 mysql]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.24 MySQL Community Server - GPL
​
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
​
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
​
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
​
mysql>

远程连接MySQL

登录云控制台，在安全组放开3306端口

注意：0.0.0.0/0代表所有ip均能访问，不安全。可以只授权给特定ip，例如自己当前电脑的公网ip地址，一般情况下，当前电脑的公网ip会变化，变化后就需要重新查询当前电脑的公网ip，再重新设置授权对象。

使用Navicat远程连接阿里云的MySQL

看到连接成功

完成！enjoy it!