CentOS下安装Mysql

一、Mysql 相关

1.安装下载mysql-server

#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

2.安装成功后，重启Mysql

#service mysqld restart

3.设置密码

mysql> set password for 'root'@'localhost' =password('password');.

4.远程连接设置

把在所有数据库的所有表的所有权限赋值给位于所有IP地址的root用户。

mysql> grant all privileges on *.* to root@'%'identified by 'password';

5.更新权限

mysql> FLUSH PRIVILEGES;

6.配置mysql编码

# vi /etc/my.cnf
[mysql]
default-character-set =utf8

7. 开机自启动

---

1 vim /etc/rc.local
2 添加service mysqld start

二、防火墙相关

1、关闭firewall：
停止firew

systemctl stop firewalld.service

开机启动

systemctl disable firewalld.service

查看默认防火墙状态（关闭后显示notrunning，开启后显示running）

firewall-cmd --state 

开机禁止防火墙开启

systemctl disable firewalld.service