{"id":4658,"date":"2021-02-18T12:25:31","date_gmt":"2021-02-18T12:25:31","guid":{"rendered":"https:\/\/linuxways.net\/?p=4658"},"modified":"2021-02-18T13:19:40","modified_gmt":"2021-02-18T13:19:40","slug":"how-to-install-mysql-version-8-on-red-hat-enterprise-linux-8","status":"publish","type":"post","link":"https:\/\/linuxways.net\/de\/red-hat\/how-to-install-mysql-version-8-on-red-hat-enterprise-linux-8\/","title":{"rendered":"How to Install MySQL Version 8 on Red Hat Enterprise Linux 8"},"content":{"rendered":"

MySQL is the most widely used open-source database management system, particularly in the area of application development. This guide describes how to install MySQL version 8 (the latest at the time of writing) via the MySQL yum repository on Red Hat Enterprise Linux (RHEL) 8.<\/p>\n

Prerequisite<\/h2>\n

You need to have sudo or root privileges in order to install MySQL on your system.<\/p>\n

Add the MySQL Yum Repository<\/h2>\n

First of all, run the command below to download the MySQL Yum repository package for RHEL 8.<\/p>\n

$ wget https:\/\/dev.mysql.com\/get\/mysql80-community-release-el8-1.noarch.rpm<\/strong><\/pre>\n
<\/strong><\/p>\n
Next, install the downloaded MySQL Yum repository package as follows.<\/p>\n
$ sudo yum install https:\/\/dev.mysql.com\/get\/mysql80-community-release-el8-1.noarch.rpm<\/strong><\/pre>\n
<\/strong><\/p>\n
Run the next command to verify that the MySQL Yum repository was successfully added.<\/p>\n
$ yum repolist enabled | grep -i mysql<\/strong><\/pre>\n
<\/strong><\/p>\n
Install MySQL Version 8<\/h2>\n
Once the MySQL Yum repository has been successfully added, you may now install MySQL with the command below.<\/p>\n
$ sudo yum install mysql-community-server<\/strong><\/pre>\n
Note:<\/strong> If you get an error message indicating that a match could not be found for the mysql-community-server, then you may need to first run the next command to disable the MySQL module.<\/p>\n
Apparently, this module hides packages provided by MySQL repositories. Once the MySQL module has been successfully disabled, you may run the previous command again to install MySQL.<\/p>\n
$ sudo yum module disable mysql<\/strong><\/pre>\n
<\/strong><\/p>\n
After the installation completes successfully, run the command below to verify the version of MySQL.<\/p>\n
$ mysql --version<\/strong><\/pre>\n
<\/strong><\/p>\n
Start the MySQL Server<\/h2>\n
Run the following command to start the MySQL server.<\/p>\n
$ sudo systemctl start mysqld<\/strong><\/pre>\n
Next, verify that the MySQL server started successfully with the command below<\/p>\n
$ sudo systemctl status mysqld<\/strong><\/pre>\n
<\/strong><\/p>\n
Secure the MySQL Server<\/h2>\n
Run the command below to retrieve the temporary password that was automatically created during installation for the MySQL root user.<\/p>\n
$ sudo grep 'temporary password' \/var\/log\/mysqld.log<\/strong><\/pre>\n
<\/strong><\/p>\n
Next, run the mysql_secure_installation script with the command below.<\/p>\n
$ sudo mysql_secure_installation<\/strong><\/pre>\n
When prompted, enter the temporary password you retrieved in the previous step. You should be prompted to:<\/p>\n
    \n
  1. Set a new password<\/li>\n
  2. Remove anonymous users<\/li>\n
  3. Disallow root login remotely<\/li>\n
  4. Remove test database<\/li>\n
  5. Reload the privilege tables<\/li>\n<\/ol>\n
    <\/p>\n
    Login to MySQL<\/h2>\n
    After the mysql_secure_installation script completes, you may now login to MySQL with the command below.<\/p>\n
    $ mysql -u root -p<\/strong><\/pre>\n
    Once logged in, let us create a sample database.<\/p>\n
    mysql> CREATE DATABASE company;<\/strong><\/pre>\n
    mysql> USE company;<\/strong><\/pre>\n
    <\/strong><\/p>\n
    Also, let us create a table as well as some records as follows.<\/p>\n
    mysql> CREATE TABLE departments ( dept_name varchar(25), dept_head varchar(25), dept_code char(7), PRIMARY KEY (dept_code) );<\/strong><\/pre>\n
    mysql> INSERT INTO departments VALUES (\u2018Information Technology\u2019, \u2018Olushola Akinye\u2019, \u2018IT\u2019), (\u2018Human Resources\u2019, \u2018Jane Doe\u2019, \u2018HR\u2019), (\u2018Digital Marketing\u2019, \u2018Peter Lagbaja\u2019, \u2018DMKT\u2019);<\/strong><\/pre>\n
    <\/strong><\/p>\n
    Now, we can display all records in the department’s table with the following query.<\/p>\n
    mysql> SELECT * FROM departments;<\/strong><\/pre>\n
    <\/strong><\/p>\n
    Remove or Uninstall MySQL<\/h2>\n
    If you would like to remove MySQL at any time, run the following command on the terminal.<\/p>\n
    sudo yum remove mysql-community*<\/pre>\n
    Conclusion<\/h2>\n
    If you followed all the steps above, you should now have a fully functioning MySQL server version 8 running on Red Hat Enterprise Linux 8. Feel free to reach out to us if anything is unclear or if you have any comments regarding this article.<\/p>","protected":false},"excerpt":{"rendered":"
    MySQL is the most widely used open-source database management system, particularly in the area of application development. This guide describes how to install MySQL version 8 (the latest…<\/p>","protected":false},"author":28,"featured_media":4670,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[165],"tags":[27,198],"class_list":["post-4658","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-red-hat","tag-mysql","tag-red-hat-enterprise-linux-8"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/4658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=4658"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/4658\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/4670"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=4658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=4658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=4658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}