Centos7.2 mysql安装

yum install wget
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm;
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm;
sudo yum install mysql-server

$ mysql -u root
登录时有可能报这样的错：ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)，原因是/var/lib/mysql的访问权限问题。

sudo chown -R root:root /var/lib/mysql
root
然后，重启服务：
service mysqld restart

接下来登录重置密码：

mysql -u root
use mysql
select user,host,password from mysql.user;
update user set password='*BF7B173F1C146F576CC267F0BAEF5589A08404FB' where user='root';
//root123456
commit;
FLUSH PRIVILEGES;

退出前一定要创建新用户
create user 'iki'@'%' identified by 'root123456';
grant all privileges on *.* to iki@'%';
flush privileges;

delete from user where host='';//连不上的时候加这句
exit

yum install iptables-services
sudo vim /etc/sysconfig/iptables
    -A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
sudo service iptables restart