股票交易接口url-2.centos安装mysql

重置密码

# 查看临时密码
grep password /var/log/股票交易接口url,股票交易接口url,mysqld.log
# 登录
股票交易接口url,股票交易接口url,mysql -uroot -p  -回车-> 输入临时密码
# 修改密码
set password = password("密码");
# 如果上一个修改命令失败请使用这个命令
alter user user() identified by "密码";

刷新防火墙

2.centos安装mysql

启动mysql

# 查看是否启动
systemctl restart mysqld.service
# 启动
service mysqld start | systemctl status mysqld

安装

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

上传到服务器并解压

# 进入上传的路径
cd /opt
# 修改权限
chmod 777 mysql-8.0.33-xxxxx.tar
# 解压文件
tar -xvf mysqlxxxxxx.tar
# 修改解压出来的文件权限
chmod 777 ./*

2.centos安装mysql

配置远程访问

# 切换到mysql数据库
use mysql;
# 查看用户表
select user,host from user;
# 修改root账户可以任意ip访问
update user set host="%" where user="root";
# 刷新用户权限
flush privileges;

错误解决

error: Failed dependencies:
        mariadb-libs is obsoleted by mysql-community-libs-8.0.29-1.el7.x86_64
解决：yum remove mysql-libs

文章为作者独立观点，不代表股票配资公司观点