Centos7快速安装Mysql

Mysql教程

配置防火墙,开启3306端口。

CentOS 7.0默认使用的是firewall作为防火墙,这里改为iptables防火墙。

#停止firewall服务
systemctl stop firewalld.service
#禁止firewall开机启动
systemctl disable firewalld.service

#安装
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 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
3. 关闭seinux
#修改配置文件
vi /etc/selinux/config

#SELINUX=enforcing #注释掉
#SELINUXTYPE=targeted #注释掉
SELINUX=disabled #增加
:wq! #保存退出
#使配置立即生效
setenforce 0

安装mysql

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server
成功安装之后重启mysql服务

service mysqld restart

初次安装mysql是root账户是没有密码的
设置密码的方法:

输入mysql -uroot进入mysql数据库
mysql> set password for ‘root’@‘localhost’ = password(‘newpasswd’);
重点*可能不对改为#设置msyql密码为 123456
mysql> set password for ‘root’@’localhost’ =password(‘123456’);

远程授权连接mysql
mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root’@’localhost’ IDENTIFIED BY ‘你要设置的数据库密码’ WITH GRANT OPTION;

mysql>GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘你要设置的数据库密码’ WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES; #更新权限

Centos7快速安装Mysql配置ok

成为第一个发表评论的人

发表评论

您的电子邮件地址不会被公开.


*