• centos7.6 mysql5.7


    1.卸载 先停掉mysql进程 没有安装过的可以直接跳过
    pkill -9 mysqld

    rpm -qa|grep -i mysql

    用命令 yum -y remove

    yum -y remove mysql-community-client-5.6.38-2.el7.x86_64

    卸载不掉的用 rpm -ev

    依次卸载 直到没有

    2.下载mysql的repo源 这个安装的mysql5.7.20
    wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
    rpm -ivh mysql57-community-release-el7-8.noarch.rpm
    yum -y install mysql-server
    默认配置文件路径:
    配置文件:/etc/my.cnf
    日志文件:/var/log/var/log/mysqld.log
    服务启动脚本:/usr/lib/systemd/system/mysqld.service
    socket文件:/var/run/mysqld/mysqld.pid

    3.配置 my.cnf vim /etc/my.cnf
    [mysqld]
    #
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    #
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    #
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    server_id = 1
    expire_logs_days = 3

    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0

    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    #简化密码用
    validate_password=off
    default_password_lifetime=0
    4. 启动mysql服务
    service mysqld restart
    查看密码

    grep "password" /var/log/mysqld.log
    修改密码并设置远程访问

    grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;

    flush privileges;


  • 相关阅读:
    WinForm 应用程序的打包和部署_简单版(图文)
    WinForm 程序的运行框架与启动流程简介(图文)
    WinForm 实现两个容器之间控件的拖动及排列(图文)
    Web Service 基本概念和技术应用
    Visual Basic不可能消失
    俺是怎样做研究生导师的[ZT]
    细 节 决 定 成 败
    阻碍GIS产业发展的三大问题
    世界第一CEO的人格特征和经营想念【转载】
    [转载]关于创办软件公司的几点思考
  • 原文地址:https://www.cnblogs.com/ruiy/p/15133457.html
Copyright © 2020-2023  润新知