创建mysql用户、用户组groupadd mysqluseradd -g mysql mysqlpasswd mysql卸载系统自带的mariadb#查询 rpm -qa|grep mariadb返回 mariadb-libs-5.5.60-1.el7_5.x86_64#卸载rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64返回error: Failed dependencies: libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64 libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64#强行卸载rpm -e –nodeps mariadb-libs-5.5.60-1.el7_5.x86_64下载mysql rpm下载mysql rpm选择Red Hat Enterprise Linux / Oracle LinuxRed Hat Enterprise Linux 7 / Oracle Linux 7 (x86, 64-bit)RPM Bundle取得下载地址https://cdn.mysql.com//Downlo…wget “https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.13-1.el7.x86_64.rpm-bundle.tar"tar -xvf mysql-8.0.13-1.el7.x86_64.rpm-bundle.tar安装安装依赖yum install -y libaio.x86_64 libaio-devel.x86_64 yum install -y openssl-devel.x86_64 openssl.x86_64 yum install -y perl.x86_64 perl-devel.x86_64 yum install -y perl-JSON.noarch yum install -y autoconf必要安装，注意顺序，有依赖关系rpm -ivh mysql-community-common-8.0.13-1.el7.x86_64.rpmrpm -ivh mysql-community-libs-8.0.13-1.el7.x86_64.rpmrpm -ivh mysql-community-client-8.0.13-1.el7.x86_64.rpmrpm -ivh mysql-community-server-8.0.13-1.el7.x86_64.rpm非必要安装，注意顺序，有依赖关系rpm -ivh mysql-community-libs-compat-8.0.13-1.el7.x86_64.rpmrpm -ivh mysql-community-embedded-compat-8.0.13-1.el7.x86_64.rpmrpm -ivh mysql-community-devel-8.0.13-1.el7.x86_64.rpmrpm -ivh mysql-community-test-8.0.13-1.el7.x86_64.rpm初始化数据库mysqld –initialize –console修改目录权限此步骤必须在初始化数据库之后！！！安装完默认是mysql 用户、用户组的权限，如果没有，则更改chown -R mysql:mysql /var/lib/mysql/用root用户启动systemctl start mysqld若启动失败,查看日志tail -n 100 /var/log/mysqld.log 查看初始化时的密码启动成功后可以查看初始化密码随机生成的cat /var/log/mysqld.log | grep password登录MySQL修改mysql用户密码mysql -u root -p#修改密码alter user ‘root’@’localhost’ identified by ‘yourpassword’;#远程设置use mysql;update user set host=’%’ where user=‘root’;#授权用户名的权限，赋予任何主机访问数据的权限grant all privileges ON . to ‘root’@’%’ with grant option;flush privileges;新增mysql用户,创建数据库,授权create user ‘flame’@’%’ identified by ‘password’;create database flame;grant all privileges on flame.* to ‘flame’@’%’;flush privileges;centos7防火墙开放端口# 开放3306端口firewall-cmd –zone=public –add-port=3306/tcp –permanent#重载firewall-cmd –reload#查看状态firewall-cmd –list-all阿里云端口安全组设置安全组说明新增3306端口的新增【入方向】规则生产环境mysql_secure_installation会做以下操作为root用户设置密码删除匿名账号取消root用户远程登录删除test库和对test库的访问权限刷新授权表使修改生效相关管理命令#启动mysqlsystemctl start mysqld.service#结束systemctl stop mysqld.service#重启systemctl restart mysqld.service#开机自启systemctl enable mysqld.service