MYSQL5.7二进制安装

yum -y install libaio
mkdir /app
mkdir -p /product/mysql/data
cd /app
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
tar -zxf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.31-linux-glibc2.12-x86_64 mysql
touch /product/mysql/mysqld.pid
touch /var/log/mysqld.log
chown -R mysql.mysql /product/mysql/
chown -R mysql.mysql /var/log/mysqld.log

touch /tmp/mysql.sock
chown -R mysql.mysql /tmp/mysql.sock

groupadd mysql
useradd -r -g mysql mysql

vim /etc/profile
export PATH=$PATH:/app/mysql/bin
source /etc/profile

vim /etc/my.cnf
[mysqld]
character-set-server=utf8
user=mysql
port=3306
basedir=/app/mysql
datadir=/product/mysql/data
socket=/tmp/mysql.sock

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/product/mysql/mysqld.pid

[client]
port=3306
socket=/tmp/mysql.sock

cd /app/mysql/bin/ && ./mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql
cp ../support-files/mysql.server /etc/rc.d/init.d/mysqld
service mysqld start

chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld

mysql -uroot -p
修改root密码：

mysql> alter user "root"@"localhost" identified by "新密码";

刷新权限：

mysql> flush privileges;

添加远程登录用户

mysql> grant all privileges on *.* to "用户名"@"IP地址" identified by "密码" with grant option;

开启防火墙mysql3306端口的外部访问
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

创建普通用户
create user liutao identified by "123456";