2018 Linux-CentOS7下安装MySQL
1、#列出所有被安装的rpm package[root@localhost 卯掏跨几~]# rpm -qa | grep mariadbmariadb-libs-5.5.56-2.el7.x86_64#卸载[root@localhost ~]# rpm -e mariadb-libs-5.5.56-2.el7.x86_64错误：依赖检测失败： libmysqlclient.so.18()(64bit) 被 (已安裝) postfix-2:2.10.1-6.el7.x86_64 需要 libmysqlclient.so.18(libmysqlclient_18)(64bit) 被 (已安裝) postfix-2:2.10.1-6.el7.x86_64 需要 libmysqlclient.so.18(libmysqlclient_18)(64bit) 被 (已安裝) postfix-2:2.10.1-6.el7.x86_64 需要#强制卸载，因为没有--nodeps[root@localhost ~]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64安装mysql依赖[root@localhost ~]# yum install vim libaio net-tools
2、CentOS7的yum源中默认是没有MySQL的，因此，我们要先下载MySQL的repo源下载MySQL官网的repo源 ：https://dev.mysql.com/downloads/repo/yum/目前最新：mysql57-community-release-el7-11.noarch.rpm
3、2.安装yum repo文件rpm -ivh mysql57-community-release-el7-11.noarch.rpm执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件mysql-community.repomysql-community-source.repo
4、然后更新yum缓存yum clean allyum makecache
5、安装mysqlsudo yum install mysql-server遇到确认提示，输入 y
6、#启动mysql/bin/systemctl start mysqld.service#查看初始密码grep'temporary password'/var/log/mysqld.log得到如下内容：2018-03-24T07:53:32.584830Z 1 [Note] A temporary password is generated for root@localhost: d:Pev5_x8rd0#使用初始密码登录mysql -u root -p#回车，然后输入上一步查到的初始密码d:Pev5_x8rd0
7、更改初始密码ALTER USER 'root'@'localhost' IDENTIFIED BY 'Lengtu666!';//现在的mysql对密码强度要求较高，需要包含大小写字母、数字和特殊字符Lengtu666!替换成你的密码
8、开放3306端口，使其它客户机也可以访问MySQL服务CentOS蚀卺垦肝7默认使用的是firewall作为防火墙，我这里改为习惯常用的iptables防火墙关闭防火墙systemctl stop firewalld.servicesystemctl disable firewalld.servicesystemctl mask firewalld.service安装iptables防火墙yum install -y iptables-services启动设置防火墙systemctl enable iptablessystemctl start iptables查看防火墙状态systemctl status iptables增加3306端口sudo vim /etc/sysconfig/iptables增加：-A INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT按键 “i”插入插入 -A INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT按Esc,输入“：qw”,即可保存退出重启防火墙使配置生效systemctl restart iptables.service
9、MySQL安装完成后，进行相关配置安装成功后，将其加入开机启咿蛙匆盗动systemctl enable mysqld启动mysql服务进程systemctl start mysqld配置罪焐芡拂mysql（设置密码等）mysql_secure_installationSet root password? [Y/n] y [设置root用户密码]Remove anonymous users? [Y/n] y [删除匿名用户]Disallow root login remotely? [Y/n] y [禁止root远程登录]Remove test database and access to it? [Y/n] y [删除test数据库]Reload privilege tables now? [Y/n] y [刷新权限]
