centos7下手动安装mysql5.6，并配置外部访问

官网下载5.6安装包，此处为5.6.16案例

链接: link

解压文件

tar -zxvf mysql-5.6.16-linux-glibc2.5-x86_64.tar.gz

移动文件夹并换名字到指定目录

mv mysql-5.6.16-linux-glibc2.5-x86_64 mysql
mv mysql /usr/local

添加mysql组和用户

groupadd mysql 新增组
useradd -r -g mysql mysql 添加用户指定组

赋予权限

chown -R mysql:mysql mysql

删除自带数据库

rpm -qa | grep mariadb
mariadb-libs-5.5.52-1.el7.x86_64
yum -y remove mariadb-libs-5.5.52-1.el7.x86_64

复制配置文件

cd /usr/local//mysql/support-files
cp my-default.cnf /etc/my.cnf

修改默认配置文件

vi /etc/my.cnf
在[mysqld]中添加：
datadir = /usr/local/mysql/data
log-error = /usr/local/mysql/data/error.log
pid-file = /usr/local/mysql/data/mysql.pid
user = mysql
tmpdir = /tmp
esc
wq!

复制mysql.server服务端工具

cd /usr/local/mysql/bin/support-files
cp mysql.server /etc/init.d/mysql //方便启动与关闭

配置环境变量

vi /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
esc
wq!
source /etc/profile

安装数据库

cd /usr/local/mysql/scripts
./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

配置开机自启

chkconfig --add mysql
chkconfig mysql on

启动mysql

service mysql start

配置初始密码

mysqladmin -u root password ‘your_password’ #修改root用户密码

登陆数据库

mysql -u root -p
输入root用户密码

配置外部访问

GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘your_password’ WITH GRANT OPTION;
flush privileges;
exit;

配置防火墙规则，开放3306端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload //重启