【金沙官网线上】Linux下安装mysql

安装前,需要卸载所有的mariadb软件: yum remove mariadb*

1.前期准备工作

获取mysql的yum容器:wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

更新 yum 源,自带的源没有 PHP5.6

安装mysql的yum容器:rpm -ivh mysql-community-release-el7-5.noarch.rpm

rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

加载容器清单到/var/cache/yum:yum list mysql-community-client

rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm

安装mysql服务:yum install mysql-community-client.x86_64 mysql-community-common.x86_64 mysql-community-devel.x86_64 mysql-community-libs.x86_64 mysql-community-server.x86_64

yum install update

启动mysql:service mysqld start
sudo systemctl start tomcat 启动tomcat

2.防火墙  

一、配置防火墙,开启80端口、3306端口
CentOS 7.0默认使用的是firewall作为防火墙,这里改为iptables防火墙。
1、关闭firewall:
systemctl stop firewalld.service #停止firewall
systemctl disable firewalld.service #禁止firewall开机启动
2、安装iptables防火墙
yum install iptables-services #安装
vi /etc/sysconfig/iptables #编辑防火墙配置文件
# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT
:wq! #保存退出
systemctl restart iptables.service #最后重启防火墙使配置生效
systemctl enable iptables.service #设置防火墙开机启动
二、关闭SELINUX
vi /etc/selinux/config
#SELINUX=enforcing #注释掉
#SELINUXTYPE=targeted #注释掉
SELINUX=disabled #增加
:wq! #保存退出
setenforce 0 #使配置立即生效

设置密码:mysqladmin -u root password "accp"

3.安装Mysql/Mariadb

登陆:mysql -u root -paccp

安装 Mariadb: yum -y install mariadb.x86_64 mariadb-server.x86_64 mariadb-devel.x86_64

use mysql;
设置权限:grant all privileges on *.* to 'root'@'%' identified by 'accp';
刷新:flush privileges;

使用下面命令设置root密码:mysql_secure_installation

关闭firewall:service firewalld stop
      systemctl disable firewalld.service #禁止firewall开机启动

从最新版本的linux系统开始,默认的是 Mariadb而不是mysql!

本文由金沙官网线上发布于操作系统,转载请注明出处:【金沙官网线上】Linux下安装mysql

您可能还会对下面的文章感兴趣: