{"id":4339,"date":"2019-10-02T22:51:15","date_gmt":"2019-10-02T19:51:15","guid":{"rendered":"https:\/\/kifarunix.com\/?p=4339"},"modified":"2024-03-12T22:28:49","modified_gmt":"2024-03-12T19:28:49","slug":"install-mysql-8-on-centos-8","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/install-mysql-8-on-centos-8\/","title":{"rendered":"Install MySQL 8 on CentOS 8"},"content":{"rendered":"\n

This guide will take you through how to install MySQL 8 on CentOS 8. MySQL <\/a>is one of the famous opensource relational database management system.<\/p>\n\n\n\n

Installing MySQL 8 on CentOS 8<\/h2>\n\n\n\n

MySQL 8 is available for installation on the AppStream repos for CentOS 8. The AppStream repos are enabled by default.<\/p>\n\n\n\n

dnf whatprovides mysql<\/code><\/pre>\n\n\n\n
mysql-8.0.13-1.module_el8.0.0+41+ca30bab6.x86_64 : MySQL client programs and shared libraries\nRepo        : AppStream\nMatched from:\nProvide    : mysql = 8.0.13-1.module_el8.0.0+41+ca30bab6<\/code><\/pre>\n\n\n\n
Hence, MySQL 8 server can simply be installed by running the command below;<\/p>\n\n\n\n
dnf install mysql-server<\/code><\/pre>\n\n\n\n
To install MySQL 8 client;<\/p>\n\n\n\n
dnf install mysql<\/code><\/pre>\n\n\n\n
To install both MySQL 8 server and client;<\/p>\n\n\n\n
dnf install @mysql<\/code><\/pre>\n\n\n\n
...\n=======================================================================================================================================================\n Package                                   Arch                  Version                                                Repository                Size\n=======================================================================================================================================================\nInstalling group\/module packages:\n mysql-server                              x86_64                8.0.13-1.module_el8.0.0+41+ca30bab6                    AppStream                 25 M\nInstalling dependencies:\n mariadb-connector-c-config                noarch                3.0.7-1.el8                                            AppStream                 13 k\n mecab                                     x86_64                0.996-1.module_el8.0.0+41+ca30bab6.9                   AppStream                397 k\n mysql                                     x86_64                8.0.13-1.module_el8.0.0+41+ca30bab6                    AppStream                9.2 M\n mysql-common                              x86_64                8.0.13-1.module_el8.0.0+41+ca30bab6                    AppStream                142 k\n mysql-errmsg                              x86_64                8.0.13-1.module_el8.0.0+41+ca30bab6                    AppStream                523 k\n protobuf-lite                             x86_64                3.5.0-7.el8                                            AppStream                150 k\nInstalling module profiles:\n mysql\/server                                                                                                                                         \nEnabling module streams:\n mysql                                                           8.0                                                                                  \n\nTransaction Summary\n=======================================================================================================================================================\nInstall  7 Packages\n\nTotal download size: 36 M\nInstalled size: 243 M\nIs this ok [y\/N]: y<\/code><\/pre>\n\n\n\n
Running MySQL 8 on CentOS 8<\/h3>\n\n\n\n
Once the installation completes, start and enable MySQL 8 server to run on system boot.<\/p>\n\n\n\n
systemctl start mysqld<\/code><\/pre>\n\n\n\n
systemctl enable mysqld<\/code><\/pre>\n\n\n\n
To check the status of MySQL 8 server;<\/p>\n\n\n\n
systemctl status mysqld<\/code><\/pre>\n\n\n\n
\u25cf mysqld.service - MySQL 8.0 database server\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/mysqld.service; enabled; vendor preset: disabled)\n   Active: active (running) since Wed 2019-10-02 13:19:32 EDT; 42s ago\n Main PID: 29142 (mysqld)\n   Status: \"SERVER_OPERATING\"\n    Tasks: 38 (limit: 11512)\n   Memory: 466.4M\n   CGroup: \/system.slice\/mysqld.service\n           \u2514\u250029142 \/usr\/libexec\/mysqld --basedir=\/usr\n\nOct 02 13:19:20 localhost.localdomain systemd[1]: Starting MySQL 8.0 database server...\nOct 02 13:19:20 localhost.localdomain mysql-prepare-db-dir[29057]: Initializing MySQL database\nOct 02 13:19:32 localhost.localdomain systemd[1]: Started MySQL 8.0 database server.<\/code><\/pre>\n\n\n\n
MySQL 8 Initial Security<\/h3>\n\n\n\n
By default, MySQL ships with security script that is used to remove test MySQL server databases, remove anonymous users in the database, disable remote root login, set the password strength. To run the script, simply execute the command;<\/p>\n\n\n\n
mysql_secure_installation<\/code><\/pre>\n\n\n\n
When run, you are prompted whether to enable or disable password policy. If enabled, set the password policy and create the password that matches your chosen policy.<\/p>\n\n\n\n
VALIDATE PASSWORD COMPONENT can be used to test passwords\nand improve security. It checks the strength of password\nand allows the users to set only those passwords which are\nsecure enough. Would you like to setup VALIDATE PASSWORD component?\n\nPress y|Y for Yes, any other key for No: y\n\nThere are three levels of password validation policy:\n\nLOW    Length >= 8\nMEDIUM Length >= 8, numeric, mixed case, and special characters\nSTRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file\n\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 2\nPlease set the password for root here.\n\nNew password: \n\nRe-enter new password: \n\nEstimated strength of the password: 100 \nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y<\/code><\/pre>\n\n\n\n
Next, remove anonymous users, disallow remote root login, remove test database and reload privileges tables to effect the changes made.<\/p>\n\n\n\n
You can now login to your MySQL 8 server as a root user with the password set above.<\/p>\n\n\n\n
mysql -u root -p<\/code><\/pre>\n\n\n\n
To show MySQL version, you can run the query;<\/p>\n\n\n\n
show variables like \"version%\";<\/code><\/pre>\n\n\n\n
+-------------------------+---------------------+\n| Variable_name           | Value               |\n+-------------------------+---------------------+\n| version                 | 8.0.13              |\n| version_comment         | Source distribution |\n| version_compile_machine | x86_64              |\n| version_compile_os      | Linux               |\n| version_compile_zlib    | 1.2.11              |\n+-------------------------+---------------------+<\/code><\/pre>\n\n\n\n
You can as well run the command below on command line to show database version.<\/p>\n\n\n\n
mysql -V<\/code><\/pre>\n\n\n\n
mysql  Ver 8.0.13 for Linux on x86_64 (Source distribution)<\/code><\/pre>\n\n\n\n
That is all on how to install MySQL 8.<\/p>\n\n\n\n
Similar Tutorials<\/h3>\n\n\n\n
Install MySQL 8 on Debian 10 Buster<\/a><\/p>\n\n\n\n
Install LEMP Stack with MySQL 8 on Fedora 30\/Fedora 29<\/a><\/p>\n\n\n\n
Install MySQL 8 on FreeBSD 12<\/a><\/p>\n\n\n\n
Install MySQL 8 on Debian 9<\/a><\/p>\n\n\n\n
Install MySQL 8 on Fedora 30\/Fedora 29<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
This guide will take you through how to install MySQL 8 on CentOS 8. MySQL is one of the famous opensource relational database management system.<\/p>\n","protected":false},"author":1,"featured_media":9395,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[299,121,929],"tags":[1142,3763,3762,135,999,3764],"class_list":["post-4339","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-howtos","category-mysql","tag-centos-8","tag-centos-8-mysql-8","tag-install-mysql-8-centos-8","tag-mysql","tag-mysql-8","tag-mysql-8-centos-8","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50","resize-featured-image"],"_links":{"self":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/4339"}],"collection":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/comments?post=4339"}],"version-history":[{"count":5,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/4339\/revisions"}],"predecessor-version":[{"id":21240,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/4339\/revisions\/21240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media\/9395"}],"wp:attachment":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media?parent=4339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=4339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=4339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}