• mysql5.7 rpm方式安装


    tar -xvf mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar
    得到如下各文件:
    mysql-community-client-5.7.32-1.el7.x86_64.rpm
    mysql-community-common-5.7.32-1.el7.x86_64.rpm
    mysql-community-devel-5.7.32-1.el7.x86_64.rpm
    mysql-community-embedded-5.7.32-1.el7.x86_64.rpm
    mysql-community-embedded-compat-5.7.32-1.el7.x86_64.rpm
    mysql-community-embedded-devel-5.7.32-1.el7.x86_64.rpm
    mysql-community-libs-5.7.32-1.el7.x86_64.rpm
    mysql-community-libs-compat-5.7.32-1.el7.x86_64.rpm
    mysql-community-server-5.7.32-1.el7.x86_64.rpm
    mysql-community-test-5.7.32-1.el7.x86_64.rpm


    1.删除掉mysql-libs
    [root@hxlhost mysql]# mount /dev/cdrom /mnt
    mount: /dev/sr0 is write-protected, mounting read-only
    [root@hxlhost mysql]#  yum remove mysql-libs

    2.按照如下顺序进行安装
    rpm -ivh mysql-community-common-5.7.32-1.el7.x86_64.rpm
    rpm -ivh mysql-community-libs-5.7.32-1.el7.x86_64.rpm
    rpm -ivh mysql-community-client-5.7.32-1.el7.x86_64.rpm
    rpm -ivh mysql-community-server-5.7.32-1.el7.x86_64.rpm

    3.安装路径
    [root@hxlhost mysql]# which mysql
    /usr/bin/mysql

    4.启动
    [root@hxlhost mysql]# systemctl start mysqld

    查看状态:
    # systemctl status mysqld

    5.登陆:
    这种方式安装好后,会再my.cnf文件中自动生成一个密码,执行看一下吧:
    [root@hxlhost mysql]# cat /var/log/mysqld.log | grep password
    2020-11-17T01:26:13.319001Z 1 [Note] A temporary password is generated for root@localhost: _(V4*%4x.3&T

    [root@hxlhost mysql]# mysql -h localhost -uroot -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or g.
    Your MySQL connection id is 2
    Server version: 5.7.32

    Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

    mysql>

    6.my.cnf文件
    该文件路径为/etc/my.cnf
    内容如下:
    [root@hxlhost mysql]# more /etc/my.cnf
    # For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

    [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

    # 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

    -- The End --

  • 相关阅读:
    隐性改变display类型
    垂直居中-父元素高度确定的多行文本(方法二)
    去掉WIN7 桌面图标的小箭头
    搭建高可用mongodb集群(三)—— 深入副本集内部机制
    搭建高可用mongodb集群(二)—— 副本集
    搭建高可用mongodb集群(一)——配置mongodb
    Linux:Tomcat报错: Error creating bean with name 'mapScheduler' defined in ServletContext resource 的解决方法
    LINUX ORACLE 启动与关闭
    Linux 安装 Oracle 11g R2
    ORACLE 数据库优化原则
  • 原文地址:https://www.cnblogs.com/hxlasky/p/13992583.html
Copyright © 2020-2023  润新知