CentOS7 安装mysql5.7

下载地址https://downloads.mysql.com/archives/community/

cd /usr/local

上传下载好的安装包到服务器解压

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

重命名解压后的包名

mv mysql-5.7.36-linux-glibc2.12-x86_64 mysql
cd /usr/local/mysql/support-files

创建用户组、用户用于管理mysql

groupadd redwine

useradd -g redwine redwine

chown -R redwine:redwine /usr/local/mysql

chmod -R 755 /usr/local/mysql

初始化数据库

cd /usr/local/mysql/bin
./mysqld --initialize --user=redwine --datadir=/usr/local/mysql/data --basedir=/usr/local

初始化完成后复制好初始密码

 创建配置文件

vim /etc/my.cnf

 编辑添加如下配置（user配置不添加启动时可能会报错）

[mysqld]
server-id=1
datadir=/usr/local/mysql/data
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=400
innodb_file_per_table=1
lower_case_table_names=1
basedir = /usr/local/mysql
socket = /tmp/mysql.sock
user=root
pid-file = /usr/local/mysql/data/localhost.localdomain.pid

给配置文件添加权限 

chmod -R 775 /etc/my.cnf
chown -R redwine:redwine /etc/my.cnf

 添加软连接并设置开机自启

//添加软连接
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
//重启mysql服务
service mysql restart
//添加服务
cd /etc/init.d
chkconfig --add mysqld

重置密码并设置远程链接

mysql -uroot -p
set password for root@localhost = password('123456');
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;