centeros7 一个复制黏贴安装mysql

最新推荐文章于 2024-04-11 12:28:30 发布

zwhfyy

最新推荐文章于 2024-04-11 12:28:30 发布

阅读量717

点赞数

分类专栏： MySql

本文链接：https://blog.youkuaiyun.com/zwhfyy/article/details/83658413

版权

MySql 专栏收录该内容

39 篇文章

订阅专栏

 rpm -qa|grep mariadb 


rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
rpm -e --nodeps mariadb-server-5.5.56-2.el7.x86_64
rpm -e --nodeps mariadb-5.5.56-2.el7.x86_64


tar -xvf mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar

 
rpm -ivh mysql-community-common-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.24-1.el7.x86_64.rpm
service mysqld start

设置下允许远程登录

查看临时密码

  grep password /var/log/mysqld.log

  登陆mysql，输入上面的临时密码

  mysql -p


  重置密码：

  use mysql;
  set password = password("root");


  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
 
  flush privileges;

1、关闭firewall：

#停止firewall
#禁止firewall开机启动

systemctl stop firewalld.service

systemctl disable firewalld.service