Mysql5.6数据库安装步骤:
//1. 下载mysql的repo源
# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
//2.安装mysql-community-release-el7-5.noarch.rpm包
# sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
//安装这个包后,会获得两个mysql的yum repo源:/etc/yum.repos.d/mysql-community.repo,/etc/yum.repos.d/mysql-community-source.repo。
//安装mysql
# sudo yum install mysql-server
//设置 MySQL 数据库 root 用户的密码:
# mysqladmin -u root password 'root'
//登录数据库:
# mysql -u root -p
//MySQL 授权ROOT用户远程访问(先用 root 登录 mysql) ,本文仅做示例,不建议 ROOT用户对外开放访问,可以指定用户对面开放!
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'wusc.321' WITH GRANT OPTION; mysql> FLUSH PRIVILEGES;
//查看到 MySQL 并没有设置开机启动
# chkconfig //list | grep mysqld
mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off
//所以需要设置开机启动
# chkconfig mysqld on
//为了方便远程管理,防火墙中打开 3306 端口
# vi /etc/sysconfig/iptables
-A INPUT -m state //state NEW -m tcp -p tcp //dport 3306 -j ACCEPT
//重启防火墙,使端口配置生效
# service iptables restart