下载
上传到服务器并解压
# 进入上传的路径
cd /opt
# 修改权限
chmod 777 mysql-8.0.33-xxxxx.tar
# 解压文件
tar -xvf mysqlxxxxxx.tar
# 修改解压出来的文件权限
chmod 777 ./*
安装
rpm -ivh mysql-community-common-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.27-1.el7.x86_64.rpm
错误解决
error: Failed dependencies:
mariadb-libs is obsoleted by mysql-community-libs-8.0.29-1.el7.x86_64
解决:yum remove mysql-libs
启动mysql
# 查看是否启动
systemctl restart mysqld.service
# 启动
service mysqld start | systemctl status mysqld
重置密码
# 查看临时密码
grep password /var/log/mysqld.log
# 登录
mysql -uroot -p -回车-> 输入临时密码
# 修改密码
set password = password("密码");
# 如果上一个修改命令失败请使用这个命令
alter user user() identified by "密码";
配置远程访问
# 切换到mysql数据库
use mysql;
# 查看用户表
select user,host from user;
# 修改root账户可以任意ip访问
update user set host="%" where user="root";
# 刷新用户权限
flush privileges;
放开服务器防火墙
# 放开服务端口
firewall-cmd --zone=public --permanent --add-port=3306/tcp
# 刷新防火墙
firewall-cmd --reload
刷新防火墙
文章为作者独立观点,不代表股票交易接口观点