• Linux-部署mysql


    1. 下载 mysql 安装包

    wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

    这一步本人是在window下载,通过ftp 传送到Linux root目录下  (https://www.cnblogs.com/yimihua-kai/p/11663192.html)

    2. 安装mysql源

    yum localinstall mysql57-community-release-el7-8.noarch.rpm

    3.检查mysql源是否安装成功

    yum repolist enabled | grep "mysql.*-community.*"

    4. 安装

    yum install mysql-community-server

    5. 启动

    systemctl start mysqld

    6. 获取临时登录密码

    grep 'temporary password' /var/log/mysqld.lo

    7. 用临时登录密码登录mysql

    mysql –u root –p

    Password:填写临时登录密码

    8. 修改密码 

    set password =password(‘123456’)

    出现问题:ERROR 1819 (HY000): Your password does NOT satisfy the CURRENT policy requirements。

    解决方案:密码长度限制问题

    set global validate_password_policy=0  (修改validate_password_policy参数的值)

    set global validate_password_length=1  (validate_password_length(密码长度))

    再次修改密码:Mysqy->set  password =password(‘123456’)

    9. 授权,可以使用root远程登录mysql,不限定IP地址

    ->GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY “123456”;

    10. 重新加载权限数据

    flush privileges;

    exit

    11. 开机自启动 mysql

    systemctl enable mysqld

    systemctl daemon-reload

    12. 添加防火墙白名单

    #配置端口访问

    firewall-cmd --permanent --zone=public --add-port=3306/tcp

    #reload配置生效

    firewall-cmd –reload

    查看所有打开的端口:

    firewall-cmd --zone=public --list-ports

    查看状态: systemctl status firewalld

    重启服务: systemctl restart  firewalld

  • 相关阅读:
    lightoj 1151 Snakes and Ladders 期望 高斯消元
    lightoj 1104 Birthday Paradox 概率
    lightoj 1079 Just another Robbery 概率 背包
    集合的划分
    线性筛法
    学姐出的毒奶题之yjj
    [poj] 1149 PIGS || 最大流经典题目
    [poj] 3057 Evacuation
    [poj] 1273 Drainage Ditches
    [poj] 2891 Strange Way to Express Integers
  • 原文地址:https://www.cnblogs.com/yimihua-kai/p/11662835.html
Copyright © 2020-2023  润新知