centos7.X搭建mysql8.0服务

环境准备

1. CentOS Linux release 7.X
2. mysql80-community-release-el7-11.noarch.rpm(社区版免费/商业版收费)

安装过程

通过访问https://dev.mysql.com/downloads/，安装mysql的方式有很多种，我在这里采用MySQL Yum Repository的方式安装。


1、下载并且安装MySQL官方的YumRepository。这里有一点要注意:如果你是centos7,你就下载linux7的版本，linux8必须需要centos8版本才能安装。请注意，我这里使用root用户去安装。

cd ~
wget -i -c https://repo.mysql.com/mysql80-community-release-el7-11.noarch.rpm
yum -y install mysql80-community-release-el7-11.noarch.rpm

2、yum源安装好完，我们直接使用yum安装命令进行安装。

yum -y install mysql-community-server

3、查看已安装的MySQL

rpm -qa | grep mysql

4、本地启动mysql

systemctl start mysqld;

5、查看root临时密码

cat /var/log/mysqld.log | grep password

5、更改密码

mysql -u root -p
提示输入密码，输入临时密码后显示登录成功
然后执行语句：
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘new password’;
若提示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements(密码不符合当前策略)
修改密码需要为大小写字母+数字+特殊符号，例如这种密码:p-0J8u%oDaji

6、远程访问

use mysql;
update user set host = ‘%’ where user = ‘root’
flush privileges;

注意:这里仅仅为了本地环境搭建省事将host设置为%，这样做会存在安全问题，具体设置需要根据生产环境的IP进行设置，或者建议新建用户并设置新用户权限。

7、用navicat premium客户端登录

问题一：这个时候，安装过程可能出现了以下安装错误信息。(如果没有报错，可以忽略问题一)

安装mysql8.0报错 Requires: libstdc++.so.6

Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.11)(64bit)
Error: Package: mysql-community-client-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.21)(64bit)
Error: Package: mysql-community-client-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.20)(64bit)
Error: Package: mysql-community-client-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.9)(64bit)
Error: Package: mysql-community-client-plugins-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.20)(64bit)
Error: Package: mysql-community-client-plugins-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.21)(64bit)
Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.8)(64bit)
Error: Package: mysql-community-libs-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.20)(64bit)
Error: Package: mysql-community-libs-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.21)(64bit)
Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.9)(64bit)
Error: Package: 2:postfix-2.10.1-9.el7.x86_64 (base)
           Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
           Removing: 1:mariadb-libs-5.5.52-1.el7.x86_64 (@anaconda)
               libmysqlclient.so.18(libmysqlclient_18)(64bit)
           Obsoleted By: mysql-community-libs-8.0.26-1.el8.x86_64 (mysql80-community)
               Not found
           Updated By: 1:mariadb-libs-5.5.68-1.el7.x86_64 (base)
               libmysqlclient.so.18(libmysqlclient_18)(64bit)
Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.21)(64bit)
Error: Package: mysql-community-client-plugins-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.9)(64bit)
Error: Package: 2:postfix-2.10.1-9.el7.x86_64 (base)
           Requires: libmysqlclient.so.18()(64bit)
           Removing: 1:mariadb-libs-5.5.52-1.el7.x86_64 (@anaconda)
               libmysqlclient.so.18()(64bit)
           Obsoleted By: mysql-community-libs-8.0.26-1.el8.x86_64 (mysql80-community)
              ~libmysqlclient.so.21()(64bit)
           Updated By: 1:mariadb-libs-5.5.68-1.el7.x86_64 (base)
               libmysqlclient.so.18()(64bit)
Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.20)(64bit)
Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libtirpc.so.3()(64bit)
Error: Package: mysql-community-client-plugins-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.8)(64bit)
Error: Package: mysql-community-client-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libtinfo.so.6()(64bit)
Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libtirpc.so.3(TIRPC_0.3.3)(64bit)
Error: Package: mysql-community-libs-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libc.so.6(GLIBC_2.28)(64bit)
Error: Package: mysql-community-libs-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.9)(64bit)
Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.22)(64bit)
Error: Package: mysql-community-client-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libc.so.6(GLIBC_2.28)(64bit)
Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libc.so.6(GLIBC_2.28)(64bit)
Error: Package: mysql-community-server-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libtirpc.so.3(TIRPC_0.3.0)(64bit)
Error: Package: mysql-community-client-8.0.26-1.el8.x86_64 (mysql80-community)
           Requires: libncurses.so.6()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

注意事项

1、注意自己安装所在的linux服务器上有没有安装好gcc环境。

最后感言

   勉励自己，告诉自己，并不是因为看到希望才坚持，而是坚持了才有机会看到希望。