1. Adding the MySQL Yum Repository

    First, add the MySQL Yum repository to your system's
    repository list. Follow these steps:

    1. Go to the download page for MySQL Yum repository at
      https://dev.mysql.com/downloads/repo/yum/.

    2. Select and download the release package for your
      platform.

    3. Install the downloaded release package with the
      following command, replacing
      platform-and-version-specific-package-name
      with the name of the downloaded package:

      Press CTRL+C to copy
      shell> sudo rpm -Uvh platform-and-version-specific-package-name.rpm

      For example, for version n of
      the package for EL6-based systems, the command is:

      Press CTRL+C to copy
      shell> sudo rpm -Uvh mysql80-community-release-el6-n.noarch.rpm
    Note

    Once the release package is installed on your system, any
    system-wide update by the yum update
    command (or dnf upgrade for dnf-enabled
    systems) will automatically upgrade MySQL packages on your
    system and also replace any native third-party packages, if
    Yum finds replacements for them in the MySQL Yum repository.
    See Upgrading MySQL with the MySQL Yum Repository and
    Replacing a Native Third-Party Distribution of MySQL for details.

  2. Selecting a Release Series

    When using the MySQL Yum repository, the latest GA release of
    MySQL is selected for installation by default. If this is what
    you want, you can skip to the next step,
    Installing MySQL with Yum.

    Within the MySQL Yum repository
    (https://repo.mysql.com/yum/),
    different release series of the MySQL Community Server are
    hosted in different subrepositories. The subrepository for the
    latest GA series (currently MySQL 8.0)

          is enabled by default, and the subrepositories for all other
    series (for example, the MySQL 5.7 series) are
    disabled by default. Use this command to see all the
    subrepositories in the MySQL Yum repository, and see which of
    them are enabled or disabled (for dnf-enabled systems, replace
    <span class="command"><strong>yum</strong></span> in the command with
    <span class="command"><strong>dnf</strong></span>):
    Press CTRL+C to copy
    shell> yum repolist all | grep mysql

    To install the latest release from the latest GA series, no
    configuration is needed. To install the latest release from a
    specific series other than the latest GA series, disable the
    subrepository for the latest GA series and enable the
    subrepository for the specific series before running the
    installation command. If your platform supports the
    yum-config-manager or dnf
    config-manager
    command, you can do that by issuing,
    for example, the following commands, which disable the
    subrepository for the 8.0 series and enable the
    one for the 5.7 series; for platforms that are
    not dnf-enabled:

    Press CTRL+C to copy
    shell> sudo yum-config-manager --disable mysql80-community
    shell> sudo yum-config-manager --enable mysql57-community

    For dnf-enabled platforms:

    Press CTRL+C to copy
    shell> sudo dnf config-manager --disable mysql80-community
    shell> sudo dnf config-manager --enable mysql57-community

    Besides using yum-config-manager or the
    dnf config-manager command, you can also
    select a series by editing manually the
    /etc/yum.repos.d/mysql-community.repo
    file. This is a typical entry for a release series'
    subrepository in the file:

    Press CTRL+C to copy
    [mysql80-community]
    name=MySQL 8.0 Community Server
    baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
    enabled=1
    gpgcheck=1
    gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
          Find the entry for the subrepository you want to configure,
    and edit the <code class="option">enabled</code> option. Specify
    <code class="option">enabled=0</code> to disable a subrepository, or
    <code class="option">enabled=1</code> to enable a subrepository. For
    example, to install MySQL 5.7, make sure you
    have <code class="option">enabled=0</code> for the above subrepository
    entry for MySQL 8.0, and have
    <code class="option">enabled=1</code> for the entry for the
    5.7 series:
    </p><div class="copytoclipboard-wrapper" style="position: relative;"><pre class="programlisting line-numbers language-ini"><div class="docs-select-all right" id="sa47436371" style="display: none;"><div class="copy-help left" style="display: none;">Press CTRL+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class=" language-ini"><span class="token comment" spellcheck="true"># Enable to use MySQL 5.7</span>

    [mysql57-community]

    name=MySQL 5.7 Community Server

    baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/

    enabled=1

    gpgcheck=1

    gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

You should only enable subrepository for one release series at

any time. When subrepositories for more than one release

series are enabled, the latest series will be used by Yum.

Verify that the correct subrepositories have been enabled and

disabled by running the following command and checking its

output (for dnf-enabled systems, replace

yum in the command with

dnf):

Press CTRL+C to copy
shell> yum repolist enabled | grep mysql
  • Installing MySQL

    Install MySQL by the following command (for dnf-enabled
    systems, replace yum in the command with
    dnf):

    Press CTRL+C to copy
    shell> sudo yum install mysql-community-server

    This installs the package for the MySQL server, as well as
    other required packages.

  • Starting the MySQL Server

    Start the MySQL server with the following command:

    Press CTRL+C to copy
    shell> sudo service mysqld start

    For EL7-based platforms, this is the preferred command:

    Press CTRL+C to copy
    shell> sudo systemctl start mysqld.service

    You can check the status of the MySQL server with the
    following command:

    Press CTRL+C to copy
    shell> sudo service mysqld status

    For EL7-based platforms, this is the preferred command:

    Press CTRL+C to copy
    shell> sudo systemctl status mysqld.service

    MySQL Server Initialization (as of MySQL
    5.7):
    At the initial start up of the server, the
    following happens, given that the data directory of the server
    is empty:

    • The server is initialized.

    • An SSL certificate and key files are generated in the data
      directory.

    • The validate_password
      plugin
      is installed and enabled.

    • A superuser account 'root'@'localhost'
      is created. A password for the superuser is set and stored
      in the error log file. To reveal it, use the following
      command:

      Press CTRL+C to copy
      shell> sudo grep 'temporary password' /var/log/mysqld.log

      Change the root password as soon as possible by logging in
      with the generated, temporary password and set a custom
      password for the superuser account:

      Press CTRL+C to copy
      shell> mysql -uroot -p
      Press CTRL+C to copy
      mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
    Note

    MySQL's
    validate_password
    plugin is installed by default. This will require that
    passwords contain at least one upper case letter, one lower
    case letter, one digit, and one special character, and that
    the total password length is at least 8 characters.

  • 最新文章

    1. 队列的JS实现
    2. OpenCV在VS2005下的配置
    3. Java多线程系列--“基础篇”02之 常用的实现多线程的两种方式
    4. r-cnn学习系列(三):从r-cnn到faster r-cnn
    5. Android自动化测试框架
    6. code异常处理
    7. [转载] Android Metro风格的Launcher开发系列第一篇
    8. extjs ajax请求与struts2进行交互
    9. FileReader 的了解
    10. 7第七章联接和APPLY运算符(转载)
    11. easyui中datagrid标题居中内容居左实现方式
    12. 用IO流拷贝歌曲
    13. Anniversary party(POJ 2342 树形DP)
    14. Mongoose的使用
    15. poj2578---三个数中找出第一个大于168的
    16. ILayer
    17. jqery 图片等 比例缩放
    18. PHP中单引号与双引号的区别
    19. LeetCode算法题-Min Cost Climbing Stairs(Java实现)
    20. js的==和===练习

    热门文章

    1. 【基础知识】CPU指令集
    2. ssh静态代理模式讲解与使用
    3. mataplotlib篇(开篇)
    4. 大学英语四级之听力Key Words
    5. pandas 中dataframe的操作
    6. 自定义 serializers.ValidationError 的错误返回
    7. Linux环境下安装Java JDK
    8. java后端工程师学习路线
    9. layui 表单的使用
    10. VuePress 博客之 SEO 优化(二)重定向