centos8 安装 mysql8.0 并忽略大小写

1、安装Yum Repository

        wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm

2、rpm来安装MySQL

        rpm -ivh mysql80-community-release-el8-1.noarch.rpm

3、yum安装mysql服务

        yum install mysql-server

4、配置大小写

        vim /etc/my.cnf.d/mysql-server.cnf

末尾加上：lower_case_table_names=1，保存退出

5、检查是否已经设置为开机启动MySQL服务

        systemctl list-unit-files|grep mysqld
                mysqld.service disabled
                mysqld@.service disabled

        systemctl enable mysqld.service   #设置开机启动
                Created symlink /etc/systemd/system/multi-user.target.wants/mysqld.service →                 /usr/lib/systemd/system/mysqld.service.
        systemctl list-unit-files|grep mysqld
                mysqld.service enabled
                mysqld@.service disabled

        ps -ef|grep mysql # 查看是否启动MySQL服务
                root 4311 32702 0 21:07 pts/4 00:00:00 grep --color=auto mysql
        systemctl start mysqld.service #启动服务