CentOS 7下安装MySQL

--下载MySQL5.7

cd /usr/local/src

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz

--解压缩

tar zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz

mv mysql-5.7.19-linux-glibc2.12-x86_64 /usr/local/mysql

--添加mysql用户

useradd -M -s /sbin/nologin mysql

mkdir -p /usr/local/mysql/data/mysql

--授权当前目录为mysql

chown mysql /usr/local/mysql/data/mysql

./bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data/mysql

--拷贝mysql配置文件

cp support-files/my-default.cnf /etc/my.cnf

<--增加配置
basedir = /usr/local/mysql
datadir = //usr/local/mysql/data/mysql
socket = /tmp/mysql.sock

 -->

--拷贝mysqld

cp support-files/mysql.server /etc/init.d/mysqld

<--增加配置

basedir=/usr/local/mysql
datadir=/data/mysql

-->

--添加自启动

chkconfig --add mysqld
chkconfig --list

--开启服务

/etc/init.d/mysqld start

/usr/local/mysql/bin/mysql -uroot -p'123456'

--设置密码

set password = password('654321');

--重启服务

/etc/init.d/mysqld restart

/usr/local/mysql/bin/mysql -uroot -p

--修改密码

update mysql.user set authentication_string=password('123456') where user='root';

--设置允许外网访问

update mysql.user set host='%';

select user,host from mysql.user;

flush privileges;

--重启服务

systemctl restart mysqld

--防火墙开端口

iptables -I INPUT -p tcp --dport 3306 -j ACCEPT