下载地址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;