侧边栏壁纸
  • 累计撰写 38 篇文章
  • 累计创建 8 个标签
  • 累计收到 3 条评论

目 录CONTENT

文章目录

linux通过rpm安装mysql并开启远程访问

Administrator
2022-08-21 / 0 评论 / 0 点赞 / 203 阅读 / 0 字
温馨提示:
部分素材来自网络,若不小心影响到您的利益,请联系我们删除。

1.去下面列表页面下载MySql的rpm包 选择自己对应的版本
https://dev.mysql.com/downloads/mysql/
2.在linux服务器上下载文件

wget   https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.30-1.el7.x86_64.rpm-bundle.tar

//下载之后开始解压文件
tar -xvf mysql-8.0.30-1.sl15.x86_64.rpm-bundle.tar
//解压之后得到几个rpm文件。依次安装他们

rpm  -ivh mysql-community-common-8.0.30-1.el7.x86_64.rpm
rpm  -ivh mysql-community-client-plugins-8.0.30-1.el7.x86_64.rpm
rpm  -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpm 
 rpm  -ivh mysql-community-client-8.0.30-1.el7.x86_64.rpm
 rpm  -ivh mysql-community-icu-data-files-8.0.30-1.el7.x86_64.rpm
 yum install net-tools
 rpm  -ivh mysql-community-server-8.0.30-1.el7.x86_64.rpm 
 
 
 # 启动mysql数据库
 systemctl start mysqld

查看临时密码
grep “A temporary password” /var/log/mysqld.log
此时可以看到mysql的临时密码,登陆上去修改
[root@localhost ~]# grep “A temporary password” /var/log/mysqld.log
2022-08-22T15:47:46.261021Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ebDgCiXfj8,X

mysql -u root -p
进入mysql后,修改密码。刷新权限
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码' PASSWORD EXPIRE NEVER;
最后可选操作。打开远程连接
use mysql;
update user set host="%" where user="root";

操作完成后刷新权限
FLUSH PRIVILEGES;
0
  1. 支付宝打赏

    qrcode alipay
  2. 微信打赏

    qrcode weixin

评论区